Method checkpointWalPassive

src/db/index.ts:522–524

* `PRAGMA wal_checkpoint(PASSIVE)` on a worker thread with its own * connection. PASSIVE never blocks the writer, and running it off-thread * means the main thread — and the #850 watchdog heartbeat — keep turning * even when the backfill is minutes of I/O on slow storage (a synchronous *

()

   * never run inline on the main thread).
   */
  async checkpointWalPassive(): Promise<{ busy: number; log: number; checkpointed: number } | null> {
    return this.checkpointWal('PASSIVE');
  }

  /**
   * `PRAGMA wal_checkpoint(TRUNCATE)` — same off-thread pattern as PASSIVE,