places.sqlite is imcomplete
Hello, I used my firefox account to restore my browsing history after I switched to a new hard drive. I compared the contents of places.sqlite from before and after the … (read more)
Hello,
I used my firefox account to restore my browsing history after I switched to a new hard drive. I compared the contents of places.sqlite from before and after the switch. (I can do this because I made a backup of the old places.sqlite.) And I noticed that many entries of moz_historyvisits are missing in the new database. I made a graph about this, in which I am using pythons sqlite3 library to inspect the databases moz_historyvisits.visit_date column. For every visit_date I checked if it is still present in the new database or if it got lost. The pattern seems highly irregular.
Does firefox intend to maintain a complete history? By which criteria did individual history entries get lost? Is there a way to restore a complete version of my browser history from my account?
Any help is appreciated.