CockroachDB Alternatives for Self-Hosted

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.

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.

Redis is a free and open-source, in in-memory data structure store that can be used as a database, cache or message broker. The project is community developed and released under the BSD license. Redis supports common data structures including strings, hashes, lists, sets, sorted sets with range queries, bitmaps, hyperloglogs, geospatial indexes with radius queries and streams.

Apache Cassandra is a free and open-source, distributed, wide column store, NoSQL database management system. Apache Cassandra is designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. The database has become the choice of many organizations that need scalability and high availability without compromising performance. Apache Cassandra also provides support for replicating across multiple datacenters, providing lower latency for end users of Cassandra-powered applications.

OrientDB is an open-source NoSQL database management system written in Java. The multi-model database supports graph, document, key/value, and object models, where relationships are managed as in graph databases with direct connections between records. The database is extremly efficient and can store over 220,000 records per second on common hardware, and traverse thousands of records in milisecons. OrientDB scales well on multiple machines, thanks to the multi-master replication where there is no single bottleneck on writes like with master-slave replication.

With Apache HBase manager realtime read/write access to your Big Data. Apache HBase is an open-source, distributed, versioned, non-relational database modeled after Google's Bigtable: A Distributed Storage System for Structured Data. Just as Bigtable leverages the distributed data storage provided by the Google File System, Apache HBase provides Bigtable-like capabilities on top of Hadoop and HDFS.

VoltDB is a blazingly fast NewSQL database management system that is specifically designed to run on modern scale-out architectures - fast, inexpensive servers connected via high-speed data networks. VoltDB is a popular choice for companies with high data throughput requirements, like in the telecommunications industry. 5G has changed the game for telcos, and new rules call for a new way of managing data. VoltDB is built for today’s massive data volume and complexity, allowing businesses to survive and thrive in the age of 5G, IoT, and whatever comes next.

KeyDB is fast, free, and open-source NoSQL database with full compatibility for Redis APIs, clients, and modules. The database was originally forked from the Redis code-base and has been improved to handle multithreading, memory efficiency, and higher throughput. KeyDB is now a fully multithreaded and allow many machine cores to operate a single node resulting in 5X the throughput of Redis (v5) and up to 3x the throughput of Redis (v6). KeyDB also includes Redis Enterprise such as Active Replication, FLASH storage support, and other features like direct backup to AWS S3.

PouchDB is a free and open-source JavaScript database inspired by Apache CouchDB. The database is designed from the ground-up to run well within modern web browsers. With PouchDB you can create web applications that works as well offline as they do online. PouchDB achives this by storing data locally, then synchronize it with CouchDB and compatible servers when the user get internet access once again. This is especially useful for applications facing countries and regions with lower quality internet connections or unstable infrastructure.

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.