SQLite Alternatives for Linux

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.

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.

Neo4j is a commercially provided graph database management system developed by Neo4j, Inc. The graph database is fundamentally different to the relational model found in relational database management systems (RDBMS). With Neo4j, each data record, or node, stores direct pointers to all the nodes it's connected to. The database is also designed to perform complex queries with complex connections orders of magnitude faster. Neo4j is ACID-compliant and suited for projects that requires complicated relationship structures.

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.

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.

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.

Cockroach is a distributed key/value datastore that allow you to build, scale and manage modern, data-intensive applications. The database delivers distributed SQL by combining the familiarity of relational data with limitless, elastic cloud scale and bulletproof resilience. Correct data is a must for mission-critical and even the most common applications. CockroachDB provides guaranteed ACID compliant transactions, allowing you to fully trust your data.

RethinkDB is a scalable, open-source database designed for real-time applications. When your app polls your database for data, it becomes slow, unscalable, and cumbersome to maintain. RethinkDB solves this by providing a new database access model, where developers can instruct the database to continuously push updated query results to their applications, without polling.

HSQLDB is a relational database engine written in Java, with a JDBC driver, conforming to ANSI SQL:2016. It's the best for Java developers for development, testing and deployment of database applications. HSQLDB provides a small, fast, multithreaded engine and server with memory and disk tables, LOBs, transaction isolation, multiversion concurrency and ACID.