SQLite Journal Modes [video]

SQLite Journal Modes [video](youtube.com)

69 points by ducaale 2 years ago | 3 comments

AlexErrant 2 years ago |

Is 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

throw0101a 2 years ago |

Is 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

matharmin 2 years ago | |

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.