Comment by skissane

> I don't think SQLite can run on a block device out of the box, it needs locking primitives and a second file for the journal or WAL

It ships with an example VFS which shows you how to do this: https://www.sqlite.org/src/doc/trunk/src/test_onefile.c