Firefox database design

Router

unread,

May 5, 2010, 9:47:15 AM5/5/10

to support...@lists.mozilla.org

I am looking for documentation of the sqlite database design underlying
Firefox 3.5.x.
I know for example that places.sqlite contains browsing history, I am
looking for more detail as to the purpose. and relations between the tables.
My ultimate goal is to build scripts to clean out unnecessary data (for
privacy purposes) without deleting all browsing history.

TIA,

Ken

David McRitchie

unread,

May 5, 2010, 10:42:04 AM5/5/10

to

"Router" ...

> privacy purposes) without deleting all browsing history. // Ken

This newsgroup is for user support of Firefox, basically drawing on
other users to answer questions. As users we can manually delete
history starting from AwesomeBar type searching in the History
or through the location bar. We do not get into sqlite database
internals or programming. This would be one the references that we use
http://kb.mozillazine.org/Viewing_the_browsing_history_-_Firefox

You need to ask your question in a Developer newsgroups, suggest
starting in the newsgroup
mozilla.dev.apps.firefox
and asking there for reference links and to the correct newsgroup based
on what language you would be using to access the sqlite database.

This addon would probably help you in some manner
SQLite Manager
https://addons.mozilla.org/en-US/firefox/addon/5817

You main references would probably be within
https://developer.mozilla.org/
but there is a notice there that there are problems with the site today.

Fox on the run

unread,

May 5, 2010, 12:19:18 PM5/5/10

to

Here is one that I created and uploaded almost 2 years ago now. The
change with 3.5 is an additional field in one of the tables (I'd have
to check my notes to see which one).

JB

Fox on the run

unread,

May 5, 2010, 12:20:02 PM5/5/10

to

On May 5, 11:47 am, Router <di604ad...@embarqmail.com> wrote:

Would help if I included the URL in that last message...

https://wiki.mozilla.org/images/d/d5/Places.sqlite.schema3.pdf

JB

Fox on the run

unread,

May 5, 2010, 12:27:03 PM5/5/10

to

There is another at http://people.mozilla.org/~dietrich/places-erd.png
but it doesn't have the same level of detail as the one I posted. It
identifies the foreign keys in the various tables.

And here are both of them in the context of a wiki page:

https://wiki.mozilla.org/Places:Design_Overview

The one change from my original schema is the addition of
"last_visit_date" in moz_places table (I believe it's an integer date
expressed in PRTime UTC as with the other dates).

JB