# Apache Derby, MariaDB vs PostgreSQL Comparison | | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Star Rating** | 3.8 out of 5 | 4.4 out of 5 | 4.4 out of 5 | | **Total Reviews** | 23 | 226 | 677 | | **Largest Market Segment** | Small-Business (39.1% of reviews) | Small-Business (41.3% of reviews) | Small-Business (35.9% of reviews) | | **Entry Level Price** | No pricing available | No pricing available | No pricing available | --- ## Top Pros & Cons ### Apache Derby **Not enough data** ### MariaDB Pros: - Ease of Use (2 reviews) - Easy Integrations (2 reviews) Cons: - Beginner Unfriendliness (1 reviews) - Connectivity Issues (1 reviews) ### PostgreSQL Pros: - Features (16 reviews) - Ease of Use (13 reviews) Cons: - Beginner Unfriendliness (7 reviews) - Complexity (6 reviews) --- ## Ratings Comparison | Rating | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Meets Requirements** | 8.2 (22 reviews) | 8.9 (183 reviews) | 9.1 (553 reviews) | | **Ease of Use** | 8.6 (23 reviews) | 8.9 (185 reviews) | 8.5 (558 reviews) | | **Ease of Setup** | 9.0 (10 reviews) | 8.7 (115 reviews) | 8.4 (287 reviews) | | **Ease of Admin** | 8.2 (10 reviews) | 8.4 (110 reviews) | 8.2 (251 reviews) | | **Quality of Support** | 8.1 (19 reviews) | 7.9 (142 reviews) | 7.9 (447 reviews) | | **Has the product been a good partner in doing business?** | 8.0 (9 reviews) | 8.1 (88 reviews) | 8.5 (199 reviews) | | **Product Direction (% positive)** | 6.4 (23 reviews) | 8.9 (176 reviews) | 8.5 (538 reviews) | --- ## Pricing ### Apache Derby #### Entry-Level Pricing No pricing available #### Free Trial No information available ### MariaDB #### Entry-Level Pricing No pricing available #### Free Trial Yes ### PostgreSQL #### Entry-Level Pricing No pricing available #### Free Trial No information available --- ## Features Comparison By Category ### Relational Databases | Product | Score | Reviews | |---|---|---| | **Apache Derby** | 7.4/10 | 20 | | **MariaDB** | 8.7/10 | 175 | | **PostgreSQL** | 8.9/10 | 515 | #### Management | Feature | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Data Schema** | Not enough data | 9.2 (28 reviews) | 9.1 (124 reviews) | | **Query Language** | Not enough data | 9.2 (29 reviews) | 9.1 (122 reviews) | | **ACID - Complaint** | Not enough data | 8.5 (25 reviews) | 9.1 (112 reviews) | | **Data Replication** | Not enough data | 8.5 (23 reviews) | 8.9 (112 reviews) | #### Support | Feature | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Text Search** | Not enough data | 8.6 (26 reviews) | 8.7 (115 reviews) | | **Data Types** | Not enough data | 8.9 (28 reviews) | 9.2 (129 reviews) | | **Languages** | Not enough data | 8.5 (23 reviews) | 9.1 (112 reviews) | | **Operating Systems** | Not enough data | 8.9 (22 reviews) | 9.1 (115 reviews) | #### Security | Feature | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Database Locking** | Not enough data | 8.7 (27 reviews) | 8.7 (116 reviews) | | **Access Control** | Not enough data | 8.8 (28 reviews) | 8.9 (119 reviews) | | **Encryption** | Not enough data | 8.8 (22 reviews) | 8.7 (110 reviews) | | **Authentication** | Not enough data | 8.7 (23 reviews) | 8.9 (113 reviews) | #### Performance | Feature | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Disaster Recovery** | Not enough data | 8.3 (21 reviews) | 8.6 (107 reviews) | | **Data Concurrency** | Not enough data | 8.6 (22 reviews) | 8.8 (115 reviews) | | **Workload Management** | Not enough data | 8.4 (24 reviews) | 8.7 (109 reviews) | | **Advanced Indexing** | Not enough data | 8.4 (20 reviews) | 8.8 (115 reviews) | | **Query Optimizer** | Not enough data | 8.5 (27 reviews) | 8.7 (113 reviews) | #### Database Features | Feature | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Storage** | 7.3 (20 reviews) | 9.0 (153 reviews) | 9.0 (464 reviews) | | **Availability** | 8.0 (20 reviews) | 9.1 (156 reviews) | 9.0 (469 reviews) | | **Stability** | 7.9 (20 reviews) | 9.2 (156 reviews) | 9.0 (476 reviews) | | **Scalability** | 6.7 (20 reviews) | 8.6 (148 reviews) | 8.6 (458 reviews) | | **Security** | 7.0 (19 reviews) | 8.6 (150 reviews) | 8.7 (443 reviews) | | **Data Manipulation** | 7.3 (20 reviews) | 8.7 (150 reviews) | 8.8 (457 reviews) | | **Query Language** | 7.3 (20 reviews) | 9.0 (154 reviews) | 9.0 (467 reviews) | ### Columnar Databases | Product | Score | Reviews | |---|---|---| | **Apache Derby** | N/A | N/A | | **MariaDB** | 9.0/10 | 10 | | **PostgreSQL** | N/A | N/A | #### Storage | Feature | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Data Model** | Not enough data | 8.8 (8 reviews) | Not enough data | | **Data Types** | Not enough data | 8.9 (9 reviews) | Not enough data | #### Availability | Feature | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Auto Sharding** | Not enough data | 9.0 (5 reviews) | Not enough data | | **Auto Recovery** | Not enough data | 8.8 (7 reviews) | Not enough data | | **Data Replication** | Not enough data | 8.6 (6 reviews) | Not enough data | #### Performance | Feature | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Integrated Cache** | Not enough data | 9.0 (8 reviews) | Not enough data | #### Security | Feature | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Role-Based Authorization** | Not enough data | 9.4 (8 reviews) | Not enough data | | **Authentication** | Not enough data | 9.5 (7 reviews) | Not enough data | | **Audit Logs** | Not enough data | 8.6 (7 reviews) | Not enough data | | **Encryption** | Not enough data | 9.2 (6 reviews) | Not enough data | #### Support | Feature | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Multi-Model** | Not enough data | 9.7 (5 reviews) | Not enough data | | **Operating Systems** | Not enough data | 8.8 (7 reviews) | Not enough data | ### AWS Marketplace | Product | Score | Reviews | |---|---|---| | **Apache Derby** | N/A | N/A | | **MariaDB** | N/A | N/A | | **PostgreSQL** | N/A | N/A | #### Agentic AI - AWS Marketplace | Feature | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Autonomous Task Execution** | Not enough data | Not enough data | Not enough data | | **Multi-step Planning** | Not enough data | Not enough data | Not enough data | | **Cross-system Integration** | Not enough data | Not enough data | Not enough data | --- ## Categories **Shared Categories (1):** [Relational Databases](https://www.g2.com/categories/relational-databases) **Unique to MariaDB (2):** [Columnar Databases](https://www.g2.com/categories/columnar-databases), [AWS Marketplace Software](https://www.g2.com/categories/aws-marketplace) --- ## Reviewer Demographics ### By Company Size | Segment | Apache Derby | MariaDB | PostgreSQL | |---|---|---|---| | **Small-Business** | 39.1% | 41.3% | 35.9% | | **Mid-Market** | 30.4% | 31.7% | 34.2% | | **Enterprise** | 30.4% | 27.1% | 29.9% | ### By Industry #### Apache Derby - **Computer Software:** 39.1% - **Information Technology and Services:** 13.0% - **Government Administration:** 13.0% - **Education Management:** 8.7% - **Medical Practice:** 4.3% - **Hospital & Health Care:** 4.3% - **Higher Education:** 4.3% - **E-Learning:** 4.3% - **Banking:** 4.3% - **Airlines/Aviation:** 4.3% #### MariaDB - **Information Technology and Services:** 26.1% - **Computer Software:** 20.2% - **Internet:** 5.0% - **Telecommunications:** 5.0% - **Computer & Network Security:** 3.7% - **Education Management:** 3.7% - **Marketing and Advertising:** 2.8% - **Computer Networking:** 2.3% - **Higher Education:** 2.3% - **Retail:** 1.8% - **Other:** 27.1% #### PostgreSQL - **Information Technology and Services:** 27.5% - **Computer Software:** 23.1% - **Internet:** 4.2% - **Financial Services:** 4.1% - **Telecommunications:** 2.8% - **Hospital & Health Care:** 2.8% - **Higher Education:** 2.7% - **Computer & Network Security:** 2.2% - **Retail:** 2.0% - **Marketing and Advertising:** 1.9% - **Other:** 26.7% --- ## Alternatives ### Alternatives to Apache Derby - [MySQL](https://www.g2.com/products/mysql/reviews) — 4.4/5 stars (1675 reviews) - [SQLite](https://www.g2.com/products/sqlite/reviews) — 4.3/5 stars (260 reviews) - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) — 4.4/5 stars (2274 reviews) - [Google Cloud SQL](https://www.g2.com/products/google-cloud-sql/reviews) — 4.5/5 stars (366 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) — 4.3/5 stars (1010 reviews) - [Amazon Aurora](https://www.g2.com/products/amazon-aurora/reviews) — 4.5/5 stars (457 reviews) - [IBM Db2](https://www.g2.com/products/ibm-db2/reviews) — 4.1/5 stars (682 reviews) - [Amazon Relational Database Service (RDS)](https://www.g2.com/products/amazon-relational-database-service-rds/reviews) — 4.5/5 stars (906 reviews) - [SAP HANA Cloud](https://www.g2.com/products/sap-hana-cloud-2025-10-01/reviews) — 4.3/5 stars (621 reviews) - [Teradata Vantage](https://www.g2.com/products/teradata-teradata-vantage/reviews) — 4.3/5 stars (373 reviews) ### Alternatives to MariaDB - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) — 4.4/5 stars (2274 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) — 4.4/5 stars (1675 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) — 4.3/5 stars (1010 reviews) - [Amazon Relational Database Service (RDS)](https://www.g2.com/products/amazon-relational-database-service-rds/reviews) — 4.5/5 stars (906 reviews) - [IBM Db2](https://www.g2.com/products/ibm-db2/reviews) — 4.1/5 stars (682 reviews) - [Amazon Aurora](https://www.g2.com/products/amazon-aurora/reviews) — 4.5/5 stars (457 reviews) - [SQLite](https://www.g2.com/products/sqlite/reviews) — 4.3/5 stars (260 reviews) - [Google Cloud SQL](https://www.g2.com/products/google-cloud-sql/reviews) — 4.5/5 stars (366 reviews) - [SAP HANA Cloud](https://www.g2.com/products/sap-hana-cloud-2025-10-01/reviews) — 4.3/5 stars (621 reviews) - [OpenText Vertica](https://www.g2.com/products/opentext-vertica/reviews) — 4.3/5 stars (216 reviews) ### Alternatives to PostgreSQL - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) — 4.4/5 stars (2274 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) — 4.4/5 stars (1675 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) — 4.3/5 stars (1010 reviews) - [Amazon Relational Database Service (RDS)](https://www.g2.com/products/amazon-relational-database-service-rds/reviews) — 4.5/5 stars (906 reviews) - [IBM Db2](https://www.g2.com/products/ibm-db2/reviews) — 4.1/5 stars (682 reviews) - [SAP HANA Cloud](https://www.g2.com/products/sap-hana-cloud-2025-10-01/reviews) — 4.3/5 stars (621 reviews) - [Teradata Vantage](https://www.g2.com/products/teradata-teradata-vantage/reviews) — 4.3/5 stars (373 reviews) - [SQLite](https://www.g2.com/products/sqlite/reviews) — 4.3/5 stars (260 reviews) - [Azure SQL Database](https://www.g2.com/products/azure-sql-database/reviews) — 4.5/5 stars (241 reviews) - [Google Cloud SQL](https://www.g2.com/products/google-cloud-sql/reviews) — 4.5/5 stars (366 reviews) --- ## Top Discussions ### Apache Derby No discussions available for this product. ### MariaDB - Title: [What is MariaDB used for?](https://www.g2.com/discussions/mariadb-what-is-mariadb-used-for) — 1 comment > **Top comment:** "It is a fork of MySQL used for data warehouse, e-com services and usage for similar kind of data manipulation tasks. " - Title: [Is MariaDB compatible with MySQL?](https://www.g2.com/discussions/is-mariadb-compatible-with-mysql) — 1 comment > **Top comment:** "Yes" - Title: [What is MariaDB server?](https://www.g2.com/discussions/what-is-mariadb-server) — 1 comment > **Top comment:** "MariaDB server is an open-source relational database management system (RDBMS) that is compatible with MySQL. I'm pretty sure it was a fork of MySQLs..." - Title: [What is MariaDB used for?](https://www.g2.com/discussions/what-is-mariadb-used-for) — 1 comment > **Top comment:** "It is a relational database that stores data in form of row and column coming as input from a source like application softwares" - Title: [Improvements in the mechanism of replication](https://www.g2.com/discussions/12584-improvements-in-the-mechanism-of-replication) — 1 comment, 1 upvote > **Top comment:** "MarieDB Galera cluster is the way to go https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/" ### PostgreSQL - Title: [What are the advantages and disadvantages of PostgreSQL?](https://www.g2.com/discussions/what-are-the-advantages-and-disadvantages-of-postgresql) — 2 comments > **Top comment:** "Advantages: A different resource for your SQL needs without the tag of a legacy system" - Title: [What is PostgreSQL used for?](https://www.g2.com/discussions/what-is-postgresql-used-for) — 1 comment > **Top comment:** "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,..." - Title: [What is special about PostgreSQL?](https://www.g2.com/discussions/what-is-special-about-postgresql) — 1 comment > **Top comment:** "Provides features like scalability, reliability, and provides security which makes PostgreSQL more special. " - Title: [What programs use PostgreSQL?](https://www.g2.com/discussions/what-programs-use-postgresql) — 1 comment > **Top comment:** "SQL" - Title: [Can we get some video tutorials on usage? Also how do we connect them over cloud ?](https://www.g2.com/discussions/can-we-get-some-video-tutorials-on-usage-also-how-do-we-connect-them-over-cloud) — 1 comment, 1 upvote > **Top comment:** "Hey Jay, We use Postgresql on all of our cloud servers. We connect via SSL connections to the specific..." --- **Source:** [G2.com](https://www.g2.com) | [Comparison Page](https://www.g2.com/compare/apache-derby-vs-mariadb-vs-postgresql)