5 ms·

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 strat

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

petepete 4y ago
For a start, it's blazingly fast!
- phailhaus 4y ago
  So is dumping to /dev/null. A trustworthy database needs a lot more than being fast, unfortunately.
  - tobiemh 4y ago
    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!
  - Zealotux 4y ago
    But is it web scale?
    - tobiemh 4y ago
      Lol. Unfortunately only /dev/null is truly web scale :) !
  - petepete 4y ago
    Don't make me start using sarcasm tags. Sigh.
  - edgyquant 4y ago
    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
tobiemh 4y ago
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 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!

petepete 4y ago

For a start, it's blazingly fast!

phailhaus 4y ago
So is dumping to /dev/null. A trustworthy database needs a lot more than being fast, unfortunately.
- tobiemh 4y ago
  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!
- Zealotux 4y ago
  But is it web scale?
  - tobiemh 4y ago
    Lol. Unfortunately only /dev/null is truly web scale :) !
- petepete 4y ago
  Don't make me start using sarcasm tags. Sigh.
- edgyquant 4y ago
  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

tobiemh 4y ago

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 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!