License & Deployment Mix: 30 tools – 22 OSS, 0 SaaS. (OSS and SaaS counts can overlap when an open-source tool also offers a vendor-hosted edition.)

What Are Database Systems?

Database systems are software platforms that store, organize, retrieve, and manage structured or semi-structured data. They provide the persistence layer for virtually every application – from simple web forms to globally distributed enterprise platforms.

Database systems have evolved far beyond traditional relational tables. Modern organizations choose from multiple database paradigms based on data shape, query patterns, scalability requirements, and consistency guarantees:

  • Relational (RDBMS) – SQL-based systems with ACID transactions, rigid schemas, and declarative joins. The backbone of enterprise applications for decades.
  • Document databases – store data as JSON/BSON documents with flexible schemas. Ideal for content management, catalogs, and applications with evolving data models.
  • Key-value stores – high-performance systems optimized for simple get/set operations. Used for caching, sessions, queues, and real-time data.
  • Wide-column stores – massively scalable distributed stores designed for high write throughput and large datasets across many nodes.
  • Time-series databases – optimized for time-stamped data (metrics, IoT, financial data). Append-heavy workloads with time-range queries.
  • Graph databases – model data as nodes and relationships. Used for social networks, knowledge graphs, fraud detection, and recommendation engines.
  • NewSQL / Distributed SQL – combine SQL semantics with horizontal scalability. Designed for cloud-native, globally distributed deployments that need both ACID and scale.
  • Search engines (as databases) – full-text search and analytics engines that can serve as primary data stores for log data, content search, and analytics workloads.

The information on these pages was researched by a combination of human review and large language models. To suggest an addition or correction, please contact us. Prepared by Rhodium Systems Inc., author of the ResorsIT platform — a unified IT operations management platform for IT teams and MSPs that integrates a curated suite of open-source, commercial, and SaaS applications into a single system with shared identity, single sign-on, access control, and a common audit trail. Use this catalogue only as a starting point for your own research, and review any tool carefully against your own requirements before relying on it. Catalogue data version 2026.197.

Comparison

This evaluation covers the broader database landscape, including the identity and authentication mechanisms that any integration layer must connect through.


Overview Comparison

ToolTypeLicenseLanguageDeploymentPricing
PostgreSQLRDBMSPostgreSQL LicenseCSelf-hosted, CloudFree (self-hosted); managed cloud pricing
MySQLRDBMSGPL-2.0C/C++Self-hosted, CloudFree (self-hosted); managed cloud pricing
MariaDBRDBMSGPL-2.0C/C++Self-hosted, CloudFree (self-hosted); SkySQL cloud pricing
SQLiteEmbedded RDBMSPublic DomainCEmbedded (library)Free
CockroachDBDistributed SQLBSL / CCLGoSelf-hosted, CloudFree (core); CockroachDB Cloud per-node
YugabyteDBDistributed SQLApache-2.0 (core)C/C++Self-hosted, CloudFree (core); YugabyteDB Managed per-node
TiDBDistributed SQLApache-2.0GoSelf-hosted, CloudFree (self-hosted); TiDB Cloud per-node
SQL ServerRDBMSProprietaryC/C++Self-hosted, CloudExpress (free); Standard from $3,945; Enterprise from $15,123
Oracle DatabaseRDBMSProprietaryC/C++Self-hosted, CloudXE (free); SE2 and EE per-processor/NUP licensing
IBM Db2RDBMSProprietaryC/C++Self-hosted, CloudCommunity (free); Standard and Advanced per-VPC
MongoDBDocument DBSSPLC++Self-hosted, CloudFree (Community); Atlas cloud per-hour
CouchDBDocument DBApache-2.0ErlangSelf-hosted, CloudFree (self-hosted); IBM Cloudant (managed)
FerretDBMongoDB-compat on PostgreSQLApache-2.0GoSelf-hosted, CloudFree (self-hosted); managed cloud pricing
RedisKey-Value / CacheRSALv2 / SSPLv1CSelf-hosted, CloudFree (self-hosted); Redis Cloud per-GB
ValkeyKey-Value / CacheBSD-3CSelf-hosted, CloudFree (self-hosted); AWS ElastiCache/MemoryDB
KeyDBKey-Value / CacheBSD-3C++Self-hostedFree
DragonflyDBKey-Value / CacheBSLC++Self-hosted, CloudFree (self-hosted); Dragonfly Cloud pricing
MemcachedCacheBSD-3CSelf-hosted, CloudFree (self-hosted); AWS ElastiCache
Apache CassandraWide-ColumnApache-2.0JavaSelf-hosted, CloudFree (self-hosted); DataStax Astra per-GB
ScyllaDBWide-ColumnAGPL-3.0C++Self-hosted, CloudFree (OSS); ScyllaDB Cloud per-node
Apache HBaseWide-ColumnApache-2.0JavaSelf-hosted, CloudFree (self-hosted); cloud Hadoop services
TimescaleDBTime-SeriesApache-2.0 (core)CSelf-hosted, CloudFree (core); Timescale Cloud per-compute
QuestDBTime-SeriesApache-2.0Java, C++Self-hosted, CloudFree (OSS); QuestDB Cloud pricing
TDengineTime-SeriesAGPL-3.0CSelf-hosted, CloudFree (OSS); TDengine Cloud pricing
Neo4jGraph DBGPL-3.0 (CE)JavaSelf-hosted, CloudFree (CE); Neo4j AuraDB per-GB
ArangoDBMulti-ModelApache-2.0C++Self-hosted, CloudFree (CE); ArangoGraph per-node
DgraphGraph DBApache-2.0 (core)GoSelf-hosted, CloudFree (core); Dgraph Cloud pricing
VitessMySQL ShardingApache-2.0GoSelf-hosted, CloudFree; PlanetScale (managed Vitess)
PgBouncerPostgreSQL PoolerISCCSelf-hostedFree
ProxySQLMySQL/MariaDB ProxyGPL-3.0C++Self-hostedFree (OSS); ProxySQL Admin from quote

