I have recently started using HSQLDB in development and testing, but good things can't be exclusive, so I recommend it to everyone.
Use small and lovely, powerful to describe the HSQLDB is not too much. The core code is only a few hundred k, but the sparrow is a small five or more. The latest version is the HSQLDB 1.7.2 version released in June 2004. Support SQL92, 99 , 2003 standards, supports views, transactions, stored procedures, triggers, etc. The functions of business databases.
Because it is written by Java, it can be used across platforms.
HSQLDB also provides a practical tool, such as HSQLDB Manager to connect almost all commonly used databases, which can be used to perform operational operations such as SQL statements, backup, conversion databases.
Project website: http://hsqldb.sourceforge.net