SQL

Apache Derby – relational database implemented entirely in Java

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
MariaDBSeeks high compatibility with MySQL, ensuring drop-in replacement capability
PostgreSQLAward winning Object-relational database management system
MySQLMultithreaded, multi-user SQL database management system
SQLiteEmbeddable SQL Database Engine
rqliteDistributed database built on SQLite
MonetDBHigh performance relational database system for analytics
FirebirdRelational database offering many ANSI SQL features
H2Relational database management system written in Java
HSQLDBJDBC interface, client-server version, query tool, grid and more
CUBRIDDatabase engine with built-in enterprise grade features
VirtuosoData Management with Web Application Server and Web Services Platform
Apache DerbyFull-featured relational database implemented entirely in Java

Read our verdict in the software roundup.


Best Free and Open Source Software 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.
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments