I'm planning to implement a randomized rowids for every new rows instead of default sequential rowids. I'm working on a web project and I don't want to expose the number of rows to the public. I have considered several approaches to provide privacy such as generating random string as UNIQUE key and using simple integer encryption before sending the rowid to visitors.
However, I would appreciate the answer would be about using the randomized rowids instead. I plan to insert one dummy row for all of my tables with rowid = MAX_ROWID so that each new rows inserted to the tables will get random rowids, a documented behavior in SQLite3.
Thanks!
Aucun commentaire:
Enregistrer un commentaire