From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on inbox.vuxu.org X-Spam-Level: X-Spam-Status: No, score=-1.0 required=5.0 tests=DKIM_SIGNED,DKIM_VALID, HTML_MESSAGE,MAILING_LIST_MULTI,RCVD_IN_DNSWL_NONE autolearn=ham autolearn_force=no version=3.4.4 Received: (qmail 17486 invoked from network); 17 Feb 2021 03:32:45 -0000 Received: from minnie.tuhs.org (45.79.103.53) by inbox.vuxu.org with ESMTPUTF8; 17 Feb 2021 03:32:45 -0000 Received: by minnie.tuhs.org (Postfix, from userid 112) id 915439C871; Wed, 17 Feb 2021 13:32:40 +1000 (AEST) Received: from minnie.tuhs.org (localhost [127.0.0.1]) by minnie.tuhs.org (Postfix) with ESMTP id E4EB89B968; Wed, 17 Feb 2021 13:31:39 +1000 (AEST) Authentication-Results: minnie.tuhs.org; dkim=pass (2048-bit key; unprotected) header.d=ccil-org.20150623.gappssmtp.com header.i=@ccil-org.20150623.gappssmtp.com header.b="v9qe6eRc"; dkim-atps=neutral Received: by minnie.tuhs.org (Postfix, from userid 112) id 766C19B968; Wed, 17 Feb 2021 13:29:48 +1000 (AEST) Received: from mail-qk1-f174.google.com (mail-qk1-f174.google.com [209.85.222.174]) by minnie.tuhs.org (Postfix) with ESMTPS id 869039B966 for ; Wed, 17 Feb 2021 13:29:47 +1000 (AEST) Received: by mail-qk1-f174.google.com with SMTP id b14so11656735qkk.0 for ; Tue, 16 Feb 2021 19:29:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ccil-org.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=Zj+WLxQlpILO1+kJMfxjG93CUOiSeCFD65mE4lboxXE=; b=v9qe6eRc2zomq90L736zCbv21Eg9yny7tf9QiEDAg1wD7snA155kBjTPZh4X1DRRDI 3FQE3jGItQJFh0Ln/YPsa+4y6N/K3x5QzlI/Ann7oQgNFNR46795gzBdaVPd8vQ7LLMZ 1C2xlM1PPZ9U0tz+tcymvDxfqKg+MQ/uXgHIvqDbxV4LQ8WDMJJR9rpgryvwo61Utn26 COZRhLlZz4nkgrE2JjXYXsPsR7G7JtMgOEt4n3YX6751AMsjLnD4J64PvK0sasW1aXdj mwwtak+sviAREo5iN9GOcWlm/rijCXzDZQNJ9k5866Nozd7oe8xbUvstGA8khTkHW2bJ iKfQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=Zj+WLxQlpILO1+kJMfxjG93CUOiSeCFD65mE4lboxXE=; b=OND1xE4AsaTkh6yet1aVy+FbkBnbn9herI0EG4xYgZx6c734aBs2DKpUoVtu7U0tuK BY/aS8SEm/rln8et5K94r3EsPXeA/0F3hPZwPm3W2FBoOQ+obuKuwhNngCtxascl4NAA oXdMdM5FKpnWzA44tdOd71AMIk9EWdoAsM+QkMRNtFoC2p23YCiM1SSPgqhCs/LvQHE2 2wadkAIbfwRDbx/J8/CX9SBdN+ZyZflmiFTQKncneVo86WWJK6WQ18ENj/60E39FLGSO t8vFsBCPijVjpEy+M24x3h2Mw//fHZ0VULwSRtjQrDQauotSM4stVMZrGD2+hfNhwk5F j41Q== X-Gm-Message-State: AOAM533oDTxfQilJBU29uCtW4a3wxMXYFYaEDJWiGL0g2sf1m2MLyoT/ KRKK8OyfE32nLnnzvPL168ZtO6i8EoubPzGXoiDabw== X-Google-Smtp-Source: ABdhPJzao+fEmZIRe5BTk38A1mnKAyw+iUq/aywAZtNTzDsMAAjxqHAwkE9bL4An6H9dUa4Nm//JcIqap4WYZcjHDD0= X-Received: by 2002:a05:620a:13fb:: with SMTP id h27mr2445566qkl.426.1613532586590; Tue, 16 Feb 2021 19:29:46 -0800 (PST) MIME-Version: 1.0 References: <26484818-2f05-37d3-adff-6e34d383e117@gmail.com> In-Reply-To: <26484818-2f05-37d3-adff-6e34d383e117@gmail.com> From: John Cowan Date: Tue, 16 Feb 2021 22:29:35 -0500 Message-ID: To: Will Senn Content-Type: multipart/alternative; boundary="000000000000a8594e05bb7fd40f" Subject: Re: [TUHS] cut, paste, join, etc. X-BeenThere: tuhs@minnie.tuhs.org X-Mailman-Version: 2.1.26 Precedence: list List-Id: The Unix Heritage Society mailing list List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: TUHS main list Errors-To: tuhs-bounces@minnie.tuhs.org Sender: "TUHS" --000000000000a8594e05bb7fd40f Content-Type: text/plain; charset="UTF-8" I'm not sure what you're thinking of, but there is no login in SQLite: its only access control is at the DB level, and that's Unix file permissions. Carl Strozzi's NOSQL system (not to be confused with the concept of NoSQL databases) is a relational database built using ordinary Unix utilities and pipelines. Each table is a TSV file with a header line whose fields are the column names prefixed by ^A so that they always sort to the top. It also provides commands like "jointable", which is "join" wrapped in an awk script that collects the column names from the tables and does a natural join. The package can be downloaded from < http://www.strozzi.it/shared/nosql/nosql-4.1.11.tar.gz>. The documentation is shonky, but the code works nicely. On Tue, Feb 16, 2021 at 8:17 PM Will Senn wrote: > On 2/16/21 7:08 PM, M Douglas McIlroy wrote: > > Will Senn wrote, > > join seems like part of an aborted (aka never fully realized) attempt at a text based rdb to me > > As the original author of join, I can attest that there was no thought > of parlaying join into a database system. It was inspired by > databases, but liberated from them, much as grep was liberated from an > editor. > > Doug > > Nice! Thanks Doug. Too bad, though... one gets ever tired of having to log > into db's and a simple text db system would be useful. Even sqlite, which I > love, requires login to get at information... I'm already logged in, why > can't I just ask for my info and have it returned? > > Will > --000000000000a8594e05bb7fd40f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I'm not sure what you're thinking of= , but there is no login in SQLite: its only access control is at the DB lev= el, and that's Unix file permissions.