Query Language & Data Model

ToolQuery LanguageData ModelSchemaJoinsTransactions (ACID)
PostgreSQLSQL (advanced compliance)Relational (tables, JSONB)Strict + flexible (JSONB)Yes (full SQL joins)Yes (serializable, repeatable read, read committed)
MySQLSQLRelational (tables, JSON)StrictYes (full SQL joins)Yes (InnoDB: repeatable read default)
MariaDBSQLRelational (tables, JSON)StrictYes (full SQL joins)Yes (InnoDB/Aria: repeatable read default)
SQLiteSQL (subset)Relational (tables, JSON)Flexible (type affinity)Yes (full SQL joins)Yes (serializable via WAL)
CockroachDBSQL (PostgreSQL wire)Relational (distributed)StrictYes (distributed joins)Yes (serializable default)
YugabyteDBSQL (PostgreSQL) / CQLRelational (distributed)Strict (YSQL) / flexible (YCQL)Yes (YSQL) / No (YCQL)Yes (snapshot isolation / serializable)
TiDBSQL (MySQL compatible)Relational (distributed)StrictYes (distributed joins)Yes (snapshot isolation; optimistic/pessimistic)
SQL ServerT-SQLRelational (tables, JSON)StrictYes (full SQL joins)Yes (read committed default; snapshot)
Oracle DatabasePL/SQLRelational (tables, JSON)StrictYes (full SQL joins)Yes (read committed default; serializable)
IBM Db2SQL (ANSI compliant)Relational (tables, JSON, XML)StrictYes (full SQL joins)Yes (cursor stability default)
MongoDBMQL (MongoDB Query Language)Document (BSON)Schema-free (optional validation)No native joins ($lookup aggregation)Yes (multi-document since 4.0)
CouchDBHTTP/REST API; Mango queriesDocument (JSON)Schema-freeNoNo (eventual consistency; per-doc ACID)
FerretDBMQL (MongoDB compatible)Document (JSON on PostgreSQL)Schema-freeNo native joins ($lookup)Yes (via PostgreSQL backend)
RedisRedis commandsKey-value (strings, hashes, lists, sets, sorted sets, streams)Schema-freeNoYes (MULTI/EXEC; Lua scripts are atomic)
ValkeyRedis-compatible commandsKey-value (same as Redis)Schema-freeNoYes (MULTI/EXEC; Lua scripts)
KeyDBRedis-compatible commandsKey-value (same as Redis)Schema-freeNoYes (MULTI/EXEC; Lua scripts)
DragonflyDBRedis/Memcached commandsKey-value (Redis-compatible)Schema-freeNoYes (MULTI/EXEC)
MemcachedMemcached protocol (get/set)Key-value (binary blobs)Schema-freeNoNo
CassandraCQL (SQL-like)Wide-column (partition key + clustering)Schema-defined (tables)NoLimited (lightweight transactions; per-partition)
ScyllaDBCQL (Cassandra compatible)Wide-column (partition key + clustering)Schema-defined (tables)NoLimited (lightweight transactions)
HBaseJava API; HBase Shell; Phoenix SQLWide-column (row key + column families)Schema-defined (column families)NoLimited (per-row atomic)
TimescaleDBSQL (full PostgreSQL)Relational + hypertables (time-series)Strict (PostgreSQL)Yes (full SQL joins)Yes (full PostgreSQL ACID)
QuestDBSQL (PostgreSQL wire) + InfluxDB Line ProtocolColumnar (time-series)Schema-on-writeYes (limited joins)No (append-only; eventual consistency)
TDengineSQL-like (TAOS SQL)Time-series (supertables, subtables)Schema-definedYes (limited joins)No (eventual consistency)
Neo4jCypherGraph (nodes, relationships, properties)Schema-optional (constraints)N/A (graph traversal)Yes (full ACID)
ArangoDBAQL (ArangoDB Query Language)Multi-model (document, graph, key-value)Schema-optional (validation)Yes (graph traversal + document joins)Yes (full ACID)
DgraphDQL (Dgraph Query Language) / GraphQLGraph (predicates, nodes)Schema-defined (types)N/A (graph traversal)Yes (distributed ACID)
VitessSQL (MySQL compatible)Relational (sharded MySQL)Strict (MySQL)Yes (cross-shard via scatter-gather)Yes (single-shard ACID; cross-shard 2PC)
PgBouncerN/A (proxy)N/A (proxy)N/AN/AN/A (passes through to PostgreSQL)
ProxySQLN/A (proxy)N/A (proxy)N/AN/AN/A (passes through to MySQL)

Identity & Authentication

This is the most critical comparison table for integration planning: a connection layer must speak whatever auth mechanism a given database has configured.

