Firefox users can make SQL queries against their history database using sqlite3. Just shut down Firefox first. This will find top level URLs you've visited.
sqlite3 places.sqlite "SELECT url FROM moz_places WHERE substr(url,-1,1)=='/' AND length(url)-length(replace(url,'/',''))<4;"
Command Line Magic /
npub17h…xtk0h
2024-08-19 15:37:23
Author Public Key
npub17hcswhel45t4tnh3a7gzf4f74lfyafrq8qe3nlaejj0nk63umcdqcxtk0hPublished at
2024-08-19 15:37:23Event JSON
{
"id": "77435899d4a7bd396d9390d051b444ba214baee138525b619bd953d3f0a127b7",
"pubkey": "f5f1075f3fad1755cef1ef9024d53eafd24ea460383319ffb9949f3b6a3cde1a",
"created_at": 1724081843,
"kind": 1,
"tags": [
[
"proxy",
"https://mastodon.social/users/climagic/statuses/112989427676001207",
"activitypub"
]
],
"content": "Firefox users can make SQL queries against their history database using sqlite3. Just shut down Firefox first. This will find top level URLs you've visited.\n\nsqlite3 places.sqlite \"SELECT url FROM moz_places WHERE substr(url,-1,1)=='/' AND length(url)-length(replace(url,'/',''))\u003c4;\"",
"sig": "8a0de365e030e8cea4a2f644d0520cd8a0074cf491b5f389a8752375293511611e53e91a01eb984882206e3b96ebf6b5315639c31fe6541144f3592fb7c8eb0a"
}