Apache Derby is one of the first database engines the Apache Software foundation hosted under its umbrella before big names like Yahoo's Hadoop, Facebook's Cassandra, or IBM's CouchDB were also donated to it.
Coded from the beginning to avoid bloat, Derby is extremely small for its capabilities, being originall based on Java's JDBC data access technology.
The Derby database supports the famed client/server mode and because it implements the standard SQL syntax requires little documentation study before actually delving in and working with it.
The database core is portable and can be easily embedded in other applications, while its on-disk data storage system is entirely platform independent.
Besides the popular embedded format, derby can also be deployed in standard server mode, in this case running inside a JVM and listening to query requests just like any other database server.
What is new in this release:
- MERGE statement - MERGE is a single, join-driven statement which INSERTs, UPDATEs, and DELETEs rows.
- Deferrable constraints - Constraint enforcement can now be deferred, typically to the end of a transaction.
- WHEN clause in CREATE TRIGGER - An optional WHEN clause has been added which determines which rows fire a trigger.
- Rolling log file - The Derby diagnostic log can now be split across a sequence of files.
- Experimental Lucene support - Derby text columns can now be indexed and queried via Apache Lucene.
- Simple case expression - The "simple" and "extended" syntax for CASE expressions has been added.
- Better concurrency for identity columns - The concurrency of identity columns has been boosted.
- New ij HoldForConnection command - A new ij command has been added to change the default cursor holdability.
- Standard syntax for altering column nullability - Standard syntax has been added for altering the nullability of columns.
What is new in version 10.11.1.1:
- MERGE statement - MERGE is a single, join-driven statement which INSERTs, UPDATEs, and DELETEs rows.
- Deferrable constraints - Constraint enforcement can now be deferred, typically to the end of a transaction.
- WHEN clause in CREATE TRIGGER - An optional WHEN clause has been added which determines which rows fire a trigger.
- Rolling log file - The Derby diagnostic log can now be split across a sequence of files.
- Experimental Lucene support - Derby text columns can now be indexed and queried via Apache Lucene.
- Simple case expression - The "simple" and "extended" syntax for CASE expressions has been added.
- Better concurrency for identity columns - The concurrency of identity columns has been boosted.
- New ij HoldForConnection command - A new ij command has been added to change the default cursor holdability.
- Standard syntax for altering column nullability - Standard syntax has been added for altering the nullability of columns.
What is new in version 10.10.1.1:
- JDBC 4.2 - Derby supports the Java 8 enhancements to JDBC.
- Small device profile - Derby runs on the small CP2 profile of Java 8.
- User-defined aggregates - Applications can create their own aggregate operators.
- Varargs routines - SQL routines can be bound to user-written Java methods which have variable length argument lists.
What is new in version 10.9.1.0:
- NATIVE authentication - Derby now provides better credentials management to replace BUILTIN authentication.
- JDBC 4.1 escape syntax - Most of Derby's JDBC 4.1 support was provided in release 10.8.1.2.
- This release supplies the remaining bits: object mapping and new escape syntax.
- Multi-column EXISTS subqueries - Multi-column SELECT lists are now allowed in EXISTS subqueries.
What is new in version 10.8.1.2:
- JDBC 4.1 - Derby's JDBC drivers support the new Java 7 methods on the java.sql and javax.sql interfaces.
- Automatic calculation of index statistics - Derby automatically refreshes statistics
- to help it pick better query plans.
- Improved interrupt handling - Interrupting connection threads no longer crashes the Derby engine.
- MAX optimization - On indexed tables, MAX queries run faster in more cases.
- XML operator portability - The xmlparse and xmlserialize operators work out-of-the-box on more platforms.
What is new in version 10.6.2.1:
- This is a bug fix release which also provides localizations of new 10.6 messages.
What is new in version 10.5.3.0:
- SQLException XJ215 on insert with setCharacterStream() and autocommit off in mailjdbc test.
- The Reference Guide lists wrong lengths for the GRANTOR and GRANTEE columns in SYSCOLPERMS, SYSROUTINEPERMS, and SYSTABLEPERMS.
- Join returns results in wrong order.
- Replication: Test replication of encrypted databases.
- Failure in testAssertFailureThreadDump with weme 6.1 / JSR 169.
Requirements:
- Java 6 or higher
Comments not found