Saturday, May 2, 2009

Apache Derby released

The Apache Derby project announce a new GA feature release of Derby, Derby is a pure Java relational database engine which conforms to the ISO/ANSI SQL and
JDBC standards. Derby aims to be easy for developers and end-users to work with and not for enterprise applications.

Features of the new version:

SQL Roles - as described in SQL 2003 and errata
Generated Columns
Standard ALTER COLUMN syntax
LOB Improvements
Replication of encrypted databases
OFFSET/FETCH FIRST - SQL 2008 has added new syntax
In-Memory back end