The Org-roam v2 Great Migration

I’ve attempted to update roam to V2 using this guide ( Hitchhiker's Rough Guide to Org roam V2 · org-roam/org-roam Wiki · GitHub )

I’m using Doom emacs on Linux (NixOS),
the branch got installed successfuly, I think, but there is a problem with EmacSQL

When I try any new roam command (e.g org-roam-doctor )
I get error message
“emacsql-sqlite-ensure-binary: No EmacSQL SQLite binary available, aborting”
the list-packages seem to include “emacsql” and 4 backends (by default on Doom Emacs?)
but I still don’t have the binary?

For some reason I could only find questions about ‘emacsql-sqlite’ about Windows systems

Should binary have already been compiled during the package installation?

I do have “sqlite3” installed and available

λ (executable-find “sqlite3”)
/home/efim/.nix-profile/bin/sqlite3

How could I further troubleshoot this?
Does the error even refer to “emacsql-sqlite” binary?


My answer:
I could find lisp funcion in SPC h f “emacsql-sqlite-compile”

Trying to call it in eshell with I got Message “missing C compiler”
So I added “gcc” to available packages

And it seems that evoking (emacsql-sqlite-compile) fixed the problem
also documentaion said that the binary compilation is attempted at first use,
so I could have missed the message about lacking C compiler, or maybe there was no warning

1 Like