PostgreSQL Alternatives

PostgreSQL Alternatives

PostgreSQL, or Postgres for short is a widely popular, free and open-source relational database management system. PostgreSQL is available for all major operating systems including macOS, Linux, Windows, BSD and Solaris. The project has been in active .. read more.

According to people there are many software similar to it, and the best alternative to PostgreSQL is MariaDB which is both free and open source. Other highly recommended applications include MySQL (Free) , SQLite (Free) and MonetDB (Free).
In total people have suggested 33 alternatives to PostgreSQL that share similarities by use case and feature set.

MariaDB

MariaDB is an free and open-source, community-developed relational database management system. MariaDB is a fork of MySQL, and is developed and maintained by the creators of MySQL, after concerns over its acquisition by Oracle Corporation in 2009. The databases comes bundled by default with most Linux distributions and is also apart of most cloud offerings. MariaDB is built upon the values of performance, stability, and openness which is ensured through the MariaDB Foundation.

Free & Open Source
👍 Most people think MariaDB is a good alternative to PostgreSQL.

MySQL

The worlds most popular free open-source relational database, MySQL is used by 150,000 + companies across the globe. The relational database management system is released and distributed under the GPL license and openly developed by the community. MySQL uses SQL as its query language and is fully integrated and ACID compliant.

Free & Proprietary
👍 Most people think MySQL is a good alternative to PostgreSQL.

SQLite

SQLite is a free and open-source relational database management system that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. Rather than being a typical client–server database engine, SQLite is self-contained and can be embedded into applications. Making it perfect for development frameworks that want to provide a default database without setup, or applications that needs an embedded database. SQLite is built into all mobile operating systems and most computers and comes bundled with a countless applications. SQLite is also ACID-compliant and implements most of the SQL standard, generally following PostgreSQL syntax.

Free & Open Source
👍 Most people think SQLite is a good alternative to PostgreSQL.

MonetDB

MonetDB is an column-oriented database management system developed at the Centrum Wiskunde & Informatica. The database is released as free and open source software under the Mozilla Public License 2.0. By design, MonetDB can handle high performance on complex queries against large databases with hundreds of columns and millions of rows.

Free & Open Source

PouchDB

PouchDB is a free and open-source JavaScript database inspired by Apache CouchDB. The database is designed from the ground-up to run well within modern web browsers. With PouchDB you can create web applications that works as well offline as they do online. PouchDB achives this by storing data locally, then synchronize it with CouchDB and compatible servers when the user get internet access once again. This is especially useful for applications facing countries and regions with lower quality internet connections or unstable infrastructure.

Free & Open Source

QuestDB

QuestDB is a relational column-oriented time series database designed for real-time analytics on time series and event data. It uses the SQL language and include extensions for time series data. QuestDB is released as free and open source software and distributed as a single binary including a trimmed version of the JVM (Java Virtual Machine) weighing in at only 24.5 MB.

Free , Commercial & Open Source

Amazon DynamoDB

Amazon DynamoDB is a key-value and document database that delivers single-digit millisecond performance at any scale. The database is fully managed, multiregion, multimaster, and durable with built-in security, backup and restore, and in-memory caching for enterprise-scale applications. Amazon DynamoDB is part of Amazon Web Services and integrates well with other cloud-based AWS products.

Commercial & Proprietary

TimescaleDB

TimescaleDB is a leading open-source relational database for time-series data. The database is provided as fully managed or self‑hosted software, giving the power of choice back to developers and organizations. Timescale gives you all the reliability and flexibility of PostgreSQL. It allows you to use regular SQL to construct queries to better understand your products and your users. While achieve 10-100x faster queries than PostgreSQL, InfluxDB, and MongoDB with native optimizations for time-series.

Free , Commercial & Open Source

Azure Cosmos DB

Azure Cosmos DB is a non-relational NoSQL database trusted by leading enterprises globally. With Azure Cosmos DB you can run No-ETL analytics over real-time operational data and run near-real time analytics and AI on the operational data within your NoSQL database, to reduce time to insight.

Commercial & Proprietary

CockroachDB

Cockroach is a distributed key/value datastore that allow you to build, scale and manage modern, data-intensive applications. The database delivers distributed SQL by combining the familiarity of relational data with limitless, elastic cloud scale and bulletproof resilience. Correct data is a must for mission-critical and even the most common applications. CockroachDB provides guaranteed ACID compliant transactions, allowing you to fully trust your data.

Free , Commercial & Open Source

solidDB

solidDB is a fully featured, relational in-memory database that meets the performance and reliability demands of real-time applications. There are currently millions of deployments utilizing the power of SolidDB for telecommunications networks, enterprise applications, and embedded software & systems. Market leaders such as Cisco, HP, Alcatel, Nokia and Siemens rely on solidDB for their mission-critical applications.

Free & Open Source

TiDB

A Chinese developed open-source NewSQL database that supports analytical processing and hybrid transactional workloads. TiDB is licensed under the Apache 2.0 license and primarily developed by PingCAP, Inc. The database provides high availability with strong consistency and horizontal scaling and is compatible with MySQL.

Free & Open Source

How Are These PostgreSQL Alternatives Generated?

Information found on this page is crowd-sourced by the community and contains the most agreed upon PostgreSQL alternatives. You can use this information to find similar software to PostgreSQL for specific platforms with various pricing options and licenses. Anyone that have previously used PostgreSQL can suggest alternatives, vote on the accuracy of other users claims, and help more people in the process of doing so.

This page was last updated on Sun 23 Jan 2022 (3 weeks, 1 day ago).