From: alan@dragon.acadiau.ca (Alan McKay)
Subject: SUMMARY: Nice little databases
Summary: summary of nice little databases for Unix
Keywords: database summary
Organization: Acadia University
Date: Thu, 23 Jul 1992 12:16:50 GMT

There were several requests for one, so here is a brief summary of my
request for a simple little database to run on a Unix system.  Lines
beginning with ">" are of course quotes from the person who replied to
my request.  Different replies are separated with the dashed lines.
There are a few of my own comments inter-spersed through-out.

Oh, I can't remember which other group I originally cross-posted this
to, so I'm 

----------------

> Have you looked at reldb ?  It uses shell scripts
> to manage a relational database.  Archie has 
> site listings for it.

I found and got this with no ploblems.  I haven't really used it yet,
but I like it since it is implemented as a set of commands which can
be used in shell scripts.  The commands seem to fully support pipes
et al, which makes it fit nicely into the unix environment.

----------------

> Have you looked at  porting either postgres or university ingres?
> Both are probably some on one of the berkley machines.

----------------

> I use a database called "index-db" which I got off the net, but
> I forget where I got it.  If you can't find it with 'archie',
> then I can send you the 70k of source code, including examples.
> 
> Index-db isn't really a database, it's more of a list manager.
> I use it to maintain my phone/address book, to keep track of my
> software archive, etc....   It interfaces to whatever filters
> you provide -- the examples have some reasonable 'awk' filters.
> I've got about 7 databases which I use the tool on so I wrote a
> generic filter or two which are sym-linked from the database
> specific command name.
> 
> P.S.:	mbase is available on the net too, but I haven't looked
> at it.  I believe it's more of a relational database.

I did find several listings for it in archie, so one can easily 
find it there.  I haven't yet gotten nor tried it though.

----------------

> There's a perl version of rdb that might work for you.  Another
> administrator here uses for keeping data on our systems.  Do an archie
> search for rdb.  That is probably a good place to start.

----------------

> Jinx is an interactive, menu-driven program which handles databases ...
> With Jinx you can perform operations on a database like:
> -- update, add, copy and delete records
> -- test if all fields in all records match their associated regexp
> -- select/delete a subset of the records by various means
> -- put back some of the deleted records
> -- sort the database on one or more key-fields
> -- project on one or more columns
> -- join with another database
> -- add a column to the database (that is: add a field to every record)
> -- insert some records from another database
> -- test if some given combination of fields is uniq for all records
> -- compute fields as a function of other fields in the record
> 
> Jinx requires the 'cterm' package I posted earlier. Jinx and cterm are
> available from our archive server archive.cs.ruu.nl (131.211.80.5).
> ftp 'cterm.shar.Z' and 'jinx.shar.Z' from directory 'pub/UNIX'.
> or send a message to 'mail-server@cs.ruu.nl' containing the next 4 lines:
> begin
> send UNIX/cterm.shar
> send UNIX/jinx.shar
> end

I looked at this and the menu-driven aspect of it is really nice.  It 
looks a lot like "elm".  Jinx requires both "cterm" as mentioned above,
as well as perl.  If this thing runs half as good as it looks, then we
certainly have a winner.  I really like it.

-------------------

> Many people have recently asked me about the availablity of Requiem.
> Requiem (RElational QUery and Update Interactive SystEM) is now 
> available as public domain software. It comprise some 17,000 lines of
> C code and runs under SUN/Vax Unix. Requiem is a single-user system 
> at the moment and offers the following facilities:
> 
> - a complete data language,
> - view facilities,
> - supports automatic foreign key generation and updates,
> - provides a program interface in C
> - and is easily expandable
> 
> the following facilities are under development and will be available 
> shortly:
> 
> - transaction management,
> - a complete C-preprocessor.
> - user interface facilities.
> 
> Requiem is now available via anonymous ftp. For further information
> please contact:
> 
> Mike P. Papazoglou,
> Australian National University,
> Dept. of Computer Science,
> GPO Box 4, Canberra ACT 2601,
> Australia
> 
> tel. +61-6-2494725, fax. +61-6-2490010
> e-mail: mike@anucsd.anu.edu.au

This one sounds interesting.  I sent a request to the guy but don't
have anything back yet.

-- 
--
Alan W. McKay		| (902)542-2201.158	| Wolfville, N.S. Canada
alan@acadiau.ca		| Acadia University	| SUB Box 6008, B0P 1Z1
----------------------------------------- My Canada includes Quebec -----
Newsgroups: comp.unix.misc