Hypersonic Sql

HSQL (formerly known as HypersonicSql) is an OpenSource Java database.

The project is a SourceForge project at: http://sourceforge.net/projects/hsqldb/

There are other OpenSourceJavaDatabases of which HypersonicSql is very interesting instance.

What makes hsql "interesting"? -- a curious reader

HSQLDB can be used as an embedded database or as a server instance which even offers web access. HSQLDB is very fast and supports all necessary SQL commands. The database tables are stored in a simple text file (good for patching the data by hand) but can also be transformed into a cache file which improves memory usage. The performance is very good and it is very stable.

Isn't HSQL what OpenOfficeOrg uses for its "Base" (OpenOfficeBase) product (a MicrosoftAccess clone of sorts)? Has anybody tested it for big joins? Being text-file based, join performance could be a concern. Also, I couldn't find a strait-forward ODBC driver for it.

HypersonicSql has an In-Memory mode, which can help with writing UnitTests for things that interface with databases (see EjbUnitTest).

CategoryDatabase