3 ms·Author here—-that is vastly better, thanks for pointing it out.by 28mm 9y agoAuthor here—-that is vastly better, thanks for pointing it out.dunham 9y agoWhy not just copy the database (and wal) to tmp before accessing it?28mm 9y agoLack of familiarity with SQLite—-and maybe some mistaken assumptions about its behavior :)dunham 9y agoI often copy first because I'm afraid me locking the database is going to interfere the app. Although, for my Apple Notes extraction, I am hitting the database directly.