mercredi 16 janvier 2019

What are the downsides of using random ROWIDs in SQLite?

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