Command Line Magic on Nostr: Firefox users can make SQL queries against their history database using sqlite3. Just ...
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;"
Published 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"
}