ToolPassword AuthCertificate / TLSKerberos / GSSAPILDAPIAM TokensPAMVault IntegrationConnection Encryption
PostgreSQLmd5, SCRAM-SHA-256Yes (client cert)Yes (GSSAPI)Yes (ldap method)AWS RDS IAM, Azure AD, GCP IAMYesYes (database secrets engine)TLS 1.2+ (sslmode: verify-full)
MySQLmysql_native_password, caching_sha2_passwordYes (client cert)No native (via PAM)Yes (auth_ldap plugin, Enterprise)AWS RDS IAM, Azure AD, GCP IAMYes (auth_pam plugin)Yes (database secrets engine)TLS 1.2+ (–require_secure_transport)
MariaDBmysql_native_password, ed25519Yes (client cert)Yes (auth_gssapi plugin)Yes (auth_pam + LDAP)AWS RDS IAMYes (auth_pam plugin)Yes (database secrets engine)TLS 1.2+ (–require_secure_transport)
SQLiteN/A (embedded; no network auth)N/AN/AN/AN/AN/AN/AN/A (file-level; OS permissions)
CockroachDBPassword (SCRAM-SHA-256)Yes (client cert)Yes (GSSAPI, Enterprise)Yes (Enterprise)No native (via Vault)NoYes (database secrets engine)TLS 1.2+ (required by default)
YugabyteDBPassword (md5, SCRAM-SHA-256)Yes (client cert)NoYes (YSQL ldap method)No native (via Vault)NoYes (database secrets engine)TLS 1.2+ (configurable)
TiDBmysql_native_password, caching_sha2_passwordYes (client cert)NoYes (LDAP auth plugin)No native (via Vault)NoYes (database secrets engine)TLS 1.2+ (configurable)
SQL ServerSQL auth (password)Yes (certificate)Yes (Windows auth, NTLM/Kerberos)Yes (via AD)Azure AD / Entra IDNoYes (database secrets engine)TLS 1.2+ (Encrypt=True)
Oracle DatabasePassword (SHA-512)Yes (SSL cert)Yes (Kerberos)Yes (LDAP, OID, AD)No native (OCI IAM for cloud)NoYes (database secrets engine)TLS 1.2+ (TCPS / native encryption)
IBM Db2PasswordYes (SSL cert)Yes (Kerberos)Yes (via OS LDAP)No native (IBM Cloud IAM for cloud)NoYes (via custom plugin)TLS 1.2+ (configurable)
MongoDBSCRAM-SHA-256, SCRAM-SHA-1Yes (x.509 cert)Yes (Kerberos, Enterprise)Yes (LDAP, Enterprise)AWS IAM (Atlas)NoYes (database secrets engine)TLS 1.2+ (–tls, –tlsCAFile)
CouchDBPassword (PBKDF2)Yes (client cert via reverse proxy)NoNo (via proxy)NoNoNo native (via proxy)TLS 1.2+ (ssl config)
FerretDBSCRAM-SHA-256 (via PostgreSQL)Yes (via PostgreSQL cert auth)Yes (via PostgreSQL GSSAPI)Yes (via PostgreSQL ldap)Via PostgreSQL IAMYes (via PostgreSQL PAM)Yes (via PostgreSQL Vault)TLS 1.2+ (via PostgreSQL)
RedisPassword (requirepass), ACL usersYes (TLS client cert)NoNoNo nativeNoYes (database secrets engine)TLS 1.2+ (tls-port, tls-cert-file)
ValkeyPassword (requirepass), ACL usersYes (TLS client cert)NoNoNo nativeNoYes (via Redis-compatible engine)TLS 1.2+ (same as Redis)
KeyDBPassword (requirepass), ACL usersYes (TLS client cert)NoNoNo nativeNoYes (via Redis-compatible engine)TLS 1.2+ (same as Redis)
DragonflyDBPassword (requirepass), ACL usersYes (TLS client cert)NoNoNo nativeNoYes (via Redis-compatible engine)TLS 1.2+ (TLS config)
MemcachedNo native auth (SASL optional)No native (stunnel for TLS)NoNoNoNoNoNo native (stunnel or proxy)
CassandraPasswordAuthenticatorYes (client cert, internode TLS)Yes (Kerberos via DataStax)Yes (LDAP via DataStax Enterprise)No nativeNoYes (database secrets engine)TLS 1.2+ (client_encryption_options)
ScyllaDBPasswordAuthenticator (Cassandra-compatible)Yes (client cert)No nativeYes (LDAP, Enterprise)No nativeNoYes (database secrets engine)TLS 1.2+ (client_encryption_options)
HBaseNo native (Kerberos required for secure mode)No nativeYes (Kerberos, required for security)NoNoNoNoTLS (configurable; SASL)
TimescaleDBVia PostgreSQL (md5, SCRAM-SHA-256)Yes (via PostgreSQL cert)Yes (via PostgreSQL GSSAPI)Yes (via PostgreSQL ldap)Via PostgreSQL IAMYes (via PostgreSQL PAM)Yes (via PostgreSQL Vault)TLS 1.2+ (via PostgreSQL)
QuestDBPassword (basic auth)Yes (TLS)NoNoNoNoNoTLS 1.2+ (configurable)
TDenginePasswordYes (TLS)NoNoNoNoNoTLS 1.2+ (configurable)
Neo4jNative auth (bcrypt)Yes (client cert, bolt+s)Yes (Kerberos, Enterprise)Yes (LDAP, Enterprise)No nativeNoNo native (via plugin)TLS 1.2+ (bolt+s, https)
ArangoDBPassword (PBKDF2)Yes (TLS client cert)NoYes (LDAP, Enterprise)No nativeNoNo nativeTLS 1.2+ (–ssl.endpoint)
DgraphPassword (ACL, Enterprise)Yes (mutual TLS)NoNoNoNoNoTLS 1.2+ (–tls)
VitessVia MySQL (pass-through)Yes (via MySQL TLS)No nativeVia MySQLVia MySQLVia MySQLYes (via MySQL Vault engine)TLS 1.2+ (via MySQL)
PgBouncerPass-through to PostgreSQL; md5, SCRAM-SHA-256Yes (client cert pass-through)No (terminates at PgBouncer)NoNoNoYes (via PostgreSQL)TLS 1.2+ (client_tls_sslmode)
ProxySQLPass-through to MySQL; hashed passwordsYes (TLS termination)NoNo (queries MySQL users)NoNoYes (via MySQL Vault engine)TLS 1.2+ (mysql-ssl_p2s)

