SQLite Alternatives for Self-Hosted

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.

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.

RedisGraph is the first free and open source queryable Property Graph database to use sparse matrices to represent the adjacency matrix in graphs and linear algebra to query the graph.

TerminusDB is an open-source full-featured in-memory graph database management system that stores data like git.

LevelDB is a free and open-source key-value storage library developed by Google. LevelDB provides on-disk storage and ordered mapping of string keys to string values. With LevelDB data is stored and sorted by key, and the keys and values are arbitrary byte arrays. The library will also automatically compress files using the Snappy compression library to optimize for storage capacity.

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.

GraphDB is a simple graph API for SQL Server. The GraphDB database resides inside of your SQL server and together with .Net 4.5 assemblies partitioned into a client and an admin API. The Client API allow users to connect to a GraphDB store and store graphs of entities in workspaces. The API has a rich set of data-, security- and graph-related methods to easily manage entities, collaboration and networks. While the Admin APU allows you store and manage data, and manage security related tasks and user accounts.

TaffyDB is a free and open source, Pure-JavaScript database abstraction that stores data in JSON format. TaffyDB provides INSERT, DELETE, GET (SELECT)  and JOIN methods to execure the data similar to that of traditional relational SQL databases. TaffyDB allows you to quickly setup an in-memory database that can be used in the same fashion as an SQLite database would, without configuration and a database server running.

CrateDB is the leading, distributed SQL database for relational and time‑series data. CrateDB provides a distributed SQL DBMS built atop NoSQL storage & indexing delivers the best of SQL & NoSQL in one DB. It's designed for simple scalability with a masterless architecture with auto-sharding & replication. It also provides solutions for dynamic schema where the schema evolves automatically as new columns are inserted, while handling any tabular or non-tabular data to support a wide range of use cases. CrateDB is the perfect choice for your machine data.

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.

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.

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.