rc48

3 ms·

1. 1.▲
   by rc48 6y ago

   +1. I was not aware of the 'stickiness' of the wal pragma. Thank you for the tip. I will be defaulting to this going forward. For a quick confirmation, I used: $ f=$(mktemp) $ sqlite3 $f "pragma journal_mode" del
2. 2.▲
   by rc48 6y ago

   My sentiments exactly!
3. 3.▲
   by rc48 6y ago

   Same as @mikeyjk! Can you point toward more information on this topic? The applications I'm dealing with in my day job are constantly plagued by deadlocks in the database surrounding bulk transactions. I've theorized that a "