Best auth flexibility: PostgreSQL (9 methods), SQL Server (SQL + Windows + Azure AD + cert), Oracle (password + Kerberos + LDAP + cert + RADIUS

  • OS), MongoDB Enterprise (SCRAM + x.509 + LDAP + Kerberos + IAM)

Cloud IAM auth: PostgreSQL (AWS/Azure/GCP), MySQL (AWS/Azure/GCP), SQL Server (Azure AD), MongoDB Atlas (AWS IAM)

Vault database secrets engine: PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, MongoDB, Cassandra, CockroachDB, Redis, Elasticsearch

No network auth (embedded): SQLite

Minimal auth: Memcached (SASL only; no TLS without stunnel), QuestDB, TDengine, Dgraph


Replication & High Availability

ToolReplication TypeMulti-MasterAuto-FailoverRead ReplicasCross-Region
PostgreSQLStreaming (sync/async), LogicalNo native (BDR extension)Via Patroni, repmgr, pg_auto_failoverYes (streaming replicas)Yes (async streaming)
MySQLBinary log (async, semi-sync), Group ReplicationYes (Group Replication, NDB Cluster)Yes (Group Replication, InnoDB Cluster)Yes (read replicas)Yes (async replication)
MariaDBBinary log (async, semi-sync), GaleraYes (Galera Cluster)Yes (Galera, MaxScale)Yes (read replicas)Yes (async replication)
SQLiteNo native (Litestream for streaming)NoNoNoNo
CockroachDBRaft consensus (synchronous)Yes (multi-active)Yes (automatic)Yes (follower reads)Yes (geo-partitioning)
YugabyteDBRaft consensus (synchronous)Yes (multi-active)Yes (automatic)Yes (follower reads)Yes (geo-distributed)
TiDBRaft consensus (synchronous)No (single write leader per region)Yes (automatic via PD)Yes (follower reads)Yes (multi-datacenter)
SQL ServerAlways On AG (sync/async), Log ShippingNo (Always On is primary + secondaries)Yes (Always On automatic failover)Yes (readable secondaries)Yes (async AG, distributed AG)
Oracle DatabaseData Guard (sync/async), GoldenGateYes (RAC for HA; GoldenGate for multi-master)Yes (Data Guard Fast-Start Failover)Yes (Active Data Guard)Yes (Data Guard, GoldenGate)
IBM Db2HADR (sync/async), Q ReplicationNo native (Q Replication bidirectional)Yes (HADR automatic failover)Yes (HADR standby reads)Yes (Q Replication)
MongoDBReplica set (async; optional majority write concern)No (single primary per replica set)Yes (automatic election)Yes (secondary reads)Yes (cross-region replica sets)
CouchDBMulti-master (CouchDB Replication Protocol)Yes (native)No native (manual promotion)Yes (any node reads)Yes (cross-region sync)
FerretDBVia PostgreSQL replicationVia PostgreSQLVia PostgreSQLVia PostgreSQLVia PostgreSQL
RedisAsync replicationNo (Redis Cluster: single master per shard)Yes (Redis Sentinel, Redis Cluster)Yes (read replicas)No native (Redis Enterprise)
ValkeyAsync replication (same as Redis)NoYes (Sentinel, Cluster mode)Yes (read replicas)No native
KeyDBAsync replication + Active ReplicationYes (Active Replication)Yes (Active Replication)Yes (read replicas)No native
DragonflyDBAsync replication (Redis-compatible)NoNo nativeYes (read replicas)No native
MemcachedNo native replicationNoNoNoNo
CassandraAsync replication (tunable consistency)Yes (all nodes accept writes)Yes (masterless; no failover needed)Yes (any node reads)Yes (multi-datacenter)
ScyllaDBAsync replication (Cassandra-compatible)Yes (all nodes accept writes)Yes (masterless)Yes (any node reads)Yes (multi-datacenter)
HBaseAsync replication (WAL-based)No (single master per region)Yes (automatic region failover)No (reads from region server)Yes (cross-cluster replication)
TimescaleDBVia PostgreSQL replicationVia PostgreSQLVia PostgreSQL (Patroni)Via PostgreSQLVia PostgreSQL
QuestDBEnterprise replicationNoEnterpriseEnterpriseEnterprise
TDengineVnode replication (sync/async)No (single leader per vgroup)Yes (automatic)Yes (follower reads)No native
Neo4jRaft consensus (causal clustering)No (single write leader)Yes (automatic leader election)Yes (read replicas)Yes (multi-datacenter)
ArangoDBSynchronous replication (cluster)No (single leader per shard)Yes (automatic failover)Yes (follower reads)Yes (datacenter-to-datacenter)
DgraphRaft consensusNo (single leader per group)Yes (automatic)Yes (any replica reads)No native
VitessVia MySQL replicationVia MySQLYes (PlannedReparent, EmergencyReparent)Yes (via MySQL replicas)Yes (via MySQL async)
PgBouncerN/A (pooler)N/AN/A (relies on PostgreSQL failover)N/A (can route to replicas)N/A
ProxySQLN/A (proxy)N/AYes (detects backend failures; reroutes)Yes (read/write split)N/A

Best HA: CockroachDB, YugabyteDB (automatic Raft consensus; built-in); Cassandra, ScyllaDB (masterless; no single point of failure)

PostgreSQL HA: Requires external tooling (Patroni, repmgr) for automatic failover. This is well-understood and widely deployed.

Key-value HA: Redis Sentinel/Cluster, Valkey Cluster for automatic failover. KeyDB Active Replication provides true multi-master.


Scalability

