Using WAL mode in SQLite and its interaction with VACUUM

Syndicated from the fediverse. Read and engage on the original instance.

View original on programming.dev

sqlite·SQLitebyLuis Norambuena

Using WAL mode in SQLite and its interaction with VACUUM

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

https://blog.pecar.me/sqlite-walOpen link View original on programming.dev

Comments2

2 replies

perviouslyiner

lemm.ee

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

Luis Norambuena reply

programming.dev

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.