With regards to the consistency/isolation model, SurrealDB sits on top of a number of key-value stores. By using the distributed highly-available TiKV storage backend, https://tikv.org, (and we have a FoundationDB integration in the works), the database is designed to be highly-scalable and highly-available. The same guarantees (albeit just single-node, so no high-availability or scalability) will be available with the RocksDB implementation coming this week. By sitting on top of these key-value stores, SurrealDB ensures that all transactions are ACID compliant. We don't want to go for speed (for instance by writing to /dev/null) over anything, but want SurrealDB to be a reliable and performant backend for any application. Obviously we have a way to go to catch up with PostgreSQL (launched in 1996), but we will strive to get there!
Re:SurrealDB – Document-graph database, for the realtime web
by tobiemh on Monday August 22, 2022 @11:08AM
(#32552543)
Hi Diggsey, great question. We are currently focussed on functionality and stability, and then will draw our attention to performance. Coming this week we have a RocksDB storage implementation. We've only just launched our initial beta version, and we know there is a lot of improvement and work to be done (some of these performance issues we know about already and are on our Github issues list).
Re:SurrealDB – Document-graph database, for the realtime web
by petepete on Monday August 22, 2022 @10:46AM
(#32552212)
For a start, it's blazingly fast!
Re:SurrealDB – Document-graph database, for the realtime web
by phailhaus on Monday August 22, 2022 @10:57AM
(#32552378)
So is dumping to /dev/null. A trustworthy database needs a lot more than being fast, unfortunately.
Re:SurrealDB – Document-graph database, for the realtime web
by tobiemh on Monday August 22, 2022 @11:11AM
(#32552571)
Hi phailhaus, good point. We don't want to go for speed (for instance by writing to /dev/null) at any cost, but want SurrealDB to be a reliable and performant backend for any application in the long run. Obviously in our opinion, writing to /dev/null wouldn't make SurrealDB a proper database :) . We have a way to go to catch up with databases like PostgreSQL and other databases in terms of stability and performance, but we will strive to get there!
Re:SurrealDB – Document-graph database, for the realtime web
by edgyquant on Monday August 22, 2022 @03:12PM
(#32555823)
Yep especially considering the motto is always databases are slow. Of course they shouldn’t be unusable but the database isn’t meant to be your clients data model
Re:SurrealDB – Document-graph database, for the realtime web
by Zealotux on Monday August 22, 2022 @11:47AM
(#32553138)
But is it web scale?
Some things I'd like to know more about:
- Testing strategy - Point-in-time restore? - Consistency/isolation model - Performance data - Migrations