Apache Derby is a full-featured, open source relational database management system (RDBMS) that is based on Java and SQL.
It aims to be an easy to use solution for data management for software developers with zero administration for end users. It has a 2 MB disk-space footprint.
Derby ensures data integrity and provides sophisticated transaction support. In the default configuration there is no separate database server to be installed or maintained by the end user. It can be deployed with an embedded options where Derby runs in the same Java virtual machine as the application, or as a server where it runs in the JVM that hosts the server.
Derby began as a snapshot of the IBM’s Cloudscape Java relational database. IBM contributed the code to The Apache Software Foundation and bases future versions of IBM Cloudscape on the Apache-managed code.
Apache Derby is a subproject of the Apache DB project.
Key Features
- Small footprint – about 2 megabytes for the base engine and embedded JDBC driver.
- Provides an embedded JDBC driver that lets you embed Derby in any Java-based solution.
- Supports the more familiar client/server mode with the Derby Network Client JDBC driver and Derby Network Server.
- Easy to install, deploy, and use
- Interfaces with the Java Cryptography Extension (JCE) API to provide:
- Full on-disk encryption of database files.
- Storage and authentication of user passwords stored in the database.
- User and password encryption over a network.
- Based on the Java, JDBC, and SQL standards.
Website: db.apache.org/derby
Support: FAQ
Developer: Apache DB
License: Apache License 2.0
Apache Derby is written in Java. Learn Java with our recommended free books and free tutorials.
Related Software
| Relational Databases | |
|---|---|
| MariaDB | Seeks high compatibility with MySQL, ensuring drop-in replacement capability |
| PostgreSQL | Award winning Object-relational database management system |
| MySQL | Multithreaded, multi-user SQL database management system |
| SQLite | Embeddable SQL Database Engine |
| rqlite | Distributed database built on SQLite |
| MonetDB | High performance relational database system for analytics |
| Firebird | Relational database offering many ANSI SQL features |
| H2 | Relational database management system written in Java |
| HSQLDB | JDBC interface, client-server version, query tool, grid and more |
| CUBRID | Database engine with built-in enterprise grade features |
| Virtuoso | Data Management with Web Application Server and Web Services Platform |
| Apache Derby | Full-featured relational database implemented entirely in Java |
Read our verdict in the software roundup.
Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |

