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" |
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
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!