MozillaZine

Clean out webstoreapp.sqlite

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

Post Posted February 22nd, 2018, 9:39 am

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: 3781
Joined: March 19th, 2005, 10:51 am

Post Posted February 23rd, 2018, 7:11 am

Webappstore is offline Files. Something special you search for?
users who problaby never will get an answer from me: f*x, f*n, j*n, k*s, k*x, l*y, m*o, m*d, m*x, o*l, p*y, s*e, d*h, l*t, d*e, j*k, f*u*a, h*2

LoveMyFoxy

User avatar
 
Posts: 2099
Joined: December 11th, 2009, 11:23 am
Location: USA

Post Posted February 23rd, 2018, 12:17 pm

I "Edit-Select All," then delete, then "Save."
Desktop--Win 7 Ult. 64-bit, 6GB RAM /FF 52ESR 64/ Thunderbird 52 / MS Sec. Essent./ Windows firewall / Verizon FIOS

iccor56
 
Posts: 5
Joined: September 24th, 2013, 8:03 pm

Post Posted March 7th, 2018, 3:18 pm

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

LoveMyFoxy

User avatar
 
Posts: 2099
Joined: December 11th, 2009, 11:23 am
Location: USA

Post Posted March 7th, 2018, 10:23 pm

The entries aren't dated. Good luck.
Desktop--Win 7 Ult. 64-bit, 6GB RAM /FF 52ESR 64/ Thunderbird 52 / MS Sec. Essent./ Windows firewall / Verizon FIOS

therube

User avatar
 
Posts: 19093
Joined: March 10th, 2004, 9:59 pm
Location: Maryland USA

Post Posted March 8th, 2018, 10:40 am

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

Just where are you going to do that?
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

Post Posted March 9th, 2018, 8:06 am

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

therube

User avatar
 
Posts: 19093
Joined: March 10th, 2004, 9:59 pm
Location: Maryland USA

Post Posted March 9th, 2018, 11:04 am

(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?])
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: 3781
Joined: March 19th, 2005, 10:51 am

Post Posted March 9th, 2018, 1:46 pm

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

iccor56
 
Posts: 5
Joined: September 24th, 2013, 8:03 pm

Post Posted March 9th, 2018, 4:37 pm

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: 2858
Joined: February 3rd, 2009, 6:29 pm

Post Posted March 9th, 2018, 5:48 pm

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

http://developer.mozilla.org/en-US/docs/Tools/Storage_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

Post Posted March 9th, 2018, 6:21 pm

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: 2858
Joined: February 3rd, 2009, 6:29 pm

Post Posted March 9th, 2018, 7:24 pm

It is possible to cause profile corruption if you cleanup the databases in an unsupported way.

Benjamin Markson

User avatar
 
Posts: 363
Joined: November 19th, 2011, 3:57 am
Location: en-GB

Post Posted March 10th, 2018, 2:16 am

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: 3781
Joined: March 19th, 2005, 10:51 am

Post Posted March 10th, 2018, 6:58 am

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
viewtopic.php?f=38&t=3026521
if i would be you i would listen to morat ;)

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

Return to Firefox Support


Who is online

Users browsing this forum: No registered users and 14 guests