SQLite or PostgreSQL? It's Complicated

Re:SQLite or PostgreSQL? It's Complicated by fmajid on Tuesday June 28, 2022 @04:30PM (#31912638)

That’s silly, SQLite is the single most widely deployed database engine in the world, possibly the most deployed software, period. It’s unit test suite is second to none. It’s reliable enough that SMF, Solaris’ boot and service management (sort of like systemd) depends on it.

That does not mean it is applicable to all databases use-cases, but production-grade it undoubtedly is.

[ Parent | on HN ]

Re:SQLite or PostgreSQL? It's Complicated by ThinkBeat on Wednesday June 29, 2022 @03:26AM (#31917411)

How many installations SQLite has is not that relevant in a discussion of SQLite vs full RDMS.

By your example, a bank should use SQLite because it is deployed widely.

You have to look where they are deployed and the use cases. They also come with dramatically different tooling which make sa huge difference. More tooling does not mean that a full RDMS is a better choice:

It is just about what you need, what use case you need to cover and what industry you are in.

[ Parent | on HN ]