Came here to share a related fact :)

This solution with WAL and compact resembled the database internals as taught by Martin Kleppmann.

I asked Claude about this observation, and learned that the author (Vicent Martí) wasn't only core Github developer but also worked on Vitess from PlanetScale.

So no surprise these two contexts resulted in the design of Continuity as it is.

https://vitess.io/ - Vitess is a database clustering system for horizontal scaling of MySQL.