pyenv no module named '_sqlite3'
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

I've been trying to adopt pyenv for a few months, but have been completely blocked by this issue on one of the main machines I use. Whenever I start up...

Date: May 31, 2022

I’ve been trying to adopt pyenv for a few months, but have been completely blocked by this issue on one of the main machines I use. Whenever I start up ipython I get the following error.

[38;2;122;132;120m[code][0m
  ImportError: No module named '_sqlite3

I talked about why and how to use pyenv along with my first impressions in [4m[38;2;127;187;179mthis post[0m <[38;2;122;132;120m/til/pyenv-first-impressions[0m>

[1m[38;2;167;192;128mpyenv/issues/678[0m
[38;2;71;82;88m────────────────[0m

According to [4m[38;2;127;187;179m#678[0m <[38;2;122;132;120mhttps://github.com/pyenv/pyenv/issues/678[0m> I need to install [38;2;167;192;128mlibsqlite3-dev[0m on ubuntu to resolve this issue.

[1m[38;2;167;192;128minstall libsqlite3-dev[0m
[38;2;71;82;88m──────────────────────[0m

[38;2;167;192;128mlibsqlite3-dev[0m can be installed using apt

[38;2;122;132;120m[code][0m
  sudo apt install libsqlite3-dev

[1m[38;2;167;192;128mBut wait….[0m
[38;2;71;82;88m──────────[0m

When I make a fresh env and install ipython I still get the same error and I am still not able to use ipython with pyenv.

[38;2;122;132;120m[code][0m
  ImportError: No module named '_sqlite3

[1m[38;2;167;192;128mre-install python[0m
[38;2;71;82;88m─────────────────[0m

After having this issue for awhile an coming back to [4m[38;2;127;187;179m#678[0m <[38;2;122;132;120mhttps://github.com/pyenv/pyenv/issues/678[0m> several times I realized that [38;2;167;192;128mlibsqlite3-dev[0m needs to be installed while during install.

[38;2;122;132;120m[code][0m
  pyenv install 3.8.13

I think I had tried this several times, but was missing the [38;2;167;192;128m-y[0m option each time. You gotta read errors like this, I am really good at glossing over them.

Image: pyenv-install-exists.webp <https://dropper.waylonwalker.com/api/file/017121e2-1f51-4910-bfce-86813a7f90a3.webp>

[1m[38;2;167;192;128mLet’s never have this issue again.[0m
[38;2;71;82;88m──────────────────────────────────[0m

When you spend months living with little errors like this and finally fix it, its good to make sure that it never happens again. Whenever I start a new ubuntu machine I run an ansible playbook that does all the setup for me. I added [38;2;167;192;128mlibsqlite3-dev[0m to my core install in [4m[38;2;127;187;179m64c85ca[0m <[38;2;122;132;120mhttps://github.com/WaylonWalker/devtainer/commit/64c85ca1b38eefe95dfc8723c1e83e8e334cf4dc[0m> now it will be on all of my machines and not break again.