Browsing Safari history with fzf?

[ghost]

• Category
  • fzf binary
  • fzf-tmux script
  • Key bindings
  • Completion
  • Vim
  • Neovim
  • Etc.
• OS
  • Linux
  • Mac OS X
  • Windows
  • Windows Subsystem for Linux
  • Etc.
• Shell
  • bash
  • zsh
  • fish

browsing-chrome-history-with-fzf sounds neat, does someone know how to deal with Safari which afaik has .plist files for its history? It's ~/Library/Safari/History.db as a sqlite3

I've now git it somewhat working by using

c() {
  local cols sep
  cols=$(( COLUMNS / 3 ))
  sep='{::}'

  cp -f ~/Library/Safari/History.db /tmp/h

  sqlite3 -separator $sep /tmp/h \
    "select substr(id, 1, $cols), url
     from history_items" |
  awk -F $sep '{printf "%-'$cols's  \x1b[36m%s\x1b[m\n", $1, $2}' | grep "http|https" |
  fzf --ansi --multi | sed 's#.*\(https*://\)#\1#' | xargs open

where this is what the database seems to hold

history_client_versions  history_items            metadata
history_event_listeners  history_tombstones
history_events           history_visits

CREATE TABLE history_items (id INTEGER PRIMARY KEY AUTOINCREMENT,url TEXT NOT NULL UNIQUE,domain_expansion TEXT NULL,visit_count INTEGER NOT NULL,daily_visit_counts BLOB NOT NULL,weekly_visit_counts BLOB NULL,autocomplete_triggers BLOB NULL,should_recompute_derived_visit_counts INTEGER NOT NULL,visit_count_score INTEGER NOT NULL);
CREATE INDEX history_items__domain_expansion ON history_items (domain_expansion);

maybe someone can tell me how to do this in a proper command

[edi9999]

What is wrong with the command ?

[ghost]

I was not sure I did it correctly since I've never used sql before. (I have no idea what select substr(id, 1, $cols) is doing especially)
Now I'm using

c() {
  local cols sep
  cols=$(( COLUMNS / 3 ))
  sep='{::}'

  cp -f ~/Library/Safari/History.db /tmp/h

  sqlite3 -separator $sep /tmp/h \
    "select substr(id, 1, $cols), url
     from history_items order by visit_count_score desc" |
  awk -F $sep '{printf "%-'$cols's  \x1b[36m%s\x1b[m\n", $1, $2}'  |
  fzf --ansi --multi | sed 's#.*\(https*://\)#\1#' | xargs open
}

so removed the ugly grep part and added sorting...

it's probably good to close