ToolHorizontal ScalingShardingMax Cluster SizeCloud-Managed Options
PostgreSQLLimited (read replicas; Citus extension for sharding)Citus (extension), manualSingle primary + replicas; Citus: 100+ nodesAWS RDS/Aurora, Azure Database, GCP Cloud SQL, Supabase, Neon
MySQLLimited (read replicas; NDB Cluster, Vitess for sharding)NDB Cluster, Vitess, ProxySQLSingle primary + replicas; NDB: 48 data nodesAWS RDS/Aurora, Azure Database, GCP Cloud SQL
MariaDBLimited (read replicas; Galera for multi-master)MariaDB MaxScale, Spider engineGalera: tested to 10+ nodes; MaxScale routesSkySQL, AWS RDS, Azure Database
SQLiteNone (single file)N/ASingle processN/A (embedded)
CockroachDBNative (automatic sharding)Automatic range-basedTested to 1,000+ nodesCockroachDB Dedicated/Serverless
YugabyteDBNative (automatic sharding)Automatic hash/rangeTested to 100+ nodesYugabyteDB Managed
TiDBNative (automatic sharding)Automatic (TiKV regions)Tested to 100+ nodesTiDB Cloud (AWS, GCP)
SQL ServerLimited (read replicas, AG)Table partitioning; no native shardingAlways On AG: up to 9 replicasAzure SQL Database (serverless, Hyperscale)
Oracle DatabaseRAC (scale-up), Sharding (scale-out)Oracle Sharding (12.2+)RAC: 100+ nodesOCI Autonomous Database, Exadata Cloud
IBM Db2pureScale (scale-out)DPF (Database Partitioning Feature)pureScale: 128 membersIBM Cloud Databases for Db2
MongoDBNative (automatic sharding)Hash, range, zone-based shardingTested to 1,000+ shardsMongoDB Atlas (AWS, Azure, GCP)
CouchDBNative (automatic sharding in 2.x+)AutomaticTested to dozens of nodesIBM Cloudant
FerretDBVia PostgreSQL (Citus or read replicas)Via PostgreSQLVia PostgreSQLFerretDB on managed PostgreSQL
RedisRedis Cluster (hash slots)Automatic (16,384 hash slots)Cluster: 1,000 nodes (recommended)AWS ElastiCache, Azure Cache, Redis Cloud
ValkeyCluster mode (hash slots)Automatic (16,384 hash slots)Same as Redis ClusterAWS ElastiCache, AWS MemoryDB
KeyDBCluster mode + Active ReplicationAutomatic (hash slots)Similar to Redis ClusterN/A
DragonflyDBCluster mode (emulated)Hash-basedTested to multi-nodeDragonfly Cloud
MemcachedClient-side sharding (consistent hashing)Client-side onlyNo limit (client-side distribution)AWS ElastiCache
CassandraNative (automatic sharding)Automatic (consistent hashing, vnodes)Tested to 1,000+ nodesDataStax Astra (serverless)
ScyllaDBNative (automatic sharding, shard-per-core)Automatic (consistent hashing)Tested to 1,000+ nodesScyllaDB Cloud
HBaseNative (automatic region splitting)Automatic (region-based)Tested to 1,000+ region serversAWS EMR, Azure HDInsight, GCP Dataproc
TimescaleDBMulti-node (distributed hypertables)Automatic (time + space partitioning)Multi-node: tested to 20+ nodesTimescale Cloud
QuestDBEnterprise (limited)No nativeSingle node (OSS)QuestDB Cloud
TDengineNative (vgroups)Automatic (vnode-based)Tested to 100+ dnodesTDengine Cloud
Neo4jCausal clustering (read scale-out)No native sharding (fabric for federation)Causal cluster: tested to 20+ nodesNeo4j AuraDB (AWS, GCP)
ArangoDBNative clustering (automatic sharding)Automatic (hash-based)Tested to 100+ nodesArangoGraph (AWS, Azure, GCP)
DgraphNative (automatic sharding via groups)Automatic (predicate-based)Tested to 100+ nodesDgraph Cloud
VitessNative (horizontal sharding of MySQL)Hash, range, custom shardingTested to 1,000+ shards (YouTube scale)PlanetScale
PgBouncerN/A (pooler)N/ASingle instance (multiple for HA)N/A
ProxySQLN/A (proxy; routes to multiple backends)N/A (routing only)ProxySQL Cluster for proxy HAN/A

Backup & Recovery

