Comment by polyrand
5 years ago
I think SQLite is underrated.
With WAL mode + increasing the page cache you can get some excellent concurrency, even if doing reads and writes at the same time.
With rqlite it's easy to make it a server database and have a cluster of SQLite databases (https://github.com/rqlite/rqlite).
I wouldn't try to create the new Instagram with it, but I think it'd be capable enough for many apps that are built on top of more complex DBs.
You are right! In our Delphi/Pascal community we have https://github.com/synopse/mORMot, which is a full client/server DB, remote ORM and RPC system based on top of SQLite.