Ash HN: Is there a concurrent database that fits between SQLite and PostgreSQL?
4 comments
MySQL? I mean, it doesn't have some of the cool features of postgres, but those cool features are perhaps what people indirectly complain about when they gripe about its complexity and footprint. MySQL performs well, is popular (in the sense of broad community support), and relatively painless to stand up. I would consider it somewhere between SQLite and Postgres, though further towards the latter.
Between SQLite and PostgreSQL is exactly how I would describe Firebird[1]. However, there is a 'but' - documentation and ecosystem is lacking.
[1] https://firebirdsql.org/
I would argue that postgresql is pretty light if you just want to use it as a crud backend.
I think CockroachDB might fit the bill. Take a look at that. IMHO postgresql is pretty easy to set up.
Between the simplicity of SQLite and the complex, heavyweight that is PostgreSQL, it seems there is a chasm between these database opposites.
Is there a concurrent client/server database that fits in this gap while being simple, performant and easy to deploy?