ToolPoint-in-Time RecoveryLogical BackupPhysical BackupContinuous Backup
PostgreSQLYes (WAL archiving + pg_basebackup)pg_dump, pg_dumpallpg_basebackup, pgBackRest, BarmanYes (WAL archiving, pgBackRest, Barman)
MySQLYes (binlog + full backup)mysqldump, mysqlpump, mydumperPercona XtraBackup, MySQL Enterprise BackupYes (binlog streaming)
MariaDBYes (binlog + full backup)mysqldump, mariadb-dump, mydumperMariabackup (fork of XtraBackup)Yes (binlog streaming)
SQLiteNo native PITR.dump command, sqlite3_backup APIFile copy (with WAL checkpoint)Litestream (continuous WAL replication)
CockroachDBYes (AOST: AS OF SYSTEM TIME)BACKUP / RESTORE (SQL)N/A (distributed; backup is logical)Yes (incremental + scheduled BACKUP)
YugabyteDBYes (PITR with YSQL)ysql_dump, ycql_dumpyb_backup (distributed snapshot)Yes (incremental snapshots)
TiDBYes (via BR tool + binlog/CDC)Dumpling (logical export)BR (Backup & Restore; distributed)Yes (TiCDC for change capture)
SQL ServerYes (transaction log backup + restore)BCP, BACPAC, SQL exportFull/Differential/Log backupYes (log shipping, managed backup)
Oracle DatabaseYes (RMAN + archived redo logs)Data Pump (expdp/impdp)RMAN (Recovery Manager)Yes (RMAN + archived logs, Data Guard)
IBM Db2Yes (log-based PITR)db2move, db2lookdb2 BACKUP DATABASEYes (log archiving)
MongoDBYes (oplog-based PITR)mongodump / mongorestorePercona Backup for MongoDB, Atlas BackupYes (continuous backup, Atlas)
CouchDBNo native PITRReplication to backup nodeFile-system snapshotContinuous replication (via replicator)
FerretDBVia PostgreSQL PITRVia pg_dumpVia pg_basebackupVia PostgreSQL WAL archiving
RedisNo native PITRN/A (not applicable)RDB snapshots, AOF persistenceAOF (append-only file; fsync policies)
ValkeyNo native PITRN/ARDB snapshots, AOF persistenceAOF (same as Redis)
KeyDBNo native PITRN/ARDB snapshots, AOF, FLASHAOF (same as Redis)
DragonflyDBNo native PITRN/ARDB snapshotsSnapshot-based
MemcachedN/A (no persistence)N/AN/AN/A
CassandraNo native PITRCQL COPY, sstableloadernodetool snapshot (SSTable snapshots)No native (Medusa for scheduled backup)
ScyllaDBNo native PITRCQL COPYnodetool snapshot (compatible)ScyllaDB Manager (scheduled snapshots)
HBaseNo native PITRExport/CopyTableHBase snapshotNo native (snapshot-based)
TimescaleDBVia PostgreSQL PITRVia pg_dump (with timescaledb options)Via pg_basebackupVia PostgreSQL WAL archiving
QuestDBNo native PITRREST API export (CSV)File-system snapshotNo native
TDengineNo native PITRtaosdumpFile-system snapshotNo native
Neo4jNo native PITRneo4j-admin dumpneo4j-admin dump (offline) / backup (online, Enterprise)No native (scheduled backup)
ArangoDBNo native PITRarangodump / arangorestoreHot backup (Enterprise)No native (scheduled hot backup)
DgraphNo native PITRdgraph export (RDF/JSON)dgraph backup (Enterprise)Incremental backup (Enterprise)
VitessVia MySQL PITRVia mysqldump (per shard)VTBackup (per shard physical)Via MySQL binlog
PgBouncerN/A (pooler)N/AN/AN/A
ProxySQLN/A (proxy)N/AN/AN/A

Best PITR: PostgreSQL (pgBackRest, Barman), MySQL (XtraBackup + binlog), SQL Server (log-based), Oracle (RMAN), MongoDB (oplog-based)

Distributed backup: CockroachDB, YugabyteDB, TiDB (built-in distributed backup and restore)

No persistence: Memcached (pure cache; no backup applicable)


Monitoring Integration

How each database integrates with monitoring components (Telegraf for metrics, Fluent Bit for logs, Grafana for dashboards).

ToolTelegraf Input PluginFluent BitGrafana DashboardPrometheus Exporter
PostgreSQLinputs.postgresql, inputs.postgresql_extensibleYes (postgresql.log, slow query log)Yes (community dashboards; connections, replication, locks)postgres_exporter
MySQLinputs.mysqlYes (error log, slow query log, general log)Yes (community dashboards; InnoDB, replication, queries)mysqld_exporter
MariaDBinputs.mysql (compatible)Yes (error log, slow query log)Yes (same as MySQL dashboards)mysqld_exporter (compatible)
SQLiteNo (embedded; no network metrics)No (application-level only)NoNo
CockroachDBinputs.prometheus (CockroachDB exposes Prometheus endpoint)Yes (cockroach.log)Yes (community dashboards; SQL, storage, replication)Native Prometheus endpoint
YugabyteDBinputs.prometheus (Prometheus endpoint)Yes (yb-tserver.log, yb-master.log)Yes (community dashboards)Native Prometheus endpoint
TiDBinputs.prometheus (Prometheus endpoint)Yes (tidb.log, tikv.log, pd.log)Yes (TiDB-specific Grafana dashboards)Native Prometheus endpoint
SQL Serverinputs.sqlserverYes (error log, SQL Agent log)Yes (community dashboards; waits, I/O, AG health)sql_exporter
Oracle Databaseinputs.execd (custom script), inputs.prometheusYes (alert log, audit log)Yes (custom dashboards via oracledb_exporter)oracledb_exporter
IBM Db2inputs.execd (custom script)Yes (db2diag.log, audit log)Yes (custom dashboards)No standard exporter
MongoDBinputs.mongodbYes (mongod.log, structured JSON)Yes (community dashboards; operations, replication, WiredTiger)mongodb_exporter
CouchDBinputs.couchdbYes (CouchDB log)Yes (community dashboards)couchdb_exporter
FerretDBVia PostgreSQL pluginsVia PostgreSQL logsVia PostgreSQL dashboardsVia postgres_exporter
Redisinputs.redisYes (redis-server log)Yes (community dashboards; memory, clients, commands)redis_exporter
Valkeyinputs.redis (compatible)Yes (valkey-server log)Yes (same as Redis dashboards)redis_exporter (compatible)
KeyDBinputs.redis (compatible)Yes (keydb-server log)Yes (same as Redis dashboards)redis_exporter (compatible)
DragonflyDBinputs.redis (compatible)Yes (dragonfly log)Yes (Redis-compatible dashboards)redis_exporter (compatible)
Memcachedinputs.memcachedNo (minimal logging)Yes (community dashboards; connections, hit ratio)memcached_exporter
Cassandrainputs.jolokia2_agent (JMX)Yes (system.log, debug.log)Yes (community dashboards; read/write latency, compactions)jmx_exporter
ScyllaDBinputs.prometheus (native Prometheus endpoint)Yes (scylla.log)Yes (ScyllaDB Monitoring Stack dashboards)Native Prometheus endpoint
HBaseinputs.jolokia2_agent (JMX)Yes (hbase-*.log)Yes (custom dashboards)jmx_exporter
TimescaleDBVia PostgreSQL pluginsVia PostgreSQL logsYes (TimescaleDB-specific + PostgreSQL dashboards)Via postgres_exporter
QuestDBinputs.prometheus (Prometheus endpoint)Yes (QuestDB log)Yes (community dashboards)Native Prometheus endpoint
TDengineinputs.prometheus (Prometheus endpoint)Yes (taosd log)Yes (TDengine Grafana plugin)Native Prometheus endpoint
Neo4jinputs.prometheus (Prometheus endpoint)Yes (neo4j.log, debug.log)Yes (community dashboards)Native Prometheus endpoint (4.x+)
ArangoDBinputs.prometheus (Prometheus endpoint)Yes (arangod.log)Yes (community dashboards)Native Prometheus endpoint
Dgraphinputs.prometheus (Prometheus endpoint)Yes (dgraph.log)Yes (community dashboards)Native Prometheus endpoint
Vitessinputs.prometheus (vtgate/vttablet metrics)Yes (vtgate.log, vttablet.log)Yes (Vitess Grafana dashboards)Native Prometheus endpoint
PgBouncerinputs.pgbouncerYes (pgbouncer.log)Yes (community dashboards; pool stats, wait times)pgbouncer_exporter
ProxySQLinputs.proxysqlYes (proxysql.log)Yes (community dashboards; query rules, backend health)proxysql_exporter

