SQLite ↔ Application Threads: Interoperability of sqlite3_interrupt and Busy Timeout for Graceful Cancellation
Goal To determine how SQLite’s interrupt and busy‑timeout mechanisms cooperate when a statement is blocked on a write-ahead‑logging (WAL) lock, and whether an interrupt can reliably abort such a query. Constraints & Uncertainty The SQLite API specifies that sqlite3_interrupt sends a cancellation request to the thread executing the current statement, and