A gotcha, if you are expecting compatibility with sqlite. You can't set PRAGMA journal_mode=WAL and expect to be able to read database state from another process. Turso will report exclusive lock

▲

sealeck 10 hours ago | parent [-]

I thought the point of Turso was to offer better concurrency than SQLite currently does. A la https://turso.tech/blog/beyond-the-single-writer-limitation-... and https://penberg.org/papers/penberg-edgesys24.pdf

Would be great if one of the Turso developers can clarify :)

▲

bawolff 8 hours ago | parent [-]

Honestly, if you care about that level of concurrency, it begs the question of why are you using an in process database in the first place?

	▲	miohtama 3 hours ago \| parent [-]
		One reason is that architecture and maintenance are much simpler