Little hack to view the cache (aka databse) using DB Brower for sqllite

Might as well share this…

    (defun org-roam-view-db-bah ()
      (interactive)
      ;; This only works on the MacOS, but that ought nto be
      ;; Brew can install DB Browser for Sqlite<https://sqlitebrowser.org/>
      ;;   brew install --cask db-browser-for-sqlite
      (cond
       ((eq system-type 'darwin)
        (shell-command
         (format "open \"/Applications/DB Browser for SQLite.app\" --args --table nodes %s" org-roam-db-location)))
       (t
         (message "org-roam-view-db-bah not yet working on this system-type")))

Useful if you are curious what the cache knows.

2 Likes