From: John Cowan <cowan@ccil.org>
To: Will Senn <will.senn@gmail.com>
Cc: TUHS main list <tuhs@minnie.tuhs.org>
Subject: Re: [TUHS] cut, paste, join, etc.
Date: Tue, 16 Feb 2021 22:29:35 -0500 [thread overview]
Message-ID: <CAD2gp_SB=RB1ugee7SVjotvVON7EanTtk1Za3w1ThUoh8ahDiw@mail.gmail.com> (raw)
In-Reply-To: <26484818-2f05-37d3-adff-6e34d383e117@gmail.com>
[-- Attachment #1: Type: text/plain, Size: 1522 bytes --]
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 <will.senn@gmail.com> 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
>
[-- Attachment #2: Type: text/html, Size: 3020 bytes --]
next prev parent reply other threads:[~2021-02-17 3:32 UTC|newest]
Thread overview: 18+ messages / expand[flat|nested] mbox.gz Atom feed top
2021-02-17 1:08 M Douglas McIlroy
2021-02-17 1:16 ` Will Senn
2021-02-17 1:43 ` Grant Taylor via TUHS
2021-02-17 2:26 ` Will Senn
2021-02-17 4:08 ` Grant Taylor via TUHS
2021-02-17 10:14 ` John Gilmore
2021-02-17 14:52 ` Andrew Hume
2021-02-17 23:58 ` Dan Cross
2021-02-17 20:49 ` Dave Horsfall
2021-02-22 5:57 ` Tomasz Rola
2021-02-17 3:29 ` John Cowan [this message]
-- strict thread matches above, loose matches on Subject: below --
2021-02-18 20:20 Brian Walden
2021-02-18 20:41 ` Anthony Martin
2021-02-16 20:33 Will Senn
2021-02-16 21:02 ` Dave Horsfall
2021-02-16 21:15 ` Will Senn
2021-02-16 21:26 ` Dave Horsfall
2021-02-16 21:06 ` Dennis Boone
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to='CAD2gp_SB=RB1ugee7SVjotvVON7EanTtk1Za3w1ThUoh8ahDiw@mail.gmail.com' \
--to=cowan@ccil.org \
--cc=tuhs@minnie.tuhs.org \
--cc=will.senn@gmail.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for NNTP newsgroup(s).