Hi all. I’m using emacs 29.0.60 on Fedora and I was trying to setup org roam. I did (setq org-roam-database-connector 'sqlite-builtin) but whenever I call org-roam-db-autosync-mode or org-roam-find-node it tells me that the emacsql-sqlite-common file/directory does not exist.
I installed emacsql, emacsql-sqlite, emacsql-sqlite-module and emacsql-sqlite-builtin.
What could be the cause? Thanks in advance
Perhaps your machine is really missing emacs-sqlite-common library – you should be able to check its existence via find-library. My Emacs on Ubuntu has it.
It’s new – added 3 weeks ago. Perhaps Fedora has its own package manager for Emacs, which may not be up-to-date somehow?
If you use the built-in package.el to install Emacs packages, I think you can just update emacsql, emacsql-sqlite and friends. If this does not work, I’d delete the installation and re-install all the emacsql packages.
Other than this, I would not have any idea…
find-library does not find emacsql-sqlite-common.
I tried reinstalling all the packages in emacs but the outcome is the same. I do not have to update emacsql. I can’t delete emacsql-sqlite as it is a dependency of org-roam.
I’m using package.el. The version of emacsql and emacsql-sqlite is 3.1.1.
Writing the message above made me realize that i had emacsql and emacsql-sqlite installed with MELPA stable instead of MELPA. Removing it (or setting lower priority) made it work.