3 ms·

> Arguably, this makes PostgreSQL the only mainsteam database system that is truly open-source. It can't be bought or license-rug-pulled and this creates a kind

by sgbeal 2y ago

> Arguably, this makes PostgreSQL the only mainsteam database system that is truly open-source. It can't be bought or license-rug-pulled and this creates a kind of trust that can't be emulated in any other way. SQLite, with far more installations than Postgres, isn't a "mainstream database"?

rswail 2y ago
>> ... mainstream database system ... > SQLite, with far more installations than Postgres, isn't a "mainstream database"? It's not a system, it's a monolith library, which is why it is used wherever you want a local database with local storage. Postgres implementations are a client/server systems even if the connection is on localhost. It's also MVCC and has RLS and other requirements that do not necessarily apply to a local database like SQLite. It's not about the number of installations, it's the type of database.