Firefox cookie database - Revision history

KlfJoat: Links, brackets, and parentheses.

2022-10-05T17:31:42Z

Links, brackets, and parentheses.

2022-09-20T00:22:46Z

fix hyperlink

2022-09-19T22:57:28Z

Wording for path

2022-09-19T21:41:57Z

Add info on current schema and multi-account containers, making it more human-readable than just a CREATE TABLE line by adding a table.

2022-08-16T04:59:21Z

Expand with information on how datetime fields are formatted

2020-03-01T17:36:50Z

‎Links

2020-02-08T13:25:58Z

Category:SQLite based file formats

2017-05-22T14:54:36Z

Category:Mozilla

2017-05-14T03:13:08Z

2013-12-22T13:38:05Z

@@ Line 49: / Line 49: @@
 | [https://web.dev/samesite-cookies-explained/#explicitly-state-cookie-usage-with-the-samesite-attribute <code>sameSite</code>] || <code>INTEGER</code> || <code>DEFAULT 0</code> || Cookies should only be readable by the same site that set them. Set in Set-Cookie header
 |-
-| <code>rawSameSite</code> || <code>INTEGER</code> || <code>DEFAULT 0</code> || [https://bugzilla.mozilla.org/show_bug.cgi?id=1551798#c19 "Preserve the 'on the wire' value [of the SameSite cookie, meaning] the value found in the Set-Cookie header"]
+| <code>rawSameSite</code> || <code>INTEGER</code> || <code>DEFAULT 0</code> || [https://bugzilla.mozilla.org/show_bug.cgi?id=1551798#c19 "Preserve the 'on the wire' value (of the SameSite cookie), meaning the value found in the Set-Cookie header"]
 |-
 | [https://web.dev/schemeful-samesite/ <code>schemeMap</code>] || <code>INTEGER</code> || <code>DEFAULT 0</code> || [https://bugzilla.mozilla.org/show_bug.cgi?id=1638358#c0 Consider different "schemes" (meaning http vs https) to be different sites]

@@ Line 51: / Line 51: @@
 | <code>rawSameSite</code> || <code>INTEGER</code> || <code>DEFAULT 0</code> || [https://bugzilla.mozilla.org/show_bug.cgi?id=1551798#c19 "Preserve the 'on the wire' value [of the SameSite cookie, meaning] the value found in the Set-Cookie header"]
 |-
-| [https://web.dev/schemeful-samesite/ <code>schemeMap</code>] || <code>INTEGER</code> || <code>DEFAULT 0</code> || [https://bugzilla.mozilla.org/show_bug.cgi?id=1638358#c0 Consider different "schemes" (meaning http vs https) to be different sites
+| [https://web.dev/schemeful-samesite/ <code>schemeMap</code>] || <code>INTEGER</code> || <code>DEFAULT 0</code> || [https://bugzilla.mozilla.org/show_bug.cgi?id=1638358#c0 Consider different "schemes" (meaning http vs https) to be different sites]
 |}

@@ Line 33: / Line 33: @@
 | <code>host</code> || <code>TEXT</code> || || Hostname that owns the cookie
 |-
-| <code>path</code> || <code>TEXT</code> || || Pathname at that host that owns the cookie
+| <code>path</code> || <code>TEXT</code> || || Pathname that owns the cookie at the host
 |-
 | <code>expiry</code> || <code>INTEGER</code> || || Cookie expiration in standard [[Unix time|Unix timestamp]] format

@@ Line 11: / Line 11: @@
 <code>CREATE TABLE moz_cookies (id INTEGER PRIMARY KEY, name TEXT, value TEXT, host TEXT, path TEXT, expiry INTEGER, lastAccessed INTEGER, isSecure INTEGER, isHttpOnly INTEGER, baseDomain TEXT, creationTime INTEGER)</code>
 == Datetime formats ==
@@ Line 17: / Line 61: @@
 <code>expiry</code> is stored in standard [[Unix time|Unix timestamp]] format. In SQLite, this can be converted to a human-readable format with <code>datetime("expiry", 'unixepoch')</code>.
-However, <code>lastAccessed</code> and <code>creationTime</code> are in microseconds. To convert to a human-readable format in SQLite use <code>datetime(("creationTime"/1000000),'unixepoch')</code>.
+However, <code>lastAccessed</code> and <code>creationTime</code> are in microseconds since the [[Unix time|Unix epoch]]. To convert to a human-readable format in SQLite use <code>datetime(("creationTime"/1000000),'unixepoch')</code>.
 == Links ==
@@ Line 24: / Line 68: @@
 * [https://addons.mozilla.org/en-US/firefox/addon/self-destructing-cookies/ Self-destructing cookie plugin: removes cookies when you close a tab]
 * [https://www.i-dont-care-about-cookies.eu/ Plugin to get rid of cookie warnings]
 [[Category:SQLite based file formats]]
 [[Category:Mozilla]]

@@ Line 9: / Line 9: @@
 The structure is seen in this SQL command embedded in the file:
-<code>CREATE TABLE moz_cookies (id INTEGER PRIMARY KEY, name TEXT, value TEXT, host TEXT, path TEXT,expiry INTEGER, lastAccessed INTEGER, isSecure INTEGER, isHttpOnly INTEGER, baseDomain TEXT, creationTime INTEGER)</code>
+<code>CREATE TABLE moz_cookies (id INTEGER PRIMARY KEY, name TEXT, value TEXT, host TEXT, path TEXT, expiry INTEGER, lastAccessed INTEGER, isSecure INTEGER, isHttpOnly INTEGER, baseDomain TEXT, creationTime INTEGER)</code>
 == Links ==

← Older revision		Revision as of 13:25, 8 February 2020
Line 16:		Line 16:
	* [https://addons.mozilla.org/en-US/firefox/addon/self-destructing-cookies/ Self-destructing cookie plugin: removes cookies when you close a tab]		* [https://addons.mozilla.org/en-US/firefox/addon/self-destructing-cookies/ Self-destructing cookie plugin: removes cookies when you close a tab]

		+	[[Category:SQLite based file formats]]
	[[Category:Mozilla]]		[[Category:Mozilla]]

← Older revision		Revision as of 14:54, 22 May 2017
Line 15:		Line 15:
	* [http://blogs.computerworlduk.com/open-enterprise/2013/08/did-you-know-that-mozilla-is-hijacking-the-internet/index.htm Commentary on Digital Advertising Alliance's criticism of Mozilla]		* [http://blogs.computerworlduk.com/open-enterprise/2013/08/did-you-know-that-mozilla-is-hijacking-the-internet/index.htm Commentary on Digital Advertising Alliance's criticism of Mozilla]
	* [https://addons.mozilla.org/en-US/firefox/addon/self-destructing-cookies/ Self-destructing cookie plugin: removes cookies when you close a tab]		* [https://addons.mozilla.org/en-US/firefox/addon/self-destructing-cookies/ Self-destructing cookie plugin: removes cookies when you close a tab]
		+
		+	[[Category:Mozilla]]

@@ Line 5: / Line 5: @@
 }}
-Cookies in Firefox are stored in an [[DB (SQLite)|SQLite]] format database found in the file '''cookies.sqlite''' in the currently-active user profile directory (exact path is system-dependent). Also, the write-ahead-logging and shared-memory files '''cookies.sqlite-wal''' and '''cookies.sqlite-shm''' are used, but the latter two are re-integrated into the main database file and deleted when you close the browser.
+Cookies in Firefox are stored in an [[SQLite]] format database found in the file '''cookies.sqlite''' in the currently-active user profile directory (exact path is system-dependent). Also, the write-ahead-logging and shared-memory files '''cookies.sqlite-wal''' and '''cookies.sqlite-shm''' are used, but the latter two are re-integrated into the main database file and deleted when you close the browser.
 The structure is seen in this SQL command embedded in the file: