Comment by mrklol 2 days ago Afaik the fix for that is to have multiple read only connections and one write only connection. 6 comments mrklol Reply Sammi 2 days ago Yes by enabling the write ahead log feature: https://sqlite.org/wal.htmlIt's on by default in many sqlite drivers because it really is the best default. But it isn't on by default in upstream sqlite even though it's been out for ages now. sgt 2 days ago Sure but if you're dealing with WAL logs, why not just go Postgres? Then you also get a port you can connect to from remote machines if you need. wild_egg 2 days ago > "dealing with WAL"What's there to deal with? You turn it on with a pragma and forget about it. 3 replies →
Sammi 2 days ago Yes by enabling the write ahead log feature: https://sqlite.org/wal.htmlIt's on by default in many sqlite drivers because it really is the best default. But it isn't on by default in upstream sqlite even though it's been out for ages now. sgt 2 days ago Sure but if you're dealing with WAL logs, why not just go Postgres? Then you also get a port you can connect to from remote machines if you need. wild_egg 2 days ago > "dealing with WAL"What's there to deal with? You turn it on with a pragma and forget about it. 3 replies →
sgt 2 days ago Sure but if you're dealing with WAL logs, why not just go Postgres? Then you also get a port you can connect to from remote machines if you need. wild_egg 2 days ago > "dealing with WAL"What's there to deal with? You turn it on with a pragma and forget about it. 3 replies →
wild_egg 2 days ago > "dealing with WAL"What's there to deal with? You turn it on with a pragma and forget about it. 3 replies →
Yes by enabling the write ahead log feature: https://sqlite.org/wal.html
It's on by default in many sqlite drivers because it really is the best default. But it isn't on by default in upstream sqlite even though it's been out for ages now.
Sure but if you're dealing with WAL logs, why not just go Postgres? Then you also get a port you can connect to from remote machines if you need.
> "dealing with WAL"
What's there to deal with? You turn it on with a pragma and forget about it.
3 replies →