Regarding: ...then went horribly wrong at some point after rowids consumed all of 32 bits...
If your application treated ROWIDs as 32-bit integers, that may possibly have been the cause of your problem, since ROWID's are 64-bit integers. The maximum ROWID is 9223372036854775807 http://www.sqlite.org/autoinc.html and would seem hard to exhaust with your application in our lifetimes. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
