[OT] Great SQL Database for Java

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Joe,

Another great little database is DB2 UDB for iSeries. Very easy to
install, 
it comes with the hardware! One that I use a lot is MySQL, which only 
costs you if you integrate it into a product. Postgresql is the
ultimate 
Free DB but not quite as quick as MySQL but difficult to install. I
have 
been working with them on a new install routine that address this 
issue. You should see that being released in the next month or so.

http://prdownloads.sourceforge.net/pgsql/PgSQL731wina1.exe?download

More info here:
http://techdocs.postgresql.org/guides/InstallingOnWindows

Here is another install that is not as fancy and still has some of 
the Cygwin lumps but it is workable:

http://sourceforge.net/project/showfiles.php?group_id=9764

The current install for Postgres is worth it if you see value in
cygwin. I 
really like cygwin's ability to give me Unix commands in Windows. I 
suspect that most people don't like the cryptic commands that come 
with the bourne shell, but they are no worse than Windows cmd shell 
and far more powerful.

David Morris

>>> joepluta@xxxxxxxxxxxxxxxxx 02/21/03 11:44AM >>>
This is slightly off the beaten path, but if anybody is interested in
a
small, capable, 100% Pure Java SQL database engine to use for testing
applications and whatnot, you might be interested in the HSQLDB
product.

It's a SourceForge project (http://sourceforge.net/projects/hsqldb)
based on
the Hypersonic SQL engine, and it supports both in-memory and
disk-based
tables.

Since some of the more prevalent free versions are going commercial
(mSQL)
or sort of dying off (tinySQL), it's nice to see a fully featured
database
like this available for free.

Not only is it free, but it has an HTTP-only connection mode that will
allow
you to connect to a database on another machine through a firewall
using
just HTTP.

There are other "free" databases - mySQL and PostGreSQL come to mind. 
But
the simplicity with which HSQLDB is installed is unparalleled.  Include
the
JAR file in your library path, and you're done.

Joe