Using WAL mode in SQLite and its interaction with VACUUM

https://blog.pecar.me/sqlite-wal

via https://fosstodon.org/@anze3db/111347782255927112

7 points · 2 comments · view on lemmy.world

2 Comments

perviouslyiner@lemm.ee · 1 pts · 2y (1 reply)

Is it necessary for programs to implement their own retry logic for when sqlite returns busy intead of success or failed code?

norambna@programming.dev · 1 pts · 2y

The error you would get is a timeout. The easiest way to wait longer is increasing the timeout of your connection. I think the default value for a timeout is 5 seconds.