News for hackers. Stuff that matters.
Re:Show HN: Versioning Filesystem for SQLite by devnull3 on Sunday August 28, 2022 @12:18PM (#32629548)
(I am the author) Some of the use-cases of mojo I could think of:

1. Rollbacking DDL changes (like create table, adding columns, etc)

2. (My use-case) Multiple readers-single writer. Readers read old versions. Writers do not block readers and vice-versa. Note: this is different than reading+writing in the same version can still happen but with database-level locking.

3. Extension of #2: The older versions read from S3 so that lamda can read.

4. Extension of #3: Readers reading from old immutable snapshots makes the database as a queue of complex changes with indexes and all the benefits of SQL.

5. Backups and replication.

Oh: I have change the license to MIT

Re:Show HN: Versioning Filesystem for SQLite by quietbritishjim on Sunday August 28, 2022 @08:07PM (#32633452)
For no. 2, WAL mode has this property, why not just use that? Is it for finer control over which version the readers see?
Re:Show HN: Versioning Filesystem for SQLite by devnull3 on Monday August 29, 2022 @12:02AM (#32634691)
There is a requirement where I need data which existed at timestamp T or version V. So even a WAL needs to be versioned.