sqlite3

p:: CLI, macOS

sqlite3 --version

3.43.2 2023-10-10 13:08:14 1b37c146ee9ebb7acd0160c0ab1fd11017a419fa8a3187386ed8cb32b709aapl (64-bit)

• macOS 10.13 Safari browser history with timestamp

sqlite3 ~/Library/Safari/History.db "select datetime(visit_time + 978307200, 'unixepoch', 'localtime') as date, title from history_visits order by visit_time asc"

• https://stackoverflow.com/a/54914712
  • Apple Cocoa Core Data has a start date of 2001/01/01 rather than 1970/01/01 and thus 978307200 is the number of seconds difference between the two.

---

• Squeezing Performance from SQLite: Indexes? Indexes! | by Jason Feinstein | Medium