I use firefox bookmarks to store my biomedical research data which over the last 12 years has grown to a large size with places.sqlite around 60 Mb and bookmarks.html abo… (read more)
I use firefox bookmarks to store my biomedical research data which over the last 12 years has grown to a large size with places.sqlite around 60 Mb and bookmarks.html about 75 Mb.
Sometime ago the bookmarks.html file suddenly almost doubled in size to some 130 Mb (I automatically back up/export my bookmarks as a bookmarks.html file) and places.sqlite to some 70 Mb. Unfortunately I only discovered the issue sometime after it happened.
According to Places Maintenance, which I run relatively frequently, the bookmarks data base comprises:
Table moz_places has 77666 records
Table moz_bookmarks has 230886 records
The bloated bookmarks.html file is needlessly taking up a lot of backup space . I can only assume that somehow one of the very large files was inadvertently copied into some other folder. Given the vast number of folders/subfolders it is a virtually impossible task to open each one to find where such a large file has been put to cause such bloat. Unfortunately when I open the bookmarks.html file there is no folder structure visible so it is not possible to sort folders by size which would greatly help to find the offending folder.
Although I am quite useful at finding my way around browser technology I have no sqlite database skill. I have looked at the places.sqlite using DB Bowser for Sqlite and SqliteManager extension in the hope that I could figure out whether it is possible to identify folders and hopefully sort them by size to find where the misplaced large folder is located. But no luck it is all greek to me.
I would be most grateful if anyone can offer suggestions/guidance on any possible way to identify folders and to sort them by size from places.sqlite or any other way (I have considered exporting the bookmarks from places.sqlite to xlsl into Excel but it does not seem to offer any way to search for/sort folders by size.
I am on Win10 Pro.