X
Tap here to go to the mobile version of the site.

Support Forum

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

Posted

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?
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 #the purpose of addons.sqlite in Firefox 4? #how does it/its function differ from extensions.sqlite in Firefox 4 #are both really necessary?

Modified by SafeBrowser

Chosen solution

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.

Read this answer in context 2

Additional System Details

This happened

Every time Firefox opened

This started when...

Installation of Firefox 4

Installed Plug-ins

  • IE Tab Plug-in for Mozilla/Firefox
  • Foxit Reader Plug-In For Firefox and Netscape
  • Shockwave Flash 10.2 r152
  • Adobe Shockwave for Director Netscape plug-in, version 11.5.9.620
  • Next Generation Java Plug-in 1.6.0_24 for Mozilla browsers
  • Version 1.1.6, copyright 1996-2011 The VideoLAN Teamhttp://www.videolan.org/

Application

  • User Agent: Mozilla/5.0 (Windows NT 5.1; rv:2.0) Gecko/20100101 Firefox/4.0

More Information

the-edmeister
  • Top 10 Contributor
  • Moderator
4082 solutions 30838 answers

Chosen Solution

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.

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

Question owner

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.

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.