[dba-Tech] FireFox

[John R Bartow]

That is cool. Makes me wonder if docx, pptx, etc are the similar.

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

On a related note. Did you know that Excel 2007+ files are actually ZIP
files containing a series of XLM files. That's why they do not compress
much: already compressed internally. Change the extension of an .xlsx file
to ZIP and you can open it in your favorite ZIP manager as see the structure
laid out.

Lambert  

-----Original Message-----
From: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of
Jim Lawrence
Sent: Thursday, October 27, 2016 1: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