# SQLite vocabulary

16 SQLite terms, from Novice to Freelancer. Start with the basics or jump to a level.

Updated: November 19, 2026

## Novice

- [Database File](https://www.ask-codey.com/glossary/database-file): The single file holding the whole database.
- [Embedded Database](https://www.ask-codey.com/glossary/embedded-database): A database that runs inside the app, with no server.
- [SQLite](https://www.ask-codey.com/glossary/sqlite): A small SQL database that lives in one file inside your app.
- [sqlite3 Shell](https://www.ask-codey.com/glossary/sqlite3-shell): The command-line tool for SQLite.

## Apprentice

- [Dot Commands](https://www.ask-codey.com/glossary/dot-commands): Shell commands like .tables and .schema.
- [In-Memory Database](https://www.ask-codey.com/glossary/in-memory-database): A database that exists only in memory.
- [PRAGMA](https://www.ask-codey.com/glossary/pragma): Statements that read or change SQLite settings.
- [ROWID](https://www.ask-codey.com/glossary/rowid): The hidden row number every table has.
- [Type Affinity](https://www.ask-codey.com/glossary/type-affinity): Columns suggest types but don't enforce them.

## Journeyman

- [ATTACH DATABASE](https://www.ask-codey.com/glossary/attach-database): Opens another database file to query across both.
- [SQLite in Mobile Apps](https://www.ask-codey.com/glossary/sqlite-in-mobile-apps): The standard way mobile apps store local data.
- [STRICT Tables](https://www.ask-codey.com/glossary/strict-tables): Tables that enforce column types.
- [WAL Mode](https://www.ask-codey.com/glossary/wal-mode): A mode letting readers read while a write happens.

## Freelancer

- [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.

[More subjects in Databases](https://www.ask-codey.com/glossary/groups/databases)

Source: https://www.ask-codey.com/glossary/subjects/sqlite
