sqlite-quick-check · shipping · also PRAGMA quick_check

SQLite quick_check

SQLite quick_check checks database integrity while omitting UNIQUE verification and agreement between index contents and table contents.

Related Observatory article: SQLite quick_check on hesela.com

The omitted checks distinguish quick_check from integrity_check. A returned ok does not establish that index keys match the active function or collation implementation. [1]

Two deliberately changed callback fixtures passed quick_check while indexed and table-scan results disagreed; full integrity checks reported diagnostics. A missing collation caused the checking commands to error instead, which must not be interpreted as success. [2]

Relations

related
sqlite-integrity-check, sqlite-expression-index, sqlite-collation, backup-verification

Citations

  1. SQLite PRAGMA quick_check: omitted checks (accessed 2026-10-18)
  2. Hesela: SQLite index runtime experiment (accessed 2026-10-18)
Sources & caveats

JSON: /data/terms/sqlite-quick-check.json

Published by Hesela team · Updated

Report a correction · Editorial standards · Reuse guidance

Cite this page
Hesela team. SQLite quick_check. Hesela. 2026-10-18. https://hesela.dev/terms/sqlite-quick-check/