[dba-Tech] FireFox

[Stuart McLachlan]

The table in my  FF webappsstore.sqlite  database has 29798 rows but the maximum RowID 
is 74255, so it certainly looks as though it could do with "Conpact".

Looks to me like poor  programming to not include periodic db cleanup.



On 28 Oct 2016 at 10:31, John R Bartow wrote:

> 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
>