emacsql error on install with use package from melpa: Symbol’s value as variable is void: emacsql-sqlite-reserved

[Trevoke]

emacsql error on install with use package from melpa: Symbol’s value as variable is void: emacsql-sqlite-reserved

[tarsius]

Make sure emacsql and emacsql-sqlite-builtin are up-to-date, restart Emacs and try again. Might fix it, might not.

[Trevoke]

I had installed emacsql-sqlite-builtin for the first time when this happened, so I think it's fair to suggest I was using the most recent code from MELPA build. I don't actually know how to make sure emacsql is up to date, but if it's an external dependency from emacsql-sqlite-builtin then it was also up to date.

[tarsius]

I don't actually know how to make sure emacsql is up to date,

I don't use package.el, so I am not 100% sure either, but M-x package-update-all should do the trick.

but if it's an external dependency from emacsql-sqlite-builtin then it was also up to date.

I don't think you can be sure of that. Due to any version snapshot (such as 19700101) being "greater" than the version specified in emacsql.el (;; Package-Requires: ((emacs "29") (emacsql "3.1.1"))), the dependency is not actually updated unless you run package-update-all.

Also emacsql-sqlite-reserved is defined in emacsql.el.

Side note: I am right now working to improve how EmacSQL is packaged and I plan to soon work on improving the version string format used by Melpa.

[Trevoke]

Okay. No worries. I didn't realize org-roam was operating so far on the bleeding edge and I need my emacs to work, so I'm downgrading back to emacs 28 for now. Sorry about the hassle.

[tarsius]

The problem isn't that Emacs 29.0.60 doesn't work but that emacsql is outdated. (The issue with the format of Melpa snapshot version strings also isn't specific to Emacs 29 release; it's completely unrelated to the Emacs version being used.)

But if I were you I would wait a week or two. As I said I am currently working to change how EmacSQL is packaged. In the future it won't be split into multiple packages. Once that is the case, internal dependencies are guaranteed to be up-to-date.