Carl Strozzi's NOSQL system=C2=A0(not to be confused with the= concept of NoSQL databases) is a relational database built using ordinary = Unix utilities and pipelines.=C2=A0 Each table is a TSV file with a header = line whose fields are the column names prefixed by ^A so that they always s= ort to the top.=C2=A0 It also provides commands like "jointable",= which is "join" wrapped in an awk script that collects the colum= n names from the tables and does a natural join.

The package can be downloaded from <http://www.strozzi.it/share= d/nosql/nosql-4.1.11.tar.gz>.=C2=A0 The documentation is shonky, but= the code works nicely.




On Tue, Feb 16, 2021 at 8:= 17 PM Will Senn <will.senn@gmail.com> wrote:
=20 =20 =20
On 2/16/21 7:08 PM, M Douglas McIlroy wrote:
Will Senn wrote,

join seems like part of an aborted (aka never fully realized) =
attempt at a text based rdb to me

As the original author of join, I can attest that there was no t=
hought
of parlaying join into a database system. It was inspired by
databases, but liberated from them, much as grep was liberated from an
editor.

Doug
Nice! Thanks Doug. Too bad, though... one gets ever tired of having to log into db's and a simple text db system would be useful. Even sqlite, which I love, requires login to get at information... I'm already logged in, why can't I just ask for my info and have it returned?

Will
--000000000000a8594e05bb7fd40f--