HN Hall of Fame Weekly email

SQLite is not a toy database

antonz.org Essays & writing Essays & articles Software engineering Candidate
Screenshot of antonz.org captured 2026-07-20
Page preview · captured 2026-07-20

Resurfaced independently across 3 calendar years, with breakout response in 2 of them.

submissions
4
submitters
4
observed span
2021–2024
peak thread · 354 comments
986 pts
latest 20+ return · 2024-09-10
67 pts

Submission timeline

2007–2026

One slot for every year since HN launched. Height is that year's peak points; orange marks a 100+ point or 50+ comment breakout. Select a bar to open its strongest thread.

First comments on top threads

HN comment order

> There is a popular opinion among developers that SQLite is not suitable for the web, because it doesn’t support concurrent access. No, the issue is it doesn't have high availability features: failover, snapshots, concurrent backups, etc. (Edit: oops, comment pointed out it does have concurrent backups.) SQLite isn't a toy DBMS, it's an extremely capable embedded DBMS. An embedded DBMS is geared towards serving a single purpose-built client, which is great for a desktop application that wants a reliable…

ben509·986-point thread·

I wish there was some sort of an Access-like form/app builder tool for quickly building GUIs around SQLite databases. That's the one thing I miss. I'd love to reach for SQLite instead of Excel or something.

It's not a toy database, but it is a good idea to be familiar with its Quirks, Gotchas, and Caveats: https://www.sqlite.org/quirks.html

The first top-level comment from each of the four biggest threads, in HN’s own order. Excerpts are shortened; open a comment for full context.

Breakout years
2

100+ points or 50+ comments

Total points
1322

reference only — not used in Hall rules or ranking

Total comments
484

reference only — not used in Hall rules or ranking

Every submission

DateTitle as submittedByPointsComments
2021-03-25SQLite is not a toy databaseFirst breakout · Best threadnalgeon986354
2022-08-16SQLite is not a toy database (2021)losfair267114
2024-08-31SQLite is not a toy database (2021)tosh20
2024-09-10SQLite is not a toy databaseLatest 20+ point returnthunderbong6716