6

V2 Binary emacsql sqlite.exe for Windows

nobiot edited this page 2023-03-11 13:30:18 +01:00

Updte on 2023-03-11

This newly compiled Windows binary comes with SQLite support compiled in. It has been reported that it works with Org-roam. emacs-29.0.60_1-installer.exe 2023-03-10 13:25 69M

Ensure the following:

• Function sqlite-available-p returns t (to confirm that SQLite built-in support in your Emacs is available)
• Install emacs-sqlite-builtin (in addition to org-roam and its dependencies, which include emacs-sqlite)
• User option org-roam-database-connector is set to sqlite-builtin (this should be the default if you meet the conditions above)

With emacs-sqlite-builtin, you will not need to compile emacsql-sqlite.exe (effectively, the information in this page will be superseded).

---

Org-roam V2 relies on a package named emacsql-sqlite, which requires a facility to build (compile from source) an executable. It is anticipated that many Windows users struggle to do so on their own.

At this location: https://github.com/nobiot/emacsql-sqlite.exe, you will find a brief instruction on how you might do it yourself.

It's actually easy, quick and automated (after a bit of reading and preparation).

Set aside 45-120 minutes of focus time.

This is the recommended way.

If you really struggle to do this on your own, you can also choose to download a copy of binary executable I built and use everyday on my Windows machine. However, note that you will need to have the same CPU architecture as mine (x86-64) and (probably) run the 64-bit version of Windows as noted in the repository.

⚠⚠ No guarantee, no support when it does not work or break anything. Use the binary at your own risk. ⚠⚠