Showing questions tagged: Show all questions

Places.sqlite and bookmarks.html suddenly doubled in size

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.

Asked by jtb905-ffsync 1 day ago

Last reply by jtb905-ffsync 1 day ago

Lost browsing history after automatic update of Firefox

Usually, when you close Mozilla Firefox or shut down your computer, you can restore the before closed bookmarks while you start again Mozilla Firefox. In my case, Mozilla… (read more)

Usually, when you close Mozilla Firefox or shut down your computer, you can restore the before closed bookmarks while you start again Mozilla Firefox. In my case, Mozilla Firefox automatically updated itself and I could not open again my bookmarks (the history was gone...). I had lots of pages that I still wanted to read and am looking for a way to find them back...

Asked by jerome.santarini 1 day ago

Last reply by jerome.santarini 1 day ago

When searching with * "Search with DuckDuckGo" always on top

When I search my bookmarks with *, instead of my bookmarks showing on top and selected, always "Search with DuckDuckGo" on top and selected. I want to write my bookmark k… (read more)

When I search my bookmarks with *, instead of my bookmarks showing on top and selected, always "Search with DuckDuckGo" on top and selected. I want to write my bookmark keyword and tap Enter to reach the website. Is this possible?

Asked by Yusuf 6 days ago

Last reply by Yusuf 4 days ago

Items in Bookmarks toolbar randomly rearranging.

Items in my Bookmarks toolbar (and the overflow bookmarks list) keep rearranging themselves. I put them back in order, then every time I open Firefox, they rearrange agai… (read more)

Items in my Bookmarks toolbar (and the overflow bookmarks list) keep rearranging themselves. I put them back in order, then every time I open Firefox, they rearrange again. I've read through and tried everything suggested in the discussions and articles except the refresh, with I'd prefer not to do if it's not absolutely necessary. Nothing else suggested has worked. Any help will be appreciated. I believe this started after the last Firefox update. This is getting frustrating to the point I'm ready to stop using Firefox altogether. Thank you!

Asked by lhph74oo 2 weeks ago

Last reply by lhph74oo 6 days ago