Search notes:

Firefox profile folder: places.sqlite

An SQLite database with the history of visited sites, bookmarks and a list of downloaded files.

Tables

Some interesting tables in this database seem to be:

moz_places (which contains interesting statistics such as visit count or frecency
moz_historyvisits
moz_inputhistory
moz_hosts
moz_bookmarks
moz_keywords
moz_anno_attributes
moz_annos (Seems to store details about downloaded resources. The columns flags, expiration, type, dateAdded and lastModified seem to be deprecated)
moz_items_annos
moz_bookmarks_deleted
moz_meta
moz_origins

Links

Akkana: Exploring your Search History in Firefox

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1745471839, '3.147.71.176', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/web/browser/Firefox/profile-folder/places_sqlite/index(58): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

Firefox profile folder: places.sqlite

Tables

See also

Links