SQLite flash cards: Freelancer level

3 SQLite terms at the Freelancer level, as flash cards.

Updated

Terms in this deck

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.

Read them in the glossary