Join the AMA (Ask Me Anything) with the Firefox leadership team to celebrate Firefox 20th anniversary and discuss Firefox’s future on Mozilla Connect. Mark your calendar on Thursday, November 14, 18:00 - 20:00 UTC!

Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

This thread was archived. Please ask a new question if you need help.

webappsstore.sqlite is 1GB, how do I clean it?

danafox
danafox
more options

I've searched for about an hour and a half now for an answer to this and have come up empty handed. My webappsstore.sqlite file is just under 1GB in size and taking up much needed space on my hard drive. As well, the places.sqlite file is over 80MB which also seems rather large. How do I clean these files and get them back to a normal size!? I found a Mozilla article that said not to delete the file. I have no idea why they are so large or how they got that way!

I've searched for about an hour and a half now for an answer to this and have come up empty handed. My webappsstore.sqlite file is just under 1GB in size and taking up much needed space on my hard drive. As well, the places.sqlite file is over 80MB which also seems rather large. How do I clean these files and get them back to a normal size!? I found a Mozilla article that said not to delete the file. I have no idea why they are so large or how they got that way!

All Replies (2)

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

SQLite database files are enlarged with fixed chunks to avoid performance issues caused by severe fragmentation. For places.sqlite this is 10 MB. The file size is never decreased. The only way to achieve a size reduction is to vacuum the SQLite database file.

For the places.sqlite file you can use this extension.

You will probably have to delete the webappsstore.sqlite file to remove all data stored in local storage.

See also:

the-edmeister
the-edmeister
  • Moderator
more options

Have you been looking thru the Mozilla Developer Network documentation?

Not sure which Mozilla article said not to delete that file, but AFAIK if that file is deleted (with Firefox closed, of course) a new file will be created when needed. Editing that file is not recommended, though. per - http://kb.mozillazine.org/Webappsstore.sqlite linked from - https://developer.mozilla.org/en-US/docs/Web/Guide/API/DOM/Storage = under Storage location and clearing the data