Clean out webstoreapp.sqlite
-
- Posts: 5
- Joined: September 24th, 2013, 8:03 pm
Clean out webstoreapp.sqlite
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?
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.
Reason: Split from previous thread that died almost a year ago.
-
- Posts: 4480
- Joined: March 19th, 2005, 10:51 am
Re: Clean out webstoreapp.sqlite
Webappstore is offline Files. Something special you search for?
the magic number is 51 and you are probably part of it
- lovemyfoxy
- Posts: 2337
- Joined: December 11th, 2009, 11:23 am
- Location: USA
Re: Clean out webstoreapp.sqlite
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
-
- Posts: 5
- Joined: September 24th, 2013, 8:03 pm
Re: Clean out webstoreapp.sqlite
@lovemyfoxyLoveMyFoxy wrote:I "Edit-Select All," then delete, then "Save."
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
- lovemyfoxy
- Posts: 2337
- Joined: December 11th, 2009, 11:23 am
- Location: USA
Re: Clean out webstoreapp.sqlite
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
- therube
- Posts: 21703
- Joined: March 10th, 2004, 9:59 pm
- Location: Maryland USA
Re: Clean out webstoreapp.sqlite
Just where are you going to do that?LoveMyFoxy wrote:I "Edit-Select All," then delete, then "Save."
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
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
-
- Posts: 5
- Joined: September 24th, 2013, 8:03 pm
Re: Clean out webstoreapp.sqlite
i sure there is will have a last visited of some sort. or a auto key to derive order from.LoveMyFoxy wrote:The entries aren't dated. Good luck.
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
- therube
- Posts: 21703
- Joined: March 10th, 2004, 9:59 pm
- Location: Maryland USA
Re: Clean out webstoreapp.sqlite
(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
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
-
- Posts: 4480
- Joined: March 19th, 2005, 10:51 am
Re: Clean out webstoreapp.sqlite
mozilla is using its own kind of data format inside, dont change it outside!
-
- Posts: 5
- Joined: September 24th, 2013, 8:03 pm
Re: Clean out webstoreapp.sqlite
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?
-
- Posts: 6406
- Joined: February 3rd, 2009, 6:29 pm
Re: Clean out webstoreapp.sqlite
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.
http://sqlite.org/cli.html
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
-
- Posts: 5
- Joined: September 24th, 2013, 8:03 pm
Re: Clean out webstoreapp.sqlite
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?
is it really that hard to open it in an sql database editor?
-
- Posts: 6406
- Joined: February 3rd, 2009, 6:29 pm
Re: Clean out webstoreapp.sqlite
It is possible to cause profile corruption if you cleanup the databases in an unsupported way.
- Benjamin Markson
- Posts: 397
- Joined: November 19th, 2011, 3:57 am
- Location: en-GB
Re: Clean out webstoreapp.sqlite
You are apparently on FF56 (an odd choice), in which case you should be able to use a 'proper' tool: SQLite Managericcor56 wrote:is there a way to clean out old data from webstoreapp.sqlite with out deleting the whole file?
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.
Ben.
XUL is dead. Long live the Google Chrome Clones.
-
- Posts: 4480
- Joined: March 19th, 2005, 10:51 am
Re: Clean out webstoreapp.sqlite
same here.I have no records in webappsstore.sqlite and its size is 96k
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
same here: http://kb.mozillazine.org/Webappsstore.sqliteYou can safely delete the file at any time.
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.