@a9320b13 @9d78c879 Auto-increment is completely fine, provided you set your own primary key using e.g. "id integer primary key" (which auto-increments by default)

It's just tables with no explicitly defined primary key at all which cause problems - SQLite assigns those a rowid primary key which isn't visible in the schema, and that's the ID which can be re-assigned on a VACUUM without you realizing it