PostgreSQL

vs

TiDB

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.

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.

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.

MongoDB is an open-source document-oriented distributed database built for modern applications. MongoDB uses JSON-like documents with optional schemas and is classified as a NoSQL database. The database is freely distributed under the Server Side Public License, but MongoDB provides commercial version of the database for enterprise-scale applications.

ArangoDB is a database system that was designed to support key/value, document, and graph data to be stored together, and queried via a unified language called AQL. The project is developed by ArangoDB GmbH, and released free and open-source under the Apache License 2.0. The universal "native multi-level" design of the database allows for a flexible approach when structuring and building an application, a feature that many have come to love.

CouchDB is a free and open-source document-oriented NoSQL database developed by the Apache Foundation. The database is written and implemented in the language Erlang and provides the use of multiple formats and protocols to store, transfer, and process data. With CouchDB you query data with JavaScript using MapReduce, and HTTP for an API. Which can be done across multiple distributed CouchDB instances as the database has the ability to synchronize multiple copies of the same database, across servers.