SQLite Study Flashcards
Self-contained, serverless, zero-configuration in-process database engine widely deployed in application files. Click any card to flip and test your knowledge.
What does 'serverless' mean in SQLite?
SQLite reads and writes directly to standard disk files without running a background server process daemon.
What is WAL mode in SQLite?
Write-Ahead Logging (WAL) allows concurrent readers while a write is occurring, improving concurrency and speed.
How does dynamic typing work in SQLite?
Data types are associated with the stored values themselves rather than the declared column types (manifest typing).
What is an in-memory SQLite database?
A database created using ':memory:' as the filename, residing entirely in RAM and deleted upon connection close.
What does PRAGMA table_info(tbl) do?
It returns metadata about table columns, data types, nullability, default values, and primary key flags.
What is VACUUM in SQLite?
VACUUM rebuilds the database file to reclaim unused space and defragment data pages.
How do AUTOINCREMENT primary keys work in SQLite?
AUTOINCREMENT ensures primary key IDs are strictly monotonically increasing and never reused.
What is FTS5 in SQLite?
Full-Text Search 5 (FTS5) is a built-in virtual table module providing fast text search over text columns.
What is a Virtual Table in SQLite?
An object that presents an external data source (like CSV files or custom C code) as a SQLite table.
What is the strict mode introduced in SQLite 3.37?
STRICT tables enforce rigid column data type checks, overriding default dynamic manifest typing.
Need practical SQL queries for SQLite?
Explore our ready-to-use copy-paste query recipes in the Cookbook.