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