SQLite Forum

about "strict" mode
Login
And if you want rowids to survive a vacuum you can just declare them in the table definition.  SQLite already does what you want.  It doesn't need a special non-standard column type.