Introducing G2.ai, the future of software buying.Try now

Compare Apache Derby and PostgreSQL

Save
    Log in to your account
    to save comparisons,
    products and more.
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
(663)4.4 out of 5
Market Segments
Small-Business (35.9% 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.
  • Users report that PostgreSQL excels in data schema management with a score of 9.2, while Apache Derby falls short in this area, lacking advanced features that users find essential for complex applications.
  • Reviewers mention that PostgreSQL's query language capabilities are robust, scoring 9.0, which allows for more complex queries and better performance in data retrieval compared to Apache Derby's lower score of 7.3.
  • G2 users highlight PostgreSQL's superior scalability with a score of 8.6, making it a preferred choice for growing businesses, whereas Apache Derby's scalability score of 6.7 indicates limitations in handling larger datasets.
  • Users on G2 appreciate PostgreSQL's advanced indexing features, scoring 8.8, which significantly enhance query performance, while Apache Derby's indexing capabilities are seen as basic, leading to slower query responses.
  • Reviewers say that PostgreSQL offers better disaster recovery options with a score of 8.6, ensuring data integrity and availability, while Apache Derby's lower score suggests it may not meet the same level of reliability in critical situations.
  • Users report that PostgreSQL's overall stability is rated at 9.0, making it a reliable choice for production environments, whereas Apache Derby's stability score of 7.9 indicates potential issues that could affect performance over time.
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
543
Ease of Use
8.6
23
8.5
548
Ease of Setup
9.0
10
8.4
277
Ease of Admin
8.2
10
8.2
249
Quality of Support
8.1
19
7.9
439
Has the product been a good partner in doing business?
8.0
9
8.4
198
Product Direction (% positive)
6.4
23
8.5
530
Features by Category
7.4
20
8.9
505
Management
Not enough data
9.1
121
Not enough data
9.1
119
Not enough data
9.1
107
Not enough data
8.9
110
Support
Not enough data
8.6
113
Not enough data
9.2
123
Not enough data
9.1
110
Not enough data
9.1
112
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
112
Not enough data
8.6
106
Not enough data
8.8
111
Not enough data
8.6
109
Database Features
7.3
20
9.0
460
8.0
20
9.0
465
7.9
20
9.0
468
6.7
20
8.6
450
7.0
19
8.7
439
7.3
20
8.8
453
7.3
20
9.0
460
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.9%
Mid-Market(51-1000 emp.)
33.8%
Enterprise(> 1000 emp.)
30.3%
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.3%
Computer Software
23.1%
Internet
4.3%
Financial Services
4.1%
Telecommunications
2.9%
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 Service (RDS)
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
Alexandre G.
AG
Open Source: PostgreSQL is free and open-source software, meaning anyone can download, use, and modify it as needed without licensing costs. SQL...Read more
Can we get some video tutorials on usage? Also how do we connect them over cloud ?
1 Comment
Nigel H.
NH
Hey Jay, We use Postgresql on all of our cloud servers. We connect via SSL connections to the specific...Read more
What programs use PostgreSQL?
1 Comment