The project's documentation is included in the binary release.
This is an open source relational database implemented entirely in Java.
It has a small footprint that makes it easy to embed in any Java-based application, but it also supports the more familiar client/server mode.
It is based on the Java, JDBC, and SQL standards, making code developed more portable to standards-compliant databases.
Here are some key features of "Apache Derby":
· Embedded engine with JDBC drivers
· Network Server
· Network client JDBC drivers
· Command line tools: ij (SQL scripting), dblook (schema dump) and sysinfo (system info)
· A small footprint -- about 2 megabytes for the base engine and embedded JDBC driver.
· Is based on the Java, JDBC, and SQL standards.
· Derby provides an embedded JDBC driver that lets you embed Derby in any Java-based solution.
· It supports the more familiar client/server mode with the Derby Network Client JDBC driver and Derby Network Server.
· Easy to install, deploy, and use.
Requirements:
· Branch 10.5 or higher
· Machine
· Apache Ant 1.7.1 or higher
· J2ME/JSR 169
· JDK 1.4 or higher
· Java 5 or 6
· Compiler
What's New in This Release: [ read full changelog ]
· 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.