Can't find '_sqlite3' module when import it using python which installed by pyenv

Question

Installed python 3.7.0 by pyenv on macOS.

sqlite3 has been installed:

which sqlite3
/usr/bin/sqlite3

Also tried to install pysqlite3 by pip:

pip install pysqlite3

But can't find module when import sqlite3:

In [1]: import sqlite3
---------------------------------------------------------------------------
ModuleNotFoundError                       Traceback (most recent call last)
<ipython-input-1-5239c6be4108> in <module>
----> 1 import sqlite3

~/.pyenv/versions/3.7.0/lib/python3.7/sqlite3/__init__.py in <module>
     21 # 3. This notice may not be removed or altered from any source distribution.
     22
---> 23 from sqlite3.dbapi2 import *

~/.pyenv/versions/3.7.0/lib/python3.7/sqlite3/dbapi2.py in <module>
     25 import collections.abc
     26
---> 27 from _sqlite3 import *
     28
     29 paramstyle = "qmark"

ModuleNotFoundError: No module named '_sqlite3'

Is it necessary to install a develop library for sqlite3 on macOS by brew?

Jingqiang Zhang · Accepted Answer · 2018-11-03 10:54:34Z

34

This way works:

CFLAGS="-I$(xcrun --show-sdk-path)/usr/include" pyenv install 3.7.0

Ref:

https://github.com/pyenv/pyenv/issues/108#issuecomment-359161050

answered Nov 3, 2018 at 10:54

Jingqiang Zhang

1,0492 gold badges13 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user140345 Over a year ago

what if I'm not on mac and dont have xcrun

James H Over a year ago

github.com/pyenv/pyenv/wiki#suggested-build-environment. ensure sqlite related packages are installed

L Tyrone · Accepted Answer · 2024-05-18 02:33:41Z

0

I found a easy way to fix this if you're using pyenv. Run:

sudo apt install -y make build-essential libssl-dev zlib1g-dev libbz2-dev libreadline-dev libsqlite3-dev wget curl llvm libncursesw5-dev xz-utils tk-dev libxml2-dev libxmlsec1-dev libffi-dev liblzma-dev

Assuming you already have pyenv installed, install a new version of python in pyenv:

pyenv install 3.8.10

(change the python version to whatever you want).

Your new version of python should have the required dependencies like sqlite3.

edited May 18, 2024 at 2:33

L Tyrone

8,36123 gold badges34 silver badges47 bronze badges

answered May 17, 2024 at 0:19

Viraj Nimmagadda

1

1 Comment

snakecharmerb Over a year ago

OP is on MacOS though, so apt is not available

Collectives™ on Stack Overflow

Can't find '_sqlite3' module when import it using python which installed by pyenv

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related