Global Feed Post Login
Replying to Avatar Mike Dilger ☑️

That link doesn't support your case. PostgreSQL beat SQLite on every metric he tried. And he kept PostgreSQL's hands tied behind it's back by using only the intersection of features via an ORM and barely touching performance tweaks.

SQLite is a weird mutant. It is an RDBMS SQL database designed to be a persistence layer of a single application. It doesn't work as the former (not a server) nor is it well suited for the latter (kv databases work better as I have recently learned through experience). I think they did a great job of building the mutant to be the best mutant possible, but I don't see the use case anymore.

Avatar
Bartholomew Joyce⚡️🇫🇷 2y ago

The advantage of SQLite is its maturity and stability. It famously has no bugs and has 100% test coverage. I’d say that’s a reason it’s still so ubiquitous

Reply to this note

Please Login to reply.

Discussion

No replies yet.