[dba-Tech] FireFox

[Martin Reid]

https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

Sent from my Windows Phone
________________________________
From: Jim Lawrence<mailto:accessd at shaw.ca>
Sent: ‎28/‎10/‎2016 22:10
To: Discussion of Hardware and Software issues<mailto:dba-tech at databaseadvisors.com>
Subject: Re: [dba-Tech] FireFox

Hi John:

It appears that FF saves everything a user does and everywhere a user goes. You can see how those files can quickly grow.

I do not have a Windows machine immediately handy so I can not see where and how FF stores the data but I would suspect almost exact as in Linux. In their data directory, I noticed that there are blank file templated. This suggests that the current data files can be archive and a clean empty templates renamed, in their place. (This so much reminds me of outlook and its very limited MDB database.)

Does CCleaner actually go into the tables and remove the oldest records or does it just run a compress on the files? Note: As far as I can see FF never deletes anything so a table compression would be pointless. I have looked into the size capabilities of a SQLite table and it is 60TB or more. I believe, that FF, in order to increase search speeds, loads the indexes into memory and hence why all the memory disappears. That said, it seems that all the browsers function exactly the same way.

Looking at all the scenarios, I might just spend sometime and do some serious editing of the SQLite files and strip out most of the garbage...manually. It could take quite a while but at least for a time after, it would be like having a new browser. :-)

Jim

----- Original Message -----
From: "John R Bartow" <jbartow at winhaven.net>
To: "Discussion of Hardware and Software issues" <dba-tech at databaseadvisors.com>
Sent: Friday, October 28, 2016 8:31:41 AM
Subject: Re: [dba-Tech] FireFox

A few version ago Ccleaner added the option to compress Firefox's database
as part of it's cleanup routine. The db muct get a little bloated when used
by FF. (?)

-----Original Message-----
From: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of
Jim Lawrence
Sent: Thursday, October 27, 2016 12:18 PM
To: Discussion of Hardware and Software issues
Subject: [dba-Tech] FireFox

Hi All:

Does everyone already know this or is it just me, that the following
amazing?

I have just discovered that FireFox is built on top of a series of SQLite
files. Every plugin, setting, history, download, cookie, visted site, caches
and bookmarks are all stored in these database files. All tranaction date,
size, duration, activity and location is stored in the records. If you lose
some information and wish to trace it just dig through these files. Mind
you, if you have been using your version of FF for more than a couple weeks,
the files are huge and date ranges are the only way to find anything usable
(50 pages of data is useless)...spent hours last night trying to find
details on a couple of visited site (and was learning how SQLite works).

I have not tried to use other SQLs to access the data as I suspect SQLite
has it own data encoding. I was working at the command prompt for quite a
while before I downloaded a GUI. Has anyone else had experience with SQLite?
If you have do you have any comments or recommendations?

TIA
Jim
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com