Last active
June 17, 2024 00:38
-
-
Save lindeskar/347fd5da63b91a109d382500adc70960 to your computer and use it in GitHub Desktop.
macOS 10.13 Safari browser history with timestamp
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sqlite3 $HOME/Library/Safari/History.db "select datetime(visit_time + 978307200, 'unixepoch', 'localtime') as date, title from history_visits order by visit_time asc" |
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!
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!
Yeah. Works. Thanks a lot :D
Works well but doesn't show url unfortunately. Url is in another table I think
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
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! :)