I think what you may be missing in your steps is M-x package-refresh-contents or M-x package-list-packages. I use the latter in the video I share below.
These are noted in “Getting started” of MELPA.
Note that you’ll need to run
M-x package-refresh-contentsorM-x package-list-packagesto ensure that Emacs has fetched the MELPA package list before you can install packages withM-x package-installor similar.
The current version available in MELPA does not require emacsql-sqlite. See this screenshot from Emacs. Note it equires emacsql (not emacsql-sqlite).
Here is a 40-second video where I install Org-roam (video taken on 2024-11-23). I have no problem. The steps are simply this:
- Paste the snippet from MELPA
- Evaluate the snippet
M-x package-list-packages- Wait for Emacs to fetch the MELPA package list (wait for “Loading” to finish)
- Find
org-roam - Install
org-roam