Emacs 29 does have builtin-sqlite support. But maybe I misunderstand that? I tried to run Emacs 29 (from here ) Windows 10. But I got the error “sqlite support is not available”. I didn’t install anything sqlite relevant componten in that Windows because I assume Emacs 29 now can handle that by its…

[image] buhtz: I tried to run Emacs 29 (from here ) Windows 10. But I got the error “sqlite support is not available”. SQLite3 support is a compilation option, so these binaries may not have it in. Have a look at variable system-configuration-features; if SQLITE3 does not appear, your Emacs b…

The value of “system-configuration-features” is “ACL GIF GMP GNUTLS HARFBUZZ JPEG JSON LCMS2 LIBXML2 MODULES NATIVE_COMP NOTIFY W32NOTIFY PDUMPER PNG RSVG SOUND SQLITE3 THREADS TIFF TOOLKIT_SCROLL_BARS WEBP XPM ZLIB” Seems OK, or not? What could it be then?

Then I would say you needed to install the package as described in the document string . If you are using Emacs 29, then the recommended connector is sqlite-builtin', which uses the new builtin support for SQLite. You need to install the emacsql-sqlite-builtin’ package to use this connector.

sqlite-builtin is the deault connector on Emacs29. No need for anything. That is why I do test it with Emacs 29. :wink: I assume the sqlite library is not installed on windows. But I don’t know where to copy the dlls into. Because sqlite doesn’t come with an installer.

[image] nobiot: emacsql-sqlite-builtin Is an elisp package that is available on ELPA or MELPA (please check) — I think it’s part of emacsql on MELPA. No need for dll i believe

The only difference is you don’t need to compile a C file (a sqlite file) . You still need the Elisp package that utilizes built-in sqlite for Org-roam. I don’t know my description of English language is precise, but that’s what the documentation says and what I do for Linux, which works.

I still do (use-package emacsql-sqlite-builtin). Please see my init file in my initial post.

Then I have run out of ideas. I will try version 29 on Windows when I get back to my computer. If the built-in function sqlite-mode-open-file does not let you inspect ~/.emacs.d/org-roam.db, then the built-in SQLite may not be working properly, and you might like to report it to emacs development m…

Tried emacs-29.0.60-installer.exe (2023-02-19 12:55 75M) from the site you referred to above. Function sqlite-available-p returns nil, so no built-in sqlite support is available in this binary.

Hi there! I create and publish the Windows binary installers/zips of Emacs currently. I agree that there’s no sqlite DLL provided with the current Emacs 29 pre-release snapshot. I do plan to try updating the packaging environment and process to build that along with the rest of the DLLs that end u…

"sqlite suport is not available" with Emacs 29 on Windows

Troubleshooting

nobiot March 27, 2023, 12:43pm 18

Responded to another thread. If your question is for Windows, then corwin might be able to assist; my experience is Ubuntu.

Topic		Replies	Views
Sqlite now in Emacs distribution Development	9	1727	March 27, 2023
Sqlite-open Symbol’s function definition is void Troubleshooting	8	1062	April 4, 2024
Emacs does not find package `emacsql-sqlite3` Troubleshooting	6	178	February 18, 2025
Emacs 29 and org-roam-database-connector set to 'sqlite-builtin, but "emacs-sqlite-common" does not exist Troubleshooting	3	1483	March 15, 2023
Emacsql-sqlite not running Troubleshooting	2	460	November 22, 2023

"sqlite suport is not available" with Emacs 29 on Windows

Related topics