# The Org-roam v2 Great Migration

**URL:** <https://org-roam.discourse.group/t/the-org-roam-v2-great-migration/1505>\
**Category:** Development\
**Created:** [April 25, 2021, 2:40am UTC](https://org-roam.discourse.group/t/the-org-roam-v2-great-migration/1505 "2021-04-25T02:40:11Z")\
**Posts on this page:** 1\
**Showing post:** 22

<div class="post-metadata">

**Author:** ![efim](https://avatars.discourse-cdn.com/v4/letter/e/e9a140/32.png) [@efim](https://org-roam.discourse.group/u/efim)\
**Post date:** [May 5, 2021, 2:21pm UTC](https://org-roam.discourse.group/t/the-org-roam-v2-great-migration/1505/22 "2021-05-05T14:21:59Z")

</div>

I’ve attempted to update roam to V2 using this guide ( [Hitchhiker's Rough Guide to Org roam V2 · org-roam/org-roam Wiki · GitHub](https://github.com/org-roam/org-roam/wiki/Hitchhiker%27s-Rough-Guide-to-Org-roam-V2) )

I’m using Doom emacs on Linux (NixOS),  
the branch got installed successfuly, I think, but there is a problem with EmacSQL

When I try any new `roam` command (e.g `org-roam-doctor` )  
I get error message  
“emacsql-sqlite-ensure-binary: No EmacSQL SQLite binary available, aborting”  
the `list-packages` seem to include “emacsql” and 4 backends (by default on Doom Emacs?)  
but I still don’t have the binary?

For some reason I could only find questions about ‘emacsql-sqlite’ about Windows systems

Should binary have already been compiled during the package installation?

I do have “sqlite3” installed and available

> λ (executable-find “sqlite3”)  
> /home/efim/.nix-profile/bin/sqlite3

How could I further troubleshoot this?  
Does the error even refer to “emacsql-sqlite” binary?

* * *

My answer:  
I could find lisp funcion in `SPC h f` “emacsql-sqlite-compile”

Trying to call it in eshell with I got Message “missing C compiler”  
So I added “gcc” to available packages

And it seems that evoking (emacsql-sqlite-compile) fixed the problem  
also documentaion said that the binary compilation is attempted at first use,  
so I could have missed the message about lacking C compiler, or maybe there was no warning

---

_[View the full topic](https://org-roam.discourse.group/t/the-org-roam-v2-great-migration/1505)._