[dba-Tech] FireFox

[Stuart McLachlan]

I do a lot of work with SQLite.   My favourite tool for working with it (design and data 
manipuation) is the Firefox extension SQLite Manager:

https://github.com/lazierthanthou/sqlite-manager

 There are a few SQLite ODBC drivers available if you want to access SQLite from Access 
etc.  Both commercial and freeware

Here's one released under a BSD-type licence: http://www.ch-werner.de/sqliteodbc/

-- 
Stuart
 

On 27 Oct 2016 at 11:17, Jim Lawrence wrote:

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