What's the isolation level? They only mention write-write conflicts.

The reason SQLite's BEGIN CONCURRENT does not greatly increase concurrency (unless you're very careful with your schema and queries) is as much due to page level conflict detection as it is because it enforces serializable isolation.

This is a huge differentiator. I built our internal meme platform with Turso. Really fun and easy to use.

isn't this just pushing the complexity around? Either my write thread manages the lock, or turso's does.