CockroachDB

vs

QuestDB

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.

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.

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.

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.

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.