Best monitoring integration: PostgreSQL, MySQL, MariaDB, Redis, MongoDB (dedicated Telegraf input plugins + extensive Grafana dashboards)

Prometheus-native: CockroachDB, YugabyteDB, TiDB, ScyllaDB, Neo4j, ArangoDB, Dgraph, QuestDB, TDengine (expose native Prometheus endpoints; Telegraf scrapes via inputs.prometheus)

JMX-based: Cassandra, HBase (Java-based; monitored via Jolokia + Telegraf inputs.jolokia2)


Cloud-Managed Options

ToolAWSAzureGCPOther Cloud
PostgreSQLRDS, Aurora PostgreSQLAzure Database for PostgreSQLCloud SQL for PostgreSQLSupabase, Neon, Aiven, Crunchy Bridge
MySQLRDS, Aurora MySQLAzure Database for MySQLCloud SQL for MySQLPlanetScale (Vitess), Aiven
MariaDBRDS for MariaDBAzure Database for MariaDBN/A (use Cloud SQL MySQL)SkySQL (MariaDB Corp)
SQLiteN/A (embedded)N/AN/ATurso (libSQL), LiteFS
CockroachDBCockroachDB Cloud (AWS)CockroachDB Cloud (Azure)CockroachDB Cloud (GCP)CockroachDB Dedicated
YugabyteDBYugabyteDB Managed (AWS)YugabyteDB Managed (Azure)YugabyteDB Managed (GCP)
TiDBTiDB Cloud (AWS)N/ATiDB Cloud (GCP)
SQL ServerRDS for SQL ServerAzure SQL Database, SQL Managed InstanceCloud SQL for SQL Server
Oracle DatabaseRDS for OracleN/A (Oracle on Azure VMs)N/A (Bare Metal)OCI Autonomous DB, Exadata Cloud
IBM Db2N/A (Db2 on EC2)N/AN/AIBM Cloud Databases for Db2
MongoDBAtlas (AWS)Atlas (Azure)Atlas (GCP)MongoDB Atlas (multi-cloud)
CouchDBN/A (self-hosted on EC2)N/AN/AIBM Cloudant
FerretDBOn managed PostgreSQL (RDS)On managed PostgreSQL (Azure)On managed PostgreSQL (GCP)
RedisElastiCache, MemoryDBAzure Cache for RedisMemorystore for RedisRedis Cloud (Redis Inc.)
ValkeyElastiCache, MemoryDBN/AN/A
KeyDBN/A (self-hosted)N/AN/A
DragonflyDBDragonfly Cloud (AWS)N/ADragonfly Cloud (GCP)
MemcachedElastiCacheAzure Cache (Memcached-compatible)Memorystore for Memcached
CassandraKeyspaces (Cassandra-compatible)Managed Instance for CassandraN/ADataStax Astra
ScyllaDBScyllaDB Cloud (AWS)N/AScyllaDB Cloud (GCP)
HBaseEMR (HBase)HDInsight (HBase)Bigtable (compatible API)
TimescaleDBTimescale Cloud (AWS)N/ATimescale Cloud (GCP)
QuestDBQuestDB Cloud (AWS)N/AN/A
TDengineTDengine CloudN/AN/A
Neo4jAuraDB (AWS)N/AAuraDB (GCP)
ArangoDBArangoGraph (AWS)ArangoGraph (Azure)ArangoGraph (GCP)
DgraphDgraph Cloud (AWS)N/AN/A
VitessPlanetScale (AWS)N/APlanetScale (GCP)
PgBouncerN/A (self-hosted; built into some managed PG)Built into Azure Database for PostgreSQLN/AAiven includes PgBouncer
ProxySQLN/A (self-hosted)N/AN/A

Best cloud coverage: PostgreSQL, MySQL, SQL Server, MongoDB (managed services on all three major clouds)

Self-hosted only: KeyDB, ProxySQL (no managed cloud service)


Tools

30 tools.

Apache Cassandra

Apache Cassandra is a distributed wide-column database designed for massive scale, high write throughput, and continuous availability with no single point of failure.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

Apache CouchDB

Apache CouchDB is a document-oriented NoSQL database that stores data as JSON documents and exposes all operations through a RESTful HTTP API.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

Apache HBase

Apache HBase is an open-source, distributed, wide-column database modeled after Google’s Bigtable paper.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

ArangoDB

ArangoDB is a native multi-model database that combines document, graph, key-value, and search capabilities in a single engine with a unified query language.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

CockroachDB

CockroachDB is a distributed SQL database designed for cloud-native applications requiring global scale, strong consistency, and survivability.

License: LicenseRef-BSL-1.1 (source-available) · Kind: web · Deploy: native · SSO: none

Website

Dgraph

Dgraph is a horizontally scalable, distributed graph database with a native graph storage engine, offering a GraphQL-native API, its own DQL query language, and ACID transactions.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

DragonflyDB

DragonflyDB is a modern in-memory data store designed as a high-performance replacement for both Redis and Memcached.

License: LicenseRef-DragonflyDB-BSL (source-available) · Kind: web · Deploy: native, docker, k8s · SSO: none

Website

FerretDB

FerretDB is an open-source MongoDB-compatible proxy that translates MongoDB wire protocol commands into SQL and stores data in PostgreSQL (using JSONB or the Microsoft DocumentDB extension) or SQLite.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker, k8s · SSO: none

Website · Source

IBM Db2

IBM Db2 is an enterprise relational database management system with a lineage dating back to 1983 and IBM’s pioneering work in relational database theory.

License: Proprietary (proprietary) · Kind: web · Deploy: native · SSO: none

Website

KeyDB

KeyDB is a multithreaded fork of Redis developed by Snap Inc. (Snapchat’s parent company), designed to overcome Redis’s single-threaded architecture limitation.

License: BSD-3-Clause (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

MariaDB

MariaDB is a community-developed fork of MySQL, created in 2009 by MySQL’s original author Michael “Monty” Widenius after Oracle’s acquisition of Sun Microsystems.

License: GPL-2.0-only (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Memcached

Memcached is a high-performance, distributed memory caching system designed to accelerate dynamic web applications by reducing database load.

License: BSD-3-Clause (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

Microsoft SQL Server

Microsoft SQL Server is an enterprise relational database management system and one of the most widely deployed databases in corporate IT.

License: Proprietary (proprietary) · Kind: web · Deploy: native · SSO: none

Website

MongoDB

MongoDB is the most widely adopted document database, storing data as flexible BSON (Binary JSON) documents rather than fixed-schema rows and columns.

License: SSPL-1.0 (source-available) · Kind: web · Deploy: native, docker, k8s · SSO: none

Website

MySQL

MySQL is the world’s most popular open-source relational database, powering a vast number of web applications, SaaS platforms, and enterprise systems.

License: GPL-2.0-only (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Neo4j

Neo4j is the most widely adopted graph database, purpose-built for storing and querying highly connected data.

License: GPL-3.0-only (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

Oracle Database

Oracle Database is the world’s most widely deployed enterprise relational database and the market leader in the RDBMS space.

License: Proprietary (proprietary) · Kind: web · Deploy: native · SSO: none

Website

PgBouncer

PgBouncer is a lightweight connection pooler for PostgreSQL that sits between application clients and the PostgreSQL server, multiplexing many client connections onto a smaller number of server connections.

License: ISC (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

PostgreSQL

PostgreSQL is the world’s most advanced open-source relational database system, with over 35 years of active development.

License: PostgreSQL (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

ProxySQL

ProxySQL is a high-performance, protocol-aware proxy for MySQL and MariaDB that provides connection pooling, query routing, read/write splitting, query caching, and a query firewall.

License: GPL-3.0-only (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

QuestDB

QuestDB is a high-performance columnar time-series database designed for maximum ingestion throughput and fast analytical queries.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

Redis

Redis is the most widely used in-memory data structure store, serving as a database, cache, message broker, and streaming engine.

License: LicenseRef-Redis-RSALv2 (source-available) · Kind: web · Deploy: native, docker · SSO: none

Website

ScyllaDB

ScyllaDB is a high-performance, distributed wide-column database written in C++20 as a drop-in replacement for Apache Cassandra.

License: AGPL-3.0-only (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

SQLite

SQLite is the most widely deployed database in the world, embedded in virtually every smartphone, web browser, operating system, and countless applications. Created by D.

License: blessing (source-available) · Kind: web · Deploy: package · SSO: none

Website

TDengine

TDengine is a purpose-built time-series database designed for IoT and Industrial IoT (IIoT) data at scale.

License: AGPL-3.0-only (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

TiDB

TiDB is an open-source, MySQL-compatible distributed SQL database from PingCAP, built for hybrid transactional and analytical processing (HTAP) with horizontal scaling via TiKV and TiFlash.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

TimescaleDB

TimescaleDB is a PostgreSQL extension that adds time-series capabilities to the world’s most advanced open-source relational database.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Valkey

Valkey is a high-performance, BSD-3-licensed key-value data store created as a Linux Foundation fork of Redis 7.2 in March 2024, in response to Redis’s license change from BSD-3 to RSALv2/SSPLv1.

License: BSD-3-Clause (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

Vitess

Vitess is a database clustering system for horizontal scaling of MySQL, originally developed at YouTube to handle the growth of YouTube’s MySQL infrastructure.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker, k8s · SSO: none

Website · Source

YugabyteDB

YugabyteDB is a high-performance distributed SQL database designed for cloud-native applications requiring PostgreSQL compatibility with horizontal scalability.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

ResorsIT Tools Catalog Search