SQLite vocabulary
16 SQLite terms, from Novice to Freelancer. Start with the basics or jump to a level.
Updated
Novice
- Database File
- The single file holding the whole database.
- Embedded Database
- A database that runs inside the app, with no server.
- SQLite
- A small SQL database that lives in one file inside your app.
- sqlite3 Shell
- The command-line tool for SQLite.
Apprentice
- Dot Commands
- Shell commands like .tables and .schema.
- In-Memory Database
- A database that exists only in memory.
- PRAGMA
- Statements that read or change SQLite settings.
- ROWID
- The hidden row number every table has.
- Type Affinity
- Columns suggest types but don't enforce them.
Journeyman
- ATTACH DATABASE
- Opens another database file to query across both.
- SQLite in Mobile Apps
- The standard way mobile apps store local data.
- STRICT Tables
- Tables that enforce column types.
- WAL Mode
- A mode letting readers read while a write happens.
Freelancer
- Concurrency Limits in SQLite
- Only one writer at a time.
- EXPLAIN QUERY PLAN
- Words put in front of a SQLite query to show how it will run instead of its rows: SCAN reads the whole table, SEARCH ... USING INDEX jumps to the rows.
- FTS5
- SQLite's full-text search extension.