Compare Apache Derby and PostgreSQL

At a Glance
Apache Derby
Apache Derby
Star Rating
(23)3.8 out of 5
Market Segments
Small-Business (39.1% of reviews)
Information
Pros & Cons
Not enough data
Entry-Level Pricing
No pricing available
Learn more about Apache Derby
PostgreSQL
PostgreSQL
Star Rating
(671)4.4 out of 5
Market Segments
Small-Business (35.8% of reviews)
Information
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about PostgreSQL
AI Generated Summary
AI-generated. Powered by real user reviews.
  • G2 reviewers report that PostgreSQL excels in overall user satisfaction, boasting a significantly higher score compared to Apache Derby. Users appreciate its reliability and data integrity, with one reviewer noting that it has never failed them in over five years of production use.
  • Users say that PostgreSQL offers a wide range of features that facilitate complex SQL queries, including functions, triggers, and materialized views. This versatility is a standout feature that many find invaluable for their database needs, setting it apart from Apache Derby.
  • According to verified reviews, while Apache Derby is praised for its ease of setup and quick configuration, with some users reporting it takes only 15 minutes to get started, it lacks the extensive feature set that PostgreSQL provides for more complex database operations.
  • Reviewers mention that PostgreSQL's scalability is a major advantage, allowing businesses to grow without worrying about database limitations. Users highlight its ability to run on minimal hardware configurations, making it a cost-effective solution for small businesses.
  • G2 reviewers note that while Apache Derby is easy to manage, especially for those using Spring, it does not match the overall performance and feature richness of PostgreSQL. Users appreciate Derby's speed but often find themselves limited by its capabilities in larger applications.
  • Users highlight that PostgreSQL's strong community support and ongoing development contribute to its robust product direction, which is reflected in its higher satisfaction scores. In contrast, Apache Derby's lower product direction score suggests it may not be evolving as rapidly to meet user needs.
Pricing
Entry-Level Pricing
Apache Derby
No pricing available
PostgreSQL
No pricing available
Free Trial
Apache Derby
No trial information available
PostgreSQL
No trial information available
Ratings
Meets Requirements
8.2
22
9.1
548
Ease of Use
8.6
23
8.5
553
Ease of Setup
9.0
10
8.4
282
Ease of Admin
8.2
10
8.2
251
Quality of Support
8.1
19
7.9
443
Has the product been a good partner in doing business?
8.0
9
8.5
199
Product Direction (% positive)
6.4
23
8.5
535
Features by Category
7.4
20
8.9
510
Management
Not enough data
9.1
122
Not enough data
9.1
120
Not enough data
9.1
109
Not enough data
8.9
111
Support
Not enough data
8.6
113
Not enough data
9.2
127
Not enough data
9.1
111
Not enough data
9.1
113
Security
Not enough data
8.7
114
Not enough data
8.9
116
Not enough data
8.6
108
Not enough data
8.9
110
Performance
Not enough data
8.6
106
Not enough data
8.8
114
Not enough data
8.6
108
Not enough data
8.8
113
Not enough data
8.6
111
Database Features
7.3
20
9.0
460
8.0
20
9.0
465
7.9
20
9.0
472
6.7
20
8.6
454
7.0
19
8.7
440
7.3
20
8.8
453
7.3
20
9.0
462
Categories
Categories
Shared Categories
Apache Derby
Apache Derby
PostgreSQL
PostgreSQL
Apache Derby and PostgreSQL are categorized as Relational Databases
Unique Categories
Apache Derby
Apache Derby has no unique categories
PostgreSQL
PostgreSQL has no unique categories
Reviews
Reviewers' Company Size
Apache Derby
Apache Derby
Small-Business(50 or fewer emp.)
39.1%
Mid-Market(51-1000 emp.)
30.4%
Enterprise(> 1000 emp.)
30.4%
PostgreSQL
PostgreSQL
Small-Business(50 or fewer emp.)
35.8%
Mid-Market(51-1000 emp.)
34.0%
Enterprise(> 1000 emp.)
30.2%
Reviewers' Industry
Apache Derby
Apache Derby
Computer Software
39.1%
Information Technology and Services
13.0%
Government Administration
13.0%
Education Management
8.7%
Medical Practice
4.3%
Other
21.7%
PostgreSQL
PostgreSQL
Information Technology and Services
27.5%
Computer Software
22.9%
Internet
4.3%
Financial Services
4.1%
Telecommunications
2.8%
Other
38.3%
Alternatives
Apache Derby
Apache Derby Alternatives
MySQL
MySQL
Add MySQL
SQLite
SQLite
Add SQLite
Microsoft SQL Server
MS SQL
Add Microsoft SQL Server
Google Cloud SQL
Cloud SQL
Add Google Cloud SQL
PostgreSQL
PostgreSQL Alternatives
Microsoft SQL Server
MS SQL
Add Microsoft SQL Server
MySQL
MySQL
Add MySQL
Oracle Database
Oracle Database
Add Oracle Database
Amazon Relational Database Service (RDS)
Amazon Relational Database...
Add Amazon Relational Database Service (RDS)
Discussions
Apache Derby
Apache Derby Discussions
Monty the Mongoose crying
Apache Derby has no discussions with answers
PostgreSQL
PostgreSQL Discussions
What are the advantages and disadvantages of PostgreSQL?
2 Comments
Anish Mahesh S.
AS
Advantages: A different resource for your SQL needs without the tag of a legacy systemRead more
What is PostgreSQL used for?
1 Comment
Krishna K.
KK
PostgreSQL is an open-source database used to store, manage, and retrieve data. It's known for its reliability, scalability, and support for complex queries,...Read more
What is special about PostgreSQL?
1 Comment
Divyarajsinh  C.
DC
Provides features like scalability, reliability, and provides security which makes PostgreSQL more special. Read more