DB-Engines Rankings. A list ranking the popularity of database systems.
Database Of Databases: From the Carnegie Mellon Database Group
Data Science Laboratory System A page I put up that runs through some of these database systems.
Relational DBs:
Citus: PostGres as a distributed service
H2: Written in Java : Can be embedded or run as server
HyperSQL: 100% Java
MariaDB: “Drop-in” replacement for MySQL – Led by original MySQL developers after MySQL was acquired by Oracle – Post On MariaDB
Percona Server: MySQL replacement
SQLite: Embedded relational database – Post On SQLite
Relational DB Variants:
AlloyDB: Google – Postgres compatible
Amazon Aurora: Cloud based relational store – Compatible with MySQL and PostGres – 1 node but data storage is scaled and automatically replicated
Supabase: Postgres DB – Firebase compatible – Open Source
OLAP / Data Warehouse:
BigQuery: Google – Data warehouse platform
Clickhouse: Open source
DuckDB: Embedded, no server process (Like SQLite) – Post On DuckDB
Snowflake: Cloud data warehouse – Post On Snowflake
Column Family DBs
Cassandra: Apache – Developed at Facebook – Post On Cassandra
Google Bigtable: Each data point is time-versioned – Tables segmented into tablets
HBase: Apache Hadoop
Document DBs:
CouchDB: Apache – Stores documents as JSON – Uses HTTP for API
Firestore: Google document DB – MongoDB compatibility
MongoDB: Stores documents as binary JSON – Post On Mongo
RavenDB: Document DB for .Net
RethinkDB: Open source – Distributed JSON document DB – Supports joins – Can push query results out to application – Part of the Linux Foundation as of 2/2017
Graph DBs
Neo4j: Post On Neo4j
Key/Value Stores
Memcached: In-memory – Open Source
Redis: Open source – Post On Redis – More restrictive licensing added in 2024
RocksDB: Fork of Google’s LevelDB – Developed at Facebook – Embedded DB – Optimized for Flash and RAM storage
Valkey: Open Source – In-memory – Fork of Redis after Redis licensing changes
New SQL (Distributed ACID/SQL Databases)
Cockroach DB: Has distributed transactions – Can be used with Postgres DB drivers – Post On CockroachDB
Datomic: Cloud, or can run on top of other databases
NuoDB: Post On NuoDB
Planet Scale: MySQL compatible – Uses Vitess (Horizontal MySQL scaling) – Safe Migrations option – Can branch for Dev, and merge schema changes to Prod
Spanner: Google – Uses TrueTime system (globally synchronized clock) – Doesn’t support DML statements
VoltDB: Post On VoltDB
YugabyteDB: Forked from Postgres query layer
Multi-Model:
ArrangoDB: Hybrid Key/Value, Document and Graph DB
Couchbase: Company from Membase/CouchOne merger – Key/Value and Document – Memcached compatible.
Cosmos DB: Microsoft Azure multi-model database system – Post On Cosmos
Dynamo DB: Amazon – Document and Key/Value
Fauna: Document/Relational – Document data model, but supports joins, foreign keys, ACID transactions.
FoundationDB: Open source, developed by Apple.
OrientDB: Hybrid Document-Graph DB – ACID and SQL
SingleStore: Distributed relational DB – Linux or Cloud – Hybrid transactional and analytical
Various:
Aerospike: In-memory NOSQL DB
Eloquera: .Net Object DB – Store C# objects
Firebase Realtime Database: Cloud-based NoSQL database – Stores data in JSON – Allows for data synchronization.
Influx DB: Time-series DB – Post On InfluxDB
ksqlDB: Event streaming DB
Pinecone: Vector database – Post On Pinecone
Presto: Distributed SQL query engine – Can query S3 as well as other data sources
SQream: GPU Data Warehouse
TiDB: HTAP – Hybrid Transactional/Analytical Processing – Open Source – MySQL compatible
TileDB: Universal Database – Stores data in Multi-dimensional arrays
Timescale: Time-Series on Postgres
SQL Rob 