Re:Ask HN: Have you used SQLite as a primary database?
by mekster on Monday April 25, 2022 @03:45PM
(#31159632)
Running against a unix socket doesn't seem to make that a selling point for SQLite.
Re:Ask HN: Have you used SQLite as a primary database?
by simonw on Monday April 25, 2022 @04:39PM
(#31160291)
There's still serialization and deserialization overhead there. I would expect SQLite to win in benchmarks against MySQL or PostgreSQL on a Unix socket for basic "select * from table where id = 5" calls, but I've not done the work to prove it myself.
So no matter how optimized MySQL and PostgreSQL are, SQLite will run rings around them for basic SELECT queries.