From mboxrd@z Thu Jan  1 00:00:00 1970
To: 9fans@cse.psu.edu
Subject: Re: [9fans] Plan9 Relational Databases
From: diaz@x.bell-labs.com
MIME-Version: 1.0
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit
Message-Id: <20010208201814.5990119AD4@mail.cse.psu.edu>
Date: Thu,  8 Feb 2001 15:15:07 -0500
Topicbox-Message-UUID: 5e98eb3c-eac9-11e9-9e20-41e7f4b1d025

> 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.