TurboSQL is open source database newSQL that provide the same scalable performance of NoSQL systems for online transaction processing (OLTP) read-write workloads while still maintaining the ACID guarantees of a traditional database system.
It is based on distributed memory-centric architecture that combines the performance and scale of in-memory computing together with the disk durability and strong consistency in one system.
It provides native persistence that it can activated or deactivated:
If this is activated, it functions as a memory-centric system-of-record, where most of the processing happens in memory on cached data, but the superset of data and indexes gets persisted to disk.
If this is deactivated, it functions as a memory-only store, in which case it can be treated as a Distributed Cache, In-Memory Database (IMDB) or In-Memory Data Grid (IMDG).
It is a distributed SQL database, ANSI-99 compliant, horizontally scalable and fault-tolerant using standard JDBC or ODBC connectivity. It provides native SQL APIs for Java, .NET and C++ developers for better performance.
It provides extensive and rich key-value APIs and can act as an in-memory data grid.
It is a strongly consistent platform that fully supports distributed ACID transactions for key-value as well as SQL operations. The consistency guarantees are met for both memory and disk tiers.
The transactions can span multiple cluster nodes, caches and partitions. Both pessimistic and optimistic locking are available for applications. The optimistic mode also supports deadlock-free transactions that help avoid distributed deadlocks in user code.
The collocated processing allow to to execute advanced logic or distributed SQL with JOINs exactly where the data is stored increasing the scalability.