“The rollback journal is a simple trick to simulate atomicity and isolation and to provide durability to a database.”
Change one byte and SQLite writes a full 4KB page. Copy the old page to a journal, write the new one, delete the journal. That is the whole commit. Fly.io is betting its database product on a file format from 2004.