HTML Over the Wire
SQLite under a hypermedia app
Lesson 4 of 5
The WAL + busy_timeout + foreign_keys DSN keeps SQLite's single writer from surfacing as "database is locked", and list/row query patterns pair one query with one partial.
What you'll learn
- Configure the SQLite DSN: journal_mode(WAL), busy_timeout, foreign_keys — and know why
- Understand SQLite's single-writer rule and where "database is locked" comes from
- Pair queries with partials: a list query behind the page, a row query behind the fragment
Members only
A free account unlocks this lesson and every other one.
Runnable challenges, knowledge checks, and progress that syncs across your devices. No card needed.
Not sure yet? Try the free lesson first: Hypermedia, not JSON