11 replies to this topic

[norel]

Does anyone know if the file index.sqlite in Firefox is a cookie? The full path is:

C:\Documents and Settings\Owner\Local Settings\Application Data\Mozilla\Firefox\Profiles\ctnmb1cc.default\OfflineCache\index.sqlite.

We have three computers (all with FF) and CCleaner flags it as a cookie on one of them but not on the other two. Of those two, one is XP and the other is Vista. The one that's marking it as a cookie is also XP. I'm trying to figure out why it calls it a cookie on one but not the other two. Thanks.

[Winapp2.ini]

I tried looking into it but I wasn't able to with the SQLite Manager addon for Firefox.

[Alan_B]

*\OfflineCache\index.sqlite
What its purpose is I do not know.
Mozilla has FAQs, forums and experts that may tell you.

This is not a likely place for a cookie.
On my machine it was last created, modified, and accessed on 18th June

If a site wanted to plant a cookie then it needs to be ON-LINE and not OFF-LINE
*\Cache\  is a folder with tons of stuff, some of which is time stamped today.

[TheWebAtom]

I'm fairly sure that it's the index of HTML5 Offline Data.

Modern web apps made in Javascript and HTML5 can store their data (.html, .js and .css) files inside your browser's cache so they don't require re-downloading when they're next needed. It's also designed to allow HTML5 apps to run offline.

The index.sqlite file is a database of what files are stored on the computer and what app they belong to. This works like the Windows MFT.

[pwillener]

Firefox/Waterfox stores lots of things in various sqlite db files; I believe cookies as well.  However, these files are not cookies per se, just storage files.

What Firefox version are you running; I do no longer have an index.sqlite file with Firefox/Waterfox 15.

[DennisD]

This is the contents of the "index.sqlite" file on my XP machine as read by "Peek"...

 2012-09-04_193621.jpg   378.55K   12 downloads

If you know what it is exactly, let me know.

"Peek" can just about read anything. (Introduced to me by Login123 I believe)

[pwillener]

It looks like SQL definitions to me (CREATE TABLE, CREATE INDEX, etc.).  What is the date of that file on your machine?

I do not even have an OfflineCache folder on any of my machines with Firefox/Waterfox 15.  All my sqlite files are in the main profile folder.

[TheWebAtom]

Okay; MozillaDocs confirms that it's used by HTML5 apps.

[DennisD]

pwillener, on 05 September 2012 - 02:37 AM, said:

It looks like SQL definitions to me (CREATE TABLE, CREATE INDEX, etc.).  What is the date of that file on your machine?

If the info is still of some use the date is 14th Feb 2012.

[pwillener]

In the light what TheWebAtom wrote, does the date update if you go to any HTML5 page?

[TheWebAtom]

Try HTML5 Storage Events Demo and Offline Application: using manifest Demo or, (my personal favorite demo) Halma

[DennisD]

pwillener, on 12 September 2012 - 02:39 AM, said:

In the light what TheWebAtom wrote, does the date update if you go to any HTML5 page?

Nope, still reads 14th February 2012 for Created, Modified and Accessed.

A really nice HTML5 example here ...

Moma | Century of the Child:


EDIT:  Site not supported by Opera by the way. Well, at least my Opera (11.64)