News for hackers. Stuff that matters.
Re:SurrealDB – Document-graph database, for the realtime web by Diggsey on Monday August 22, 2022 @10:04AM (#32551508)
The features are very impressive, but why should I trust SurrealDB with my data over say, PostgreSQL?

Some things I'd like to know more about:

- Testing strategy - Point-in-time restore? - Consistency/isolation model - Performance data - Migrations

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).

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 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?
Re:SurrealDB – Document-graph database, for the realtime web by tobiemh on Monday August 22, 2022 @12:25PM (#32553675)
Lol. Unfortunately only /dev/null is truly web scale :) !
Re:SurrealDB – Document-graph database, for the realtime web by petepete on Monday August 22, 2022 @03:08PM (#32555785)
Don't make me start using sarcasm tags. Sigh.