ActorDB

ActorDB is a distributed SQL Database designed around having to do the least possible inter-server synchronization. ActorDB has two distinct engines: SQLite for running SQL queries which uses pages to store data and LMDB for storage in an append-only style where checkpoints are replaced with cleanups that only free up space for later use. ActorDB has features such as a full relational database within an actor, queries and transactions over multiple actors, no single point of failure, ACID database and is connectable over MySQL protocol and Thrift. Every ActorDB node can easily handle thousands of client connections. ActorDB is ideal as a server side database for applications. ActorDB inherits SQLite features like JSON support and common table expressions. ActorDB can run on a single server or hundreds and can store gigabytes or petabytes. ActorDB will balance actors across all servers configured with multiple independent hard drives which will significantly improve throughput as long as CPU and network are not saturated. ActorDB can also act as a key/value store by maintaining a sharded table across all clusters with a verbose syntax that is quite powerful and ActorDB KV uses structured values. ActorDB is a database which explicitly does sharding in fully relational chunks for the 99% of database queries. KV actors are shards where mean ActorDB will hash kvkey to determine which shard it falls into. Then send the query to that shard. That shard may hold many other keys in the same actor database. ActorDB is an Open Source project licensed under Mozilla Public License 2.0.