Need advice about which tool to choose?Ask the StackShare community!
FoundationDB vs ToroDB: What are the differences?
What is FoundationDB? Multi-model database with particularly strong fault tolerance, performance, and operational ease. FoundationDB is a NoSQL database with a shared nothing architecture. Designed around a "core" ordered key-value database, additional features and data models are supplied in layers. The key-value database, as well as all layers, supports full, cross-key and cross-server ACID transactions.
What is ToroDB? Open source, document-oriented, JSON database that runs on top of PostgreSQL. ToroDB is an open source, document-oriented, JSON database that runs on top of PostgreSQL, providing storage and I/O savings and ACID semantics. ToroDB is MongoDB-compatible, so you can use Mongo clients to connect to it.
FoundationDB and ToroDB can be primarily classified as "Databases" tools.
Some of the features offered by FoundationDB are:
- Multiple data models
- Full, multi-key ACID transactions
- No locking
On the other hand, ToroDB provides the following key features:
- Document-oriented (JSON)
- Store data reliabily and durably with PostgreSQL
- Use MongoDB clients to connect to it
ToroDB is an open source tool with 10 GitHub stars and 2 GitHub forks. Here's a link to ToroDB's open source repository on GitHub.
So, we started using foundationDB for an OLAP system although the inbuilt tools for some core things like aggregation and filtering were negligible, with the high through put of the DB, we were able to handle it on the application. The system has been running pretty well for the past 6 months, although the data load isn’t very high yet, the performance is fairly promising
Pros of FoundationDB
- ACID transactions6
- Linear scalability5
- Multi-model database3
- Key-Value Store3
- Great Foundation3
- SQL Layer1
