Quote:
Originally Posted by kovidgoyal
FYI SQLITE by default (and apsw since it tries to stay as close to sqlite as possible) works in auto-commit mode. So unless you explicitly open a transaction every execute is auto-committed.
|
Yes, I'd forgotten about that. I removed a pile of commits when I changed to apsw as they weren't going to be needed. In this particular place, I could see committing separately might be a good idea, but it also needs a transaction to be opened first.