arethinn: glowing green spiral (Default)
I've been using sqlite3's "vacuum" function on Firefox (well Pale Moon)'s various .sqlite files since some much earlier version, 4.x probably (whenever they changed from using bookmarks.html to places.sqlite). I've heard some places that there is suppsoedly no need to do this in later versions because it vacuums itself now, or that it's bad to do it for some reason, but I still find it necessary (and not harmful) because otherwise the places.sqlite file especially can get quite large (i.e., if they actually do have any self-vacuuming in place, it -- forgive me -- sucks). Mine on this computer is currently 20 MB and I don't see any need for it to be that big, especially since I have site icons/favicons turned off. But at some point (can't pinpoint when) sqlite3 has begun to error on trying to vacuum cookies.sqlite and places.sqlite, saying the files are "encrypted or not a database." I think it still runs fine on my laptop, successfully vacuuming all the files, which makes this more confusing. Anyone have any ideas? All I can find on the net is "try deleting the sqlite files" and um, I don't really want to lose my bookmarks and cookies (even if Sync will redownload them I suppose, it's kind of a pain).
(will be screened)
(will be screened if not validated)
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting

If you are unable to use this captcha for any reason, please contact us by email at support@dreamwidth.org

Profile

arethinn: glowing green spiral (Default)
Arethinn

July 2025

S M T W T F S
  12345
6789101112
13141516171819
20 2122232425 26
2728293031  

Expand Cut Tags

No cut tags

Style Credit

Page generated Jan. 16th, 2026 07:36 pm
Powered by Dreamwidth Studios