Re: [9fans] Getting started in Plan9 - help

[skipt@real.com]

unity, a package that could be found at AT&T Toolchest long ago, kind of
did relational data management the "unix" way. My memory is not very clear
on this, but I recall it used text files, with hash index files for fast searches, and
I think it embedded the dictionary as the first (comment) line of
each file. You could use grep and awk, etc. I used it with some large data
sets, and it worked correctly and was fast. (I just checked, Lucent SSG sells it)

It is much harder to tastefully map a  table (matrix structure) to
a filesystem (a tree).

At 03:39 PM 1/21/2002 -0500, Russ Cox wrote:
>I think it might be neat to build a small number
>of little programs that parse and reemit sql queries.
>Thus you could use normal shell pipelines to do database
>queries but since you're passing _queries_ and not _output_
>through the pipes, you still reap the benefits of
>query optimization.  Just like the old /acme/edit scripts.
>
>I don't remember enough of the SQL syntax to
>reparse your query into an exact shell pipeline, but
>the idea is you could do something like
>
>	sql/grep 'Car%' pages.title | sql/join section pages.idx |
>	sql/p
>
>Sql/p would behave like the acme p, actually executing
>the query to produce output.
>
>Of course, if there isn't much data, moving it into
>the file system might be an even better solution.
>
>Russ
>
>