Oddbean new post about | logout
 ... and a tiny sqlite-utils bugfix release. This one's pretty obscure: running table.transform() to modify a table could reset that table's rowid values, which could then cause existing SQLite FTS tables to fail to match on rowid causing searches to fail

https://github.com/simonw/sqlite-utils/releases/tag/3.35.1 
 @4ebb1885 Oh man, I had a client complain two weeks ago that VACUUM mixed up their rowids. Sorry buddy, use your own identifiers. 
 @Simon Willison vacuum will reorder rowid unless you give it another name.