Linked by Andrew Youll on Tue 5th Jul 2005 16:46 UTC, submitted by HSQLDB 1.8.0 Released
Databases HSQLDB is the leading SQL relational database engine written in Java. It has a JDBC driver and supports a rich subset of ANSI-92 SQL (BNF tree format) plus SQL 99 and 2003 enhancements. It offers a small (less than 100k in one version for applets), fast database engine which offers both in-memory and disk-based tables and supports embedded and server modes.
Permalink for comment
To read all comments associated with this story, please click here.
Is the problem of
by matt on Tue 5th Jul 2005 16:58 UTC

Being slow when the data files get to be large fixed it. I admit last time I tried it was a year ago, but a select count on one column in a table with 10,000 records could take a few minutes.

It worked great for small stuff, but seemed to totally choak when the database grew. Plus startup times became pretty annoying. Once the tables became big enough even Oracle would be able to start quicker.

Just to be clear I think it is an first rate product for the small stuff, just inquireing from a "I got a lot of data to work with." point of view.