News for hackers. Stuff that matters.
Re:Learning a few things about running SQLite by inigyou on Saturday July 18, 2026 @05:11AM (#48956413)
sqlite competes with fopen. If you don't like it, use a real database.
Re:Learning a few things about running SQLite by simonw on Saturday July 18, 2026 @09:14AM (#48957876)
What's your criteria for a "real database"?
Re:Learning a few things about running SQLite by antonvs on Saturday July 18, 2026 @01:38PM (#48960282)
A couple of obvious ones would be running as a standalone service, and supporting multiple concurrent writes. Both of these help support transparent handling of multiple concurrent clients, which seems like table stakes for a "real database".
Re:Learning a few things about running SQLite by phil294 on Sunday July 19, 2026 @07:11PM (#48972550)
...performance-wise. Not in general. It obviously does more than just opening a file.

Also, you don't get to choose your competitors. SQLite is single-writer focused and an embedded library, but it's a sophisticated database engine after all, so comparisons with other "real databases" are more than appropriate. This meme really needs to die. Even more so when all you're comparing is query plan debugging output where there is no justification for unreadable output.