Anticlue

Cloudscape and Derby

Looking for an embedded DB? Check out Derby and Cloudscape.

Derby is an open-source, embedded, Java database available from the Apache Software Foundation. Cloudscape is IBM's productized distribution of the Derby database. Cloudscape is currently available as an open source solution from IBM, although it does not come with source code. Source code comes with Derby, as does the eclipse plugin. Download here.

Cloudscape is a 100% Java relational DBMS. It typically runs in 4MB of memory for J2SE and J2EE. Table size and row counts are limited by available disk space, it is possible to have more than 1000 columns per table. Cloudscape comes with a Type 4 JDBC 3.0 driver and it supports most SQL-92E and some of SQL-99. It also runs stored procedures and triggers, has row-level locking, and can perform transaction commits and roll-backs. It also supports encryption. Pretty strong candidate for a little embedded db.