cancel
Showing results for 
Search instead for 
Did you mean: 

Firefox 4. What is the difference in addons.sqlite and extensions.sqlite in the Profile folder?

SOLVED
Highlighted
Shooting Star Contributor

Firefox 4. What is the difference in addons.sqlite and extensions.sqlite in the Profile folder?

I have separate installations of Firefox 3.6.15 and Firefox 4RC2, using their own separate, distinct profile folders.

I already know that, in the Profile folder:

  • Firefox 3.6.x has files extensions.ini, extensions.log and extensions.rdf
  • Firefox 4 has replaced extensions.rdf with extensions.sqlite
  • Firefox 4 apparently does not have extensions.log
  • Firefox 3.6.x does not have addons.sqlite
  • Firefox 4 does have addons.sqlite

For a better understanding of this, can someone please answer, clearly, the following 3 questions?

What is

  1. the purpose of addons.sqlite in Firefox 4?
  2. how does it/its function differ from extensions.sqlite in Firefox 4
  3. are both really necessary?
1 ACCEPTED SOLUTION

Accepted Solutions
Support Forum Moderator

Re: Firefox 4. What is the difference in addons.sqlite and extensions.sqlite in the Profile folder?

addons.sqlite stores the information that appears in the Addons tab > Extensions - under the More button, along with AMO URL's for extensions that aren't setup to use that new feature.

extensions.sqlite stores data about installed extensions, replacing the extensions.rdf and extensions.cache files.

You don't really need the addons.sqlite file, but I don't know the ramifications of deleting the contents of that file and "locking" it to keep it from being used. Not that it stores a lot of data; only 320kb with 30 extensions installed.

2 REPLIES
Support Forum Moderator

Re: Firefox 4. What is the difference in addons.sqlite and extensions.sqlite in the Profile folder?

addons.sqlite stores the information that appears in the Addons tab > Extensions - under the More button, along with AMO URL's for extensions that aren't setup to use that new feature.

extensions.sqlite stores data about installed extensions, replacing the extensions.rdf and extensions.cache files.

You don't really need the addons.sqlite file, but I don't know the ramifications of deleting the contents of that file and "locking" it to keep it from being used. Not that it stores a lot of data; only 320kb with 30 extensions installed.

Shooting Star Contributor

Re: Firefox 4. What is the difference in addons.sqlite and extensions.sqlite in the Profile folder?

Thanks for the reply and information.

The reason that I asked the question, is that FEBE does not work correctly and it appears to be due to the addons.sqlite file. Others on the FEBE forum are experiencing problems similar to mine with Firefox 4 and the FEBE development build for Firefox 4. I know it is the developer's problem to fix FEBE, but just to explain what is happening:

  • Full Profile backup in FEBE backs up all extensions to a file named profileFx4{0 Beta Profile}.fbu in the folder designated for FEBE backups
  • Selective backup is another matter:
    • Only some extensions (1-9 in my case, varies from day to day) get backed up individually in the designated backup folder
    • Exit Firefox 4 and rename addons.sqlite then restart Firefox 4 and all extensions get backed up in Selective backup

I am sure that FEBE's developer knows about these 2 files (addons.sqlite and extensions.sqlite) and their functions. In my case, after much experimentation, the problem appears to be related to addons.sqlite.

Thanks again.