Re: [9fans] Plan9 Relational Databases

[diaz@x.bell-labs.com]

> A couple of months ago, Bill Staniewicz asked about what RDBMSs are
> used in plan9 if any.  I didn't see anyone respond to this, but all I
> have seen is the following:

I responded to Bill directly and should have sent this out to the list.

At the bottom of the distribution page is a tar file for 'pq'.

It is an "implicit" rdb in that joins are done across the relations
dynamically.  You create your relations and  describe the schemata
in a dispatch file.  When queries are made the join code figures
out the best way to link the relations to resolve the query.
It also (cleanly) supports distributed relations.

It has a lot of flexibility and power, and more functionality
than my hastily put together documentation describes.
It has seen a lot of heavy, production use over the years
in a variety of applications.  As an example, one directory
application currently supports 20 million lookups per month.

The distribution includes a sample set of relations you can
experiment with, man pages, etc.

Finally, I have to say that despite the attribution on the web page,
pq is the work of Michael Baldwin (who is now at Vita Nuova -
baldwin@vitanuova.com).  I merely packaged it up.
Given that, I'd be happy to answer any questions you may
have.

Hope you find it useful.