# SQLite flash cards: Freelancer level

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

Updated: November 19, 2026

- [Study these as flash cards](https://www.ask-codey.com/decks/sqlite/4/flash)
- [Play Memory with them](https://www.ask-codey.com/games/memory?category=sqlite&level=4)

## Terms in this deck

- [Concurrency Limits in SQLite](https://www.ask-codey.com/glossary/concurrency-limits-in-sqlite): Only one writer at a time.
- [EXPLAIN QUERY PLAN](https://www.ask-codey.com/glossary/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](https://www.ask-codey.com/glossary/fts5): SQLite's full-text search extension.

[Read them in the glossary](https://www.ask-codey.com/glossary/subjects/sqlite/freelancer)

Source: https://www.ask-codey.com/decks/sqlite/freelancer
