Where'd that file come from?
2025-04-28 19:03:11.389277+02 by Dan Lyke 0 comments
Thinking about file metadata for various things, and needed to put down a note here. To get the source URL from downloaded files in Firefox:
SELECT url,title FROM moz_places WHERE id IN (SELECT place_id FROM moz_historyvisits WHERE visit_type = 7);</blokquote>Probably need to copy places.sqlite before querying it with SQLite, 'cause Firefox locks it while it's open.
On MacOS, the file is in /Users/danlyke/Library/Application Support/Firefox/Profiles/*/places.sqlite.