# SOLVED: \`emacsql-sqlite3\` no longer available from MELPA

**URL:** <https://org-roam.discourse.group/t/solved-emacsql-sqlite3-no-longer-available-from-melpa/3048>\
**Category:** Troubleshooting\
**Created:** [April 15, 2023, 4:27pm UTC](https://org-roam.discourse.group/t/solved-emacsql-sqlite3-no-longer-available-from-melpa/3048 "2023-04-15T16:27:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JeffBrown](https://yyz2.discourse-cdn.com/free1/user_avatar/org-roam.discourse.group/jeffbrown/32/254_2.png) [@JeffBrown](https://org-roam.discourse.group/u/JeffBrown)\
**Post date:** [April 15, 2023, 4:27pm UTC](https://org-roam.discourse.group/t/solved-emacsql-sqlite3-no-longer-available-from-melpa/3048/1 "2023-04-15T16:27:36Z")

</div>

[irrelevant, deleted]

---

<div class="post-metadata">

**Author:** ![JeffBrown](https://yyz2.discourse-cdn.com/free1/user_avatar/org-roam.discourse.group/jeffbrown/32/254_2.png) [@JeffBrown](https://org-roam.discourse.group/u/JeffBrown)\
**Post date:** [April 15, 2023, 4:50pm UTC](https://org-roam.discourse.group/t/solved-emacsql-sqlite3-no-longer-available-from-melpa/3048/2 "2023-04-15T16:50:18Z")

</div>

[Edit: The following sentence is incorrect.] This seems to mean nobody can install `org-roam` unless they’ve already got a copy of `emacsql-sqlite3`.

Here’s the git log from the Melpa repo for when they deleted `emacsql-sqlite3`:

```auto
commit 769ccff0d4d686bb9444a2a2531b1bc0646c5de4                                      
Author: Jonas Bernoulli <jonas@bernoul.li>                                           
Date: Sat Mar 4 10:58:40 2023 +0100                                                
                                                                                     
    Remove recipe for emacsql-sqlite3
     
    This package won't work with EmacSQL 4.0.0, which also removes the
    need for this.
     
    https://github.com/cireu/emacsql-sqlite3/issues/38

D recipes/emacsql-sqlite3

```

[The github issue](https://github.com/cireu/emacsql-sqlite3/issues/38) mentioned in the comment, suggests that switching to EmacsSQL 4.0.0 shouldn’t be hard, but I don’t understand it.

---

<div class="post-metadata">

**Author:** ![nobiot](https://yyz2.discourse-cdn.com/free1/user_avatar/org-roam.discourse.group/nobiot/32/159_2.png) [@nobiot](https://org-roam.discourse.group/u/nobiot)\
**Post date:** [April 15, 2023, 9:24pm UTC](https://org-roam.discourse.group/t/solved-emacsql-sqlite3-no-longer-available-from-melpa/3048/3 "2023-04-15T21:24:20Z")

</div>

You don’t need emacsql-sqlite3. It’s one of the four options. I have used emacsql-sqlite since the beginning. With Emacs 29, you can use emacsql-sqlite-builtin [even on Windows](https://org-roam.discourse.group/t/sqlite-suport-is-not-available-with-emacs-29-on-windows/2991/14).

---

<div class="post-metadata">

**Author:** ![JeffBrown](https://yyz2.discourse-cdn.com/free1/user_avatar/org-roam.discourse.group/jeffbrown/32/254_2.png) [@JeffBrown](https://org-roam.discourse.group/u/JeffBrown)\
**Post date:** [April 15, 2023, 10:16pm UTC](https://org-roam.discourse.group/t/solved-emacsql-sqlite3-no-longer-available-from-melpa/3048/4 "2023-04-15T22:16:00Z")

</div>

> [@nobiot](#):
>
> emacsql-sqlite-builtin

Haha you’re right! Thank you, @nobiot! I’ll move this from Development to Troubleshooting and mark it as solved.

EDIT: Just to spell things out, what solved this for me was to install`emacsql-sqlite` (by listing it in my NixOS configuration file) and not mention anything about sql in my `.emacs` config file.
