The Apache Derby project is pleased to announce a new feature release of Derby, 10.4.1.3.
Apache Derby is a subproject of the Apache DB project. 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. Derby 10.4.1.3 can be obtained from the Derby download site: http://db.apache.org/derby/derby_downloads.html. Derby 10.4.1.3 introduces the following new capabilities: * Asynchronous Replication Allows you to maintain an up to date copy of your (master) database on a different host (the slave). In the case of a crash on the master database you can perform failover to the copy (slave database) and continue serving client requests against your database. * Security o Shutting down the Network Server now supports user authentication, and in fact requires credentials when authentication is enabled. * SQL o Table Functions. Using table functions and standard SQL, you can pose sophisticated queries against in-memory collections, flat files, web resources, non-relational databases, etc.. Table functions also let you efficiently import data from web feeds, sensor logs, and other relational databases. o Unique constraints on nullable columns. o SQL ROW_NUMBER() window function, (for an empty, inlined window specification). o Bracketed comments (/* ... */). * Performance and Memory Usage o New buffer manager with better concurrency. o Statement cache in the client driver. o Caching of isolation level and current schema in the client driver. * Administration o Java Management Extensions (JMX) for Derby, allowing local and remote monitoring and management of running Derby instances (embedded or Network Server). o Continuation prompt. ij adds a short "> " prompt to the next line after a newline has been entered by the user without ending the statement with a semicolon. Derby 10.4.1.3 also has many bugfixes, including the fix for DERBY-3347 which can cause unrecoverable database corruption. All 10.3 users are encouraged to upgrade to avoid potential corruption issues. -- Regards, Dyre
