How to access / export Safari browsing as file

Question

How can I export my Safari browsing history?

Alternatively, where does Safari store the history data?

(Yes, of course, I can click history in the menu bar, but that interface isn't very useful.)

Answer 1

The browsing history is located in a database stored at ~/Library/Safari/History.db.¹

This database can be accessed with sqlite3 via Terminal²:

sqlite3 ~/Library/Safari/History.db

At least on my device, the database has the following tables:

sqlite> SELECT name FROM sqlite_schema WHERE type='table' ORDER BY name;
history_client_versions
history_event_listeners
history_events
history_items
history_items_to_tags
history_tags
history_tombstones
history_visits
metadata
sqlite_sequence