It's been two months since this profile received a new review

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

Product Description

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.

Value at a Glance

Averages based on real user reviews.

Perceived Cost

$$$$$

View More Pricing Information

Top-Rated Alternatives

View All Alternatives

Apache Derby Reviews (23)

G2 reviews are authentic and verified.

Here's how.

Varshini S.

Database Engineer

Information Technology and Services

Enterprise (> 1000 emp.)

12/9/2021

"System Routine Execution Permissions are well-structured in Apache Derby for our RDS"

3.5/5

What do you like best about Apache Derby?

Apache Derby is an SQL relational database system in which its extensive language compiler determines the various expressions during compilation time and produces substantial results. We can use both implicit and explicit functions to denote our associated records and data types in our environment. It follows Derby database connection schematics with which we utilize its subfunctional protocols and properties to connect with our various enterprise database systems. Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

Apache Derby follows java-based SQL drivers, which efficiently establishes connections with our object drivers. It is capable of taking more than one argument besides our regular JDBC connection URL, which helps to provide authentication and authorization within our set database connection. I prefer using Apache Derby for my relational database management system in our enterprise. Review collected by and hosted on G2.com.

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

Apache Derby resolves most of the SQL error messages and exceptions thanks to its categorization of SQL states. For improving the default transaction method, it provides java SQL connection sets that commit our current transaction and perform various operations such as serialization, commit read, distinct locking, etc. It also maps our XML datatypes which retrieves XML data as java strings with the help of SQL queries and XML operators. The permissions are granular and well-specified for our system routine, and its dependency manager accurately tracks, triggers raises constraints depending on the set routine level permissions in our customer's databases. Review collected by and hosted on G2.com.

Ambarish D.

Small-Business (50 or fewer emp.)

7/28/2020

"Easy to install and best for the beginners to learn DBMS."

4/5

What do you like best about Apache Derby?

This is a Relational database management system. It is a database system implemented fully in java. It is very easy to install, deploy, and use. I would say it is well suited for beginners who want to learn DBMS as it is easy to configure and use. It has a very small setup to install. It is available with a command-line tool called "ij tool" to access databases and fire various SQL queries. Apache derby is good to use for java applications. Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

Apache derby has quite fewer features than any other database system. It is not suitable for large scale enterprise applications. Some of the SQL statements which are available in MySQL are not there in apache derby. As it is made in java so it is comparatively slower than C/C++ database systems. It is less popular in the developers' community. Review collected by and hosted on G2.com.

Recommendations to others considering Apache Derby:

If your software application is not a highly distributed enterprise application and highly scaled then you can use this database system. It is a good database system for business software of shops, stores, and malls for maintaining details about customers, products, payments, etc. Review collected by and hosted on G2.com.

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

Apache derby has good support for JDBC. It has an inbuilt driver for java database connectivity. So I basically use this for my java applications to access data from the database of apache derby. I feel that for the common less scalable products it is a very good choice. As it's set up size is also very less. I am using it for the company's website to store the student data and login information, Review collected by and hosted on G2.com.

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.

Ajay V.

Senior Software Engineer

Mid-Market (51-1000 emp.)

8/1/2020

"I am having 5+yrs of Software Development in Java and Apache Technologies"

4/5

What do you like best about Apache Derby?

Apache Derby is an in memory database which does not require any dedicated database and as I am using Spring in which it is very easy to manage the derby Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

As Compare to H2 its performance with Hibernate is not so good Review collected by and hosted on G2.com.

Recommendations to others considering Apache Derby:

Work on integration with hibernate in which its not upto the mark Review collected by and hosted on G2.com.

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

I am using derby for some of my unit test cases using mockito and its very reliable to get overrides the issue for setting up a dedicated db server Review collected by and hosted on G2.com.

Verified User in Banking

Enterprise (> 1000 emp.)

8/2/2020

"Apache Derby embedded mode is best suited for stand alone apps"

4/5

What do you like best about Apache Derby?

I found that Apache Derby also known as Java DB is very fast .Additionally ,much easier to configure / use and it’s hardly takes 15 mins to set up the DB . Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

We have used Apache Derby with in one of the Java swing based stand alone application . I haven’t faced any challenge with this , looks to me there could be issues scalability aspects compared to other enterprise players Review collected by and hosted on G2.com.

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.

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.

Verified User in Medical Practice

Mid-Market (51-1000 emp.)

7/28/2020

"Useful lightweight RDMS embedded in your Java software"

3.5/5

What do you like best about Apache Derby?

Lightweight

Embedded in your Java application

Useful for both smaller projects or integration testing Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

Hard to manage multiple connections too

Had some issues with lock files when the host computer crashed. Review collected by and hosted on G2.com.

Verified User in Computer Software

Enterprise (> 1000 emp.)

6/18/2020

"Lightweight database for your hadoop"

0/5

What do you like best about Apache Derby?

Lightweight online transaction database with jdbc support Review collected by and hosted on G2.com.

What do you dislike about Apache Derby?

More in memory capabilities with more featutes Review collected by and hosted on G2.com.

Recommendations to others considering Apache Derby:

Use it for hive meta store inside your hadoop cluster Review collected by and hosted on G2.com.

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

We used it with cloudera hadoop cluster as an embedded package so it stores Hive meta store. Being a lightweight database it’s performance is optimal which is required for a meta store for a big pb data hadoop clusters Review collected by and hosted on G2.com.