Re: USMARC and postgresql?

On Tue, May 09, 2000 at 08:48:10AM -0400, Andrew Sullivan wrote:
> On Tue, May 09, 2000 at 10:36:51AM +0100, kb2qzv@poczta.onet.pl wrote:
>
> > Any information will help me a lot,
>
> Sorry, one other thing.  There is a project around this: the Open Source
> Digital Library System project.  See
>
>     <http://osdls.library.arizona.edu/>

This looks _very_ interesting. It's currently built on MySQL, but I
grabbed the source, and the SQL part looks like it could port to pgsql
pretty easily.

The client interface uses javascript to control a minimal browser side
java 'slice', which uses RMI to talk to a java servelet, which uses
something called the 'twz' jdbc driver to talk to the database. Looks like
the SQL embedded in the java there might need a little tweaking, as well,
for pgsql.

Sigh... so many interesting projects out there, so little time...

Anyway, the doco seems to be missing the section describing the schema
the system uses (hmm...) However, it looks pretty straight forward, if
you can read java a little, and the design doc on the website describe
at a higher level how it's all supposed to work. (If my quick scan was
correct, it looks simialr to what Tom Lane suggested ;-)

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005