Clean out webstoreapp.sqlite

User Help for Mozilla Firefox
iccor56
Posts: 5
Joined: September 24th, 2013, 8:03 pm

Clean out webstoreapp.sqlite

Post by iccor56 »

is there a way to clean out old data from webstoreapp.sqlite with out deleting the whole file?

maybe an option to remove anything not visited in over a year?
Last edited by DanRaisch on February 22nd, 2018, 10:14 am, edited 1 time in total.
Reason: Split from previous thread that died almost a year ago.
Brummelchen
Posts: 4480
Joined: March 19th, 2005, 10:51 am

Re: Clean out webstoreapp.sqlite

Post by Brummelchen »

Webappstore is offline Files. Something special you search for?
the magic number is 51 and you are probably part of it :p
User avatar
lovemyfoxy
Posts: 2337
Joined: December 11th, 2009, 11:23 am
Location: USA

Re: Clean out webstoreapp.sqlite

Post by lovemyfoxy »

I "Edit-Select All," then delete, then "Save."
2 Desktops--Win 7 Ult.SP1 x64/6GB RAM /Firefox 52.9ESR/Waterfox64 2022.11/Thunderbird 52.9ESR/BitWarden PW Manager/Verizon FIOS wired network
iccor56
Posts: 5
Joined: September 24th, 2013, 8:03 pm

Re: Clean out webstoreapp.sqlite

Post by iccor56 »

LoveMyFoxy wrote:I "Edit-Select All," then delete, then "Save."
@lovemyfoxy

i don't want to delete everything, i want to clean it out of old stuff. it's over 70 meg.

and just where do i edit it? if i knew i would start with a age search
User avatar
lovemyfoxy
Posts: 2337
Joined: December 11th, 2009, 11:23 am
Location: USA

Re: Clean out webstoreapp.sqlite

Post by lovemyfoxy »

The entries aren't dated. Good luck.
2 Desktops--Win 7 Ult.SP1 x64/6GB RAM /Firefox 52.9ESR/Waterfox64 2022.11/Thunderbird 52.9ESR/BitWarden PW Manager/Verizon FIOS wired network
User avatar
therube
Posts: 21698
Joined: March 10th, 2004, 9:59 pm
Location: Maryland USA

Re: Clean out webstoreapp.sqlite

Post by therube »

LoveMyFoxy wrote:I "Edit-Select All," then delete, then "Save."
Just where are you going to do that?
Fire 750, bring back 250.
Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.19) Gecko/20110420 SeaMonkey/2.0.14 Pinball CopyURL+ FetchTextURL FlashGot NoScript
iccor56
Posts: 5
Joined: September 24th, 2013, 8:03 pm

Re: Clean out webstoreapp.sqlite

Post by iccor56 »

LoveMyFoxy wrote:The entries aren't dated. Good luck.
i sure there is will have a last visited of some sort. or a auto key to derive order from.

but the big question is still WHERE would i edit it? i don't want to just up and delete the whole file, i want to clean it out. i want to retain the recent data
User avatar
therube
Posts: 21698
Joined: March 10th, 2004, 9:59 pm
Location: Maryland USA

Re: Clean out webstoreapp.sqlite

Post by therube »

(I looked, externally, using SQLiteSpy, but couldn't figure out how to delete records using it [using the GUI]? [Suppose you could do it with sqlite commands?])
Fire 750, bring back 250.
Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.19) Gecko/20110420 SeaMonkey/2.0.14 Pinball CopyURL+ FetchTextURL FlashGot NoScript
Brummelchen
Posts: 4480
Joined: March 19th, 2005, 10:51 am

Re: Clean out webstoreapp.sqlite

Post by Brummelchen »

mozilla is using its own kind of data format inside, dont change it outside!
iccor56
Posts: 5
Joined: September 24th, 2013, 8:03 pm

Re: Clean out webstoreapp.sqlite

Post by iccor56 »

Brummelchen wrote:mozilla is using its own kind of data format inside, dont change it outside!

then how would you suggest we see and adjust the data stored in the SQL files?
morat
Posts: 6403
Joined: February 3rd, 2009, 6:29 pm

Re: Clean out webstoreapp.sqlite

Post by morat »

You can delete items in local storage with the storage inspector.

http://developer.mozilla.org/en-US/docs ... _Inspector

You can use the sqlite command line program to dump the file into a text file.

Code: Select all

sqlite3.exe webappsstore.sqlite .dump > webappsstore.txt
http://sqlite.org/cli.html
iccor56
Posts: 5
Joined: September 24th, 2013, 8:03 pm

Re: Clean out webstoreapp.sqlite

Post by iccor56 »

storage inthe toolbox inspects only the page you are on, and dumping it to a text file is not useful.

is it really that hard to open it in an sql database editor?
morat
Posts: 6403
Joined: February 3rd, 2009, 6:29 pm

Re: Clean out webstoreapp.sqlite

Post by morat »

It is possible to cause profile corruption if you cleanup the databases in an unsupported way.
User avatar
Benjamin Markson
Posts: 397
Joined: November 19th, 2011, 3:57 am
Location: en-GB

Re: Clean out webstoreapp.sqlite

Post by Benjamin Markson »

iccor56 wrote:is there a way to clean out old data from webstoreapp.sqlite with out deleting the whole file?
You are apparently on FF56 (an odd choice), in which case you should be able to use a 'proper' tool: SQLite Manager

You can use this add-on to view the contents of any sqlite file.

I have no records in webappsstore.sqlite and its size is 96k. So, unless you feel there is something really important in there you can simply Empty the webappsstore2 table using the SQLite Manager. Or, just close FF, delete/rename the file, restart - FF will rebuild it as an empty database.

For those on FF57+ you'll need to fire up a capable version of FF which you can then use to view/manipulate sqlite files in any of your FF profiles. :lol:

Ben.
XUL is dead. Long live the Google Chrome Clones.
Brummelchen
Posts: 4480
Joined: March 19th, 2005, 10:51 am

Re: Clean out webstoreapp.sqlite

Post by Brummelchen »

I have no records in webappsstore.sqlite and its size is 96k
same here.
i use "sqlitebrowser" and/or "sqlitestudio" to have a look into when user asking like here

but same answer here
https://support.mozilla.org/de/questions/1174937
You can safely delete the file at any time.
same here: http://kb.mozillazine.org/Webappsstore.sqlite

or here
http://forums.mozillazine.org/viewtopic ... &t=3026521
if i would be you i would listen to morat ;)

i can walk trough my past profiles, any - nothing more than 96k.
Post Reply