SQLite Forum

progress handler from user functions
Login
Something I have done is preparing the statement "`WITH X AS (SELECT 0 UNION ALL SELECT 0 FROM X) SELECT 0 FROM X;`" and stepping it when it wants to check for interrupts. However, this seems a messy way to do it.