SQLite

sqlite3_interrupt does not appear to cancel an integrity check (pragma integrity_check or quick_check) in progress. Given how long these checks can take on big DBs, it's nice to be able to abort them (if your app is asked to exit for example).

I've hacked in my own support for doing this, but would love to see an official version committed for a future release.

The simple fix I put in place was to add:

sqlite3_snprintf(sizeof(zContext), zContext, "Page %d: ", iPage);
/* allow checking to be aborted */
if (pCheck->pBt->db->u1.isInterrupted)
{
 checkAppendMsg(pCheck, zContext, "Check interrupted");
 return -1;
}

In practice this causes several other error messages to get appended to the check results as well, and the actual statement returns SQLITE_ROW. A better solution would be one that causes the execution to return SQLITE_INTERRUPT, but this is good enough for my case.