MySQL

vs

TimescaleDB

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 development for over 30 years now, and powers many of the applications you use on a daily basis.

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.

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.

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.

OpenTSDB is a free and open-source distributed, scalable Time Series Database written on top of Apache HBase. OpenTSDB was designed to address a common need: store, index and serve metrics collected from computer systems such as network gear, operating systems and applications, at a large scale, and make this data easily accessible and graphable. OpenTSDB allows you to collect thousands of metrics from tens of thousands of hosts and applications, at a high rate and will never delete or downsample data and can easily store hundreds of billions of data points.

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.