SQLite Journal Modes [video]
youtube.com
SQLite Journal Modes [video]
1–4 of 4 posts
Re: SQLite Journal Modes [video]
#2Is anyone using their product? https://github.com/mycelial/mycelite/
They use CRDTs for syncing, but their site has virtually no details on what data structures are supported. https://mycelial.com/docs/get-started/quick-start
Re: SQLite Journal Modes [video]
#3Is there any reason to use WAL(1) over WAL2?
Re: SQLite Journal Modes [video]
#4Is there any reason to use WAL(1) over WAL2? * https://www.sqlite.org/cgi/src/doc/wal2/doc/wal2.md * https://news.ycombinator.com/item?id=32435601
Main reason is that it's not in the standard release yet. This means it's more effort to get a build that supports it (build it yourself essentially), and it's not tested as well.
Additionally, most current tools will not be able to read database files using WAL2, although this is not an issue for most applications that only use it for internal storage.