[dba-Tech] FireFox

[Peter Brawley]

On 10/30/2016 1:18, Jim Lawrence wrote:
> 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?

Hi Jim,

Not that it's "not good", just that it's more suited to beginner and 
smaller database problems because it's a more limited implementation of 
ISO SQL specs than MSSQL, Oracle, MySQL, PostGres &c. It's not really 
even client-server. The sqlite site 
(http://www.sqlite.org/whentouse.html) lists circumstances where you 
should use a more complete DB tool.

Some specific limits: loose data typing so dodgy data integrity, very 
limited ALTER TABLE, limitations in transaction blocking, query engine 
limits (no right join, complex queries get problematic), loosy-goosy 
aggregation can elicit wrong results with no warning, no GRANT or 
REVOKE, Views are read-only.

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

SQLite has its place, as its market success indicates. Think Access.

PB

-----

>
> 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
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>