Is there any "sqlite killer"?
I mean a reliable data store, sql or not, which can be _painlessly_ integrated into an application?
@kornel SQLite isn't super painless but its close as it gets right now IMO. Details of the filesystem make it very difficult to do datastore's reliably.
@peregrine I mean it's already wonderful compared to a real RDBMS that needs separate daemons, configs, ports, credentials, and can't be rsync-ed around.
@peregrine I should probably just use Postgres, but I can't be bothered to deal with PGDATA ever again.
@kornel I've tried out DBM recently and was surprised how far you can get with it. It has many successors, like LMDB.
@kornel not even close, I don't think, but I'm very keen to learn about any project that gets anywhere near sqlite's level of quality
@reto My application is heavily multi-threaded, and all the threads spend 99% of time waiting for sqlite. Sqlite is extremely annoying with concurrent writes.
@kornel if "reliable" is one of your criteria.... why would you want to replace it? reliability can only come when something has been broken and fixed over and over, and it's a lot easier to get that with something popular
Server run by the main developers of the project It is not focused on any particular niche interest - everyone is welcome as long as you follow our code of conduct!