--- title: Apache Derby Reviews meta\_title: 'Apache Derby Reviews 2026: Details, Pricing, & Features | G2' meta\_description: Filter 23 reviews by the users' company size, role or industry to find out how Apache Derby works for a business like yours. aggregate\_rating: rating\_value: 3.8 review\_count: 23 scale: '5' date\_modified: '2026-08-07' parent\_category: name: Database Software url: https://www.g2.com/categories/database-software ---

# Apache Derby Reviews & Product Details

Apache Derby is a relational database management system developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction processing.

* * *

Seller
[The Apache Software Foundation](https://www.g2.com/sellers/the-apache-software-foundation)
Discussions
[Apache Derby Community](https://www.g2.com/products/apache-derby/discuss)

Show More

## Value at a Glance

Averages based on real user reviews.

### Perceived Cost

$$$$$

[
View More Pricing Information
](https://www.g2.com/products/apache-derby/pricing)

## Top-Rated Alternatives

[

 ![MySQL](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "MySQL")

MySQL

4.4/5(1,682)

](https://www.g2.com/products/mysql/reviews)

[

 ![SQLite](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "SQLite")

SQLite

4.3/5(262)

](https://www.g2.com/products/sqlite/reviews)

[

 ![PostgreSQL](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "PostgreSQL")

PostgreSQL

4.4/5(684)

](https://www.g2.com/products/postgresql/reviews)

[
View All Alternatives
](https://www.g2.com/products/apache-derby/competitors/alternatives)

## User Insights

Average based on 23 real user reviews.

Perceived Cost

$$$$$

[Log in to unlock pricing and user insights](/login)

 ![Bhavana S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Bhavana S.")
BS

Bhavana S.

Senior Software Engineer

Small-Business (50 or fewer emp.)

7/16/2020

"Best Open source Relational Database"

5/5

What do you like best about Apache Derby?

Lightweight and much easier to use than any other Databases.Best suited for applications which need a small embeddable DB. Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

The only limitation that i see is that it is not designed for data warehousing and would not do well for data analytics for which a No-SQL DB would serve better. Review collected by and hosted on G2.com.

What problems is Apache Derby solving and how is that benefiting you?

Writing a POC code which requires developers to spend more time and effort on business logic code then integrating and worry about DB setup and environment. Having an embeddable DB with java components makes coding easier. Love its simplicity and has a smaller footprint. Review collected by and hosted on G2.com.

Show More

Validated ReviewerIncentivizedSource: G2 invite

 ![Efthymios A.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Efthymios A.")
EA

Efthymios A.

Software Engineer Intern

Mid-Market (51-1000 emp.)

6/23/2020

"Performance Management System Java Application with an embedded database"

4.5/5

What do you like best about Apache Derby?

The embedded driver was the main reason that made me to use this database. Really easy to use and user friendly. Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

I used netbeans to develop the app and I have to say that the installation was the only thing that made my time hard. Also I think the documentation is a bit outdated. Review collected by and hosted on G2.com.

What problems is Apache Derby solving and how is that benefiting you?

The main a problem that Apache Derby solved is that I had to distribute the application with an embedded database. Review collected by and hosted on G2.com.

Show More

7/5/2020
Validated ReviewerSource: Seller invite

 ![Aditya S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Aditya S.")
AS

Aditya S.

Quality Analyst

Enterprise (\> 1000 emp.)

6/29/2020

"I use Apache derby for all my Software reliability projects, it’s just perfect and easy to setup."

5/5

What do you like best about Apache Derby?

I have not faced any glitches till date like the derby server stopping abruptly or it’s not starting sometimes. One single command in Linux VMs and it’s works like a charm Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

I have been using derby from past two years for my projects and I have not seen any complaints till date Review collected by and hosted on G2.com.

What problems is Apache Derby solving and how is that benefiting you?

Every time I create a software reliability automation project, I make use of derby to have my data Review collected by and hosted on G2.com.

Show More

Validated ReviewerIncentivizedSource: G2 invite

 ![Siddharth S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Siddharth S.")
SS

Siddharth S.

Principal technical officer

Mid-Market (51-1000 emp.)

7/26/2020

"Amazing and fast"

4.5/5

What do you like best about Apache Derby?

- Embedded Mode

- Easy to setup and configure Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

- Lack of tutorials for beginners

- Difficult to follow tutorials (developer) Review collected by and hosted on G2.com.

What problems is Apache Derby solving and how is that benefiting you?

- On device caching and storage for offline apps

- Embedded Mode for ML caching and intermediate storage Review collected by and hosted on G2.com.

Show More

Validated ReviewerIncentivizedSource: G2 invite

 ![Ayush P.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Ayush P.")
AP

Ayush P.

Small-Business (50 or fewer emp.)

6/17/2020

"It is quite better then SQL deployment."

4.5/5

What do you like best about Apache Derby?

Most helpful point is that it is lot easier to integrate with java applications and whole software sits in one folder. Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

On update cascade does not work in derby database embedded driver. Review collected by and hosted on G2.com.

Recommendations to others considering Apache Derby:

Best Embedded Database Review collected by and hosted on G2.com.

What problems is Apache Derby solving and how is that benefiting you?

I am using derby with my java swing applications.And benefit is that it makes the whole application deployable in just one folder. Review collected by and hosted on G2.com.

Show More

Validated ReviewerIncentivizedSource: G2 invite

 ![Verified User in E-Learning](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in E-Learning")
AE

Verified User in E-Learning

Small-Business (50 or fewer emp.)

6/21/2020

"I am using apache derby in my project. Performance is quite good."

4.5/5

What do you like best about Apache Derby?

Performance and support, configuration is simple and easy to use. Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

I think it is quite good and it's fit to our requirements Review collected by and hosted on G2.com.

What problems is Apache Derby solving and how is that benefiting you?

Using as relational database. Review collected by and hosted on G2.com.

Show More

Validated ReviewerSource: Seller invite

 ![Ricardo P.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Ricardo P.")
RP

Ricardo P.

Big Data Engineer

Government Administration

Mid-Market (51-1000 emp.)

10/31/2019

"Perfect for testing! Good for UAT! Reasonable for production site!"

5/5

What do you like best about Apache Derby?

I like its simplicity and seamless integration with Java components. Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

One must face that Derby, as any embedded database available, may exhibit decreases in performance while facing too many records and thus, it is not advisable for specific production scenarios. Review collected by and hosted on G2.com.

Recommendations to others considering Apache Derby:

Focus mainly on testing and UAT environments. Review collected by and hosted on G2.com.

What problems is Apache Derby solving and how is that benefiting you?

I usually employ it on Java components which need to rely on a local datastore for holding config information, such as real-time pipeline ingestion and Apache Hive metadata. Review collected by and hosted on G2.com.

Show More

Validated ReviewerIncentivizedSource: G2 invite

 ![Verified User in Computer Software](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Computer Software")
UC

Verified User in Computer Software

Small-Business (50 or fewer emp.)

11/3/2019

"Apache Derby, Best for online transaction processing."

4.5/5

What do you like best about Apache Derby?

First of all, Apache Derby is written in Java and can be embedded in any Java based solution. Apache Derby is light weight, It takes approximately 2.6 Megabytes for the base engine and JDBC driver. Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

The only limitation of Apache Derby according to me is, the system shuts down if the databse log cannot allocate more disk space. An IOException occurs in the Derby.log if the system runs out of space. Review collected by and hosted on G2.com.

What problems is Apache Derby solving and how is that benefiting you?

As Apache Derby is relational database system, I used it to execute sql commands as of now. But I would like to explore it more if given a chance. Review collected by and hosted on G2.com.

Show More

Validated ReviewerIncentivizedSource: G2 invite

 ![Md. S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Md. S.")
MS

Md. S.

Software Developer

Computer & Network Security

Mid-Market (51-1000 emp.)

10/30/2019

"Apache Derby is a basic need for a programmer"

5/5

What do you like best about Apache Derby?

Both server side and client side software development required Apache, I am using while I started programming in 2014 Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

Nothing, but sometimes need to import package Review collected by and hosted on G2.com.

Recommendations to others considering Apache Derby:

Without Apache Derby my software development is uncomplicated Review collected by and hosted on G2.com.

What problems is Apache Derby solving and how is that benefiting you?

I have been solved educational Digitalization crisis using Apache at Bangladesh Review collected by and hosted on G2.com.

Show More

Validated ReviewerIncentivizedSource: G2 invite

## Questions about Apache Derby? Ask real users or explore answers from the community

Get practical answers, real workflows, and honest pros and cons from the G2 community or share your insights.

[
Ask about Apache Derby
](https://www.g2.com/products/apache-derby/discussions/new)

GU

Guest User

What is Apache Derby used for?

0 Upvotes

0

[
Join the conversation
](https://www.g2.com/discussions/what-is-apache-derby-used-for)

[
View all Discussions
](https://www.g2.com/products/apache-derby/discuss)

##### Pricing

Pricing details for this product isn’t currently available. Visit the vendor’s website to learn more.

[
View More Pricing Information
](https://www.g2.com/products/apache-derby/pricing)

Apache Derby Comparisons

 ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_cf27b7c50adc61e4d44c2ef887f29fa3/sqlite.gif "Product Avatar Image")

SQLite

4.3/5(262)

[
Compare Now
](https://www.g2.com/compare/apache-derby-vs-sqlite)

 ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_240340edca859994ec71e4490aa20022/mysql.png "Product Avatar Image")

MySQL

4.4/5(1,682)

[
Compare Now
](https://www.g2.com/compare/apache-derby-vs-mysql)

 ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_be7892f62be5fe631662c5cc854eb801/hypersql.png "Product Avatar Image")

HyperSQL

4/5(22)

[
Compare Now
](https://www.g2.com/compare/apache-derby-vs-hypersql)

##### 
##### Apache Derby Features

Database Features

Storage

Availability

Stability

[
View More Features
](https://www.g2.com/products/apache-derby/features)

## Work at The Apache Software Foundation?

Claim this profile to respond to reviews, update product info, and reach in-market buyers.

[
Claim this profile
](https://www.g2.com/products/apache-derby/claim_requests/new?utm_medium=profile-footer-claim-cta&utm_source=g2)

##### Categories on G2

[Relational Databases](https://www.g2.com/categories/relational-databases)

##### Explore More

[What are the highest rated automotive marketing solutions for dealership networks seeking integrated optimization and account support?](https://www.g2.com/discussions/what-are-the-highest-rated-automotive-marketing-solutions-for-dealership-networks-seeking-integrated-optimization-and-account-support)[What's the best ATS that automates interview scheduling and keeps candidates updated on their status throughout the process?](https://www.g2.com/discussions/which-applicant-tracking-systems-are-the-most-reliable-based-on-reviews-from-recruiting-and-hiring-teams)[What MBaaS platforms offer the strongest SDKs for iOS, Android, and multiple programming languages?](https://www.g2.com/discussions/what-mbaas-platforms-offer-the-strongest-sdks-for-ios-android-and-multiple-programming-languages)

[Which C/C++ integrated development environments (IDEs) run smoothly on moderate hardware without excessive memory consumption during compilation?](https://www.g2.com/discussions/which-c-c-integrated-development-environments-ides-run-smoothly-on-moderate-hardware-without-excessive-memory-consumption-during-compilation)[Is X1 Search worth it as a desktop search tool for a professional services team that needs enterprise-grade file and email retrieval, or does Alfred cover enough for a technical team's day-to-day needs?](https://www.g2.com/discussions/is-x1-search-worth-it-as-a-desktop-search-tool-for-a-professional-services-team-that-needs-enterprise-grade-file-and-email-retrieval-or-does-alfred-cover-enough-for-a-technical-team-s-day-to-day-needs)[Which solution supports secure transcription for confidential documents?](https://www.g2.com/discussions/which-solution-supports-secure-transcription-for-confidential-documents)

[Show MoreShow Less](javascript:void(0);)