5 ms·
Ash HN: Is there a concurrent database that fits between SQLite and PostgreSQL?
If you want a concurrent RDMS (Relational Database Management System) that is relatively light and easy to deploy, are there any contenders that meet this criteria?
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?
- InitEnabler 5y agoI think CockroachDB might fit the bill. Take a look at that. IMHO postgresql is pretty easy to set up.
- aksss 5y agoMySQL? 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.
- TeaFilledCup 5y agoBetween 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/ https://firebirdsql.org/
- question11 5y agoI would argue that postgresql is pretty light if you just want to use it as a crud backend.