[dba-Tech] FireFox

[Jim Lawrence]

Hi Peter:

A question... 

You said the SQLite was not a good database and suggested that there was some serious problems with it. Of course there should be no expectation that it matches features of MySQL or MS SQL but if the product is faulty...I would like to know why and how?

I decided to take a closer look at the SQLite DB, when I discovered it as the BE to FF and when Microsoft announced they would be supporting its use on Azure. If the application is really crippled why would MS be boosting it?  

Jim

----- Original Message -----
From: "Peter Brawley" <peter.brawley at earthlink.net>
To: "Discussion of Hardware and Software issues" <dba-tech at databaseadvisors.com>
Sent: Friday, October 28, 2016 5:53:44 PM
Subject: Re: [dba-Tech] FireFox

On 10/28/2016 18:50, Stuart McLachlan wrote:
> 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".
No no no, rowID is just an auto_increment value, a value of 74255 with a 
rowcount of 29798 does /not/ mean there are 44k rows of dead space---the 
diff between 74255 and 29798 is purely logical, it has no impact 
whatever on physical disk usage or on performance.

PB

------

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