SQLite – The everywhere database
summary
Claims that SQLite is literally everywhere — on every Mac iPhone iPad Apple Watch Apple TV Android many set top boxes cars an Airbus A350 and even aboard the ISS — get backed by specifics: an embedded single‑file format, one-file portable database, ACID transactions, the JSON extension and full text search (fts5), a session/replication API, ability to attach multiple databases, an amalgamation C build, public‑domain license, heavy testing (hundreds of millions of tests) and a three‑person maintainer team.
AI-written summary · about
chapters (17)
- 0:00Intro
- 1:05About Nathan
- 4:03Is SQLite everywhere
- 5:32What is it
- 11:34Useful features
- 12:56Flexible typing
- 16:24Extensions
- 18:54Other features
- 22:12How it works
- 25:54What can it do for me
- 28:40JSON
- 30:07JSON Extract
- 34:17Create a table
- 35:10SQLite CLI
- 36:03Full Text Search
- 41:10Trips
- 46:17Swift library
