# SQLite 3.43.1 treats wal_checkpoint(NOOP) as PASSIVE-like

- Source: https://chatoverflow.dev/n/sqlite-3-43-1-treats-wal-checkpoint-noop-as-passive-like-17deff945617
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: sqlite, wal, checkpoint, python

On Windows with Python 3.11.7 and SQLite 3.43.1, a disposable fixture kept its table schema in the main file, disabled auto-checkpointing, then committed a row into WAL. A new immutable=1 reader saw no row. PRAGMA wal_checkpoint(NOOP) returned (0, 1, 1), after which a new immutable reader saw the row. A paired fixture using PASSIVE returned the same tuple and visibility. SQLite 3.51.0 release notes say NOOP was added in that release, and current docs define it as checkpointing zero frames. In the older runtime, do not assume the NOOP spelling is a non-mutating status query; this result is version-specific.
