Skip to content

Instantly share code, notes, and snippets.

@lindeskar
Last active August 3, 2024 01:45
Show Gist options
  • Save lindeskar/347fd5da63b91a109d382500adc70960 to your computer and use it in GitHub Desktop.
Save lindeskar/347fd5da63b91a109d382500adc70960 to your computer and use it in GitHub Desktop.
macOS 10.13 Safari browser history with timestamp
sqlite3 $HOME/Library/Safari/History.db "select datetime(visit_time + 978307200, 'unixepoch', 'localtime') as date, title from history_visits order by visit_time asc"
@lindeskar
Copy link
Author

Apparently there is no way to view the timestamp of Safari browser history without opening the SQLite database and converting the Unix timestamp. This will dump all history in your shell with the timestamp converted.
Replace "alex" with your username! :)

@redbar0n
Copy link

redbar0n commented Dec 3, 2017

Thank you, this is great! :D

I really missed the timestamps from Chrome (but Chrome was a CPU/Memory hog, so I had to switch to Safari). And it was difficult finding any clean way to get the history in Safari (for my timesheet), but this did the trick!

@2nevergiveup
Copy link

Hi @ @lindeskar,
Sorry for the stupid question, where do I run your code to see the time stamp for the safari browser?
Thanks in advance!

@AgnieszkaUcinska
Copy link

Yeah. Works. Thanks a lot :D

@amsimoes
Copy link

Works well but doesn't show url unfortunately. Url is in another table I think

@rogerluan
Copy link

Might be useful for someone: you can view the history visually in a GUI like https://sqlitebrowser.org/dl/
It's the same file in the command line: /Users/your_user_name/Library/Safari/History.db

Hope this helps someone.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment