Saturday, May 2, 2009

The Apache Derby project announce a new GA feature release of Derby, 10.5.1.1. Derby is a pure Java relational database engine which conforms to the ISO/ANSI SQL andJDBC 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 errataGenerated ColumnsStandard ALTER COLUMN syntaxSYSCS_UTIL.SYSCS_UPDATE_STATISTICSLOB ImprovementsReplication of encrypted databasesOFFSET/FETCH FIRST - SQL 2008 has added new syntaxIn-Memory back end