SQLite vocabulary: Freelancer level

3 SQLite terms at the Freelancer level, each with a short definition and a link to its full page.

Updated

Study these as flash cards

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.

Every SQLite term, by level