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.

More subjects in Databases