RDBMS haven't evolved at all for a very long time but only doing minor incremental improvements and consumers have to turn to complex queries as the principle never changes. It's time we get something more modern.
- It has web UI to handle data.
- It can write logic with JS (The more logic in DB the better.)
You can put it in git by writing the defined functions in a file.
You may use DB migration tools to run those.
It's better because logics in DB cannot be bypassed. If you write a logic or check in, say PHP, and part of your app is run in NodeJS, you have to duplicate those checks and logics. It even works when you interact with the database manually with some GUI tools which prevents you from manually inserting bad data.
With that attitude we would stick to assembly forever though. I don't know the exact requirements, but I have a hard time imaging that Javascript is a great choice, except for how many people know it.
Surreal looks good; I checked it a few times. I was wondering if the Rust is compiled to wasm, given surreal supports offline/online data sync, could it be used in the browser and app as an offline solution? Like pouch/couch? As that’s what most solutions are missing for the projects we do.
RDBMS haven't evolved at all for a very long time but only doing minor incremental improvements and consumers have to turn to complex queries as the principle never changes. It's time we get something more modern.
- It has web UI to handle data.
- It can write logic with JS (The more logic in DB the better.)
- Can write a lot like SQL but way more powerful.
- Receive real time updates.
- Incremental backups.
https://surrealdb.com/
(Many examples on the landing page.)
https://github.com/surrealdb/surrealdb
https://news.ycombinator.com/item?id=32550543