No module named _sqlite3

Question

I am trying to run a Django app on my VPS running Debian 5. When I run a demo app, it comes back with this error:

  File "/usr/local/lib/python2.5/site-packages/django/utils/importlib.py", line 35, in     import_module
    __import__(name)

  File "/usr/local/lib/python2.5/site-packages/django/db/backends/sqlite3/base.py", line 30, in <module>
    raise ImproperlyConfigured, "Error loading %s: %s" % (module, exc)

ImproperlyConfigured: Error loading either pysqlite2 or sqlite3 modules (tried in that     order): No module named _sqlite3

Looking at the Python install, it gives the same error:

Python 2.5.2 (r252:60911, May 12 2009, 07:46:31) 
[GCC 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python2.5/sqlite3/__init__.py", line 24, in <module>
    from dbapi2 import *
  File "/usr/local/lib/python2.5/sqlite3/dbapi2.py", line 27, in <module>
    from _sqlite3 import *
ImportError: No module named _sqlite3
>>>

Reading on the web, I learn that Python 2.5 should come with all the necessary SQLite wrappers included. Do I need to reinstall Python, or is there another way to get this module up and running?

Same problem is for compiled python 3.5.5 from source – Alex-Bogdanov Mar 14 '18 at 15:53 — Alex-Bogdanov, Mar 14 '18 at 15:53

score 262 · Answer 1 · edited Aug 17 '18 at 09:42

262

It seems your makefile didn't include the appropriate .so file. You can correct this problem with the steps below:

Install sqlite-devel (or libsqlite3-dev on some Debian-based systems)
Re-configure and re-compiled Python with ./configure --enable-loadable-sqlite-extensions && make && sudo make install

Note

The sudo make install part will set that python version to be the system-wide standard, which can have unforseen consequences. If you run this command on your workstation, you'll probably want to have it installed alongside the existing python, which can be done with sudo make altinstall.

edited Aug 17 '18 at 09:42

Arne

17,706
5
83
99

answered Jun 27 '14 at 10:28

jammyWolf

2,743
1
13
7

Thanks jammyWolf. I don't think that I "lost" the file after the first time that I ran configure, rather, that running configure with sqlite-devel already installed made all of this difference. – Jeff Taylor Apr 08 '15 at 16:15
The configuration saved me "./configure --enable-loadable-sqlite-extensions" – ybdesire Jan 18 '16 at 08:01
4

How can I install ```sqlite-devel``` ? I'm on a customized linux system.I just downloaded ```sqlite-autoconf-3100200.tar.gz``` and run ```./configure```,```make && make install```. After I recompile python3 it's still not working. – AntiMoron Jan 26 '16 at 02:27
2

For anyone reading this, make sure to add the configure option in the answer. That's what saved me too. Otherwise it won't matter that you've installed libsqlite3-dev. – ticster Jul 21 '16 at 15:55
7

how do I check where the configure script is? – Jenna Kwon Dec 27 '16 at 04:33
Thanks for that. Also followed the following reddit post to compile Python: https://www.reddit.com/r/Python/comments/5unkb3/install_sqlite3_on_python_3/ddzdz2b/ – Doezer May 24 '17 at 14:01
Thanks a lot. I only had to re-download and execute `./configure --enable-loadable-sqlite-extensions && make && sudo make install` Worked! – Ph03n1x Aug 09 '17 at 09:19
18

I am using `pyenv` and after installing `libsqlite3-dev` I had to re-install your python version with `pyenv install `. – botchniaque Mar 08 '18 at 13:00
I had to install libsqlite3-dev on ubuntu 14.04, followed by step 2. Worked like a charm - thank you. – kaykae Feb 26 '19 at 03:07
If I use `python 3,6 ` mean to say `pipenv --python 3.6` when creating the virtual environment then the problem gets solved. – squal Dec 08 '19 at 19:25
4

none of these solutions (ref: all on this page) work for amazon linux with python 3.8.0 – bgenchel Apr 09 '20 at 08:25
Continued to fail for me because I had built sqlite3 in a custom dir. To fix I had to edit Python3's setup.py file. Look for sqlite_inc_paths assignment. Add your sqlite3 include dir to the list. That's was my last stumbling block. – JohnMudd Jan 20 '21 at 23:39
For the actual working name (Debian-based distros), search for sqlite3 and dev packages like: `sudo apt-cache search sqlite3 | grep dev`, then you will find the "correct" name. For me it was `libsqlite3-dev` thus I did **`sudo apt install libsqlite3-dev`** – Olivier Pons Jun 11 '21 at 07:52
2

This works for me. Centos 8, python 3.8.8 follow this one to install python3.8 https://computingforgeeks.com/how-to-install-python-3-on-centos/ 1. execute `yum install sqlite-devel` 2. go to the python source code(where you download) Re-configure and re-compiled Python with `./configure --enable-loadable-sqlite-extensions && make && sudo make install` – penny chan Nov 21 '21 at 06:59
Works with pytho3.10 & RedHat 8.5. – Arpad Horvath -- Слава Україні Feb 24 '22 at 18:48
I had install python3.8, and beause this problem I reinstall python3.8 as above, and then my system have two python3.8, one of that contain sqlite3 and another not contain sqlite3, @AntiMoron ,"whereis python" can get python path – Steve Jiang Sep 18 '22 at 15:59
Im using python3.7.13 on redhat linux distribution on Aws. Is there specific version of `sqlite-devel` that I need to install? I need to send info to another team so they can install for me. – haneulkim Apr 25 '23 at 07:18

score 93 · Answer 2 · edited Oct 21 '21 at 09:52

93

I had the same problem with Python 3.5 on Ubuntu while using pyenv.

If you're installing the python using pyenv, it's listed as one of the common build problems. To solve it, remove the installed python version, install the requirements (for this particular case libsqlite3-dev), then reinstall the python version with

pyenv install <python-version>

Then recreate virtualenv if needed.

edited Oct 21 '21 at 09:52

Danil

4,781
1
35
50

answered Aug 09 '16 at 05:17

Tiny Instance

2,351
17
21

4

It's not required to remove the installed version, `pyenv install ` will ask whether it should be overridden and re-compiles. – kap Jan 04 '22 at 21:11
I used pyenv too and this works for me. Have to reinstall the whole environment so that the change will take effect. Remember to install libsqlite3-dev before that. – Quang Hoàng Minh Dec 06 '22 at 02:19

score 88 · Answer 3 · answered Apr 30 '10 at 19:46

88

I had the same problem (building python2.5 from source on Ubuntu Lucid), and import sqlite3 threw this same exception. I've installed libsqlite3-dev from the package manager, recompiled python2.5, and then the import worked.

answered Apr 30 '10 at 19:46

Emilien

2,971
2
22
32

6

Exactly! You don't have to manually manipulate with binary files and environment. In my case I had already Python 2.7 built from source, so, to minify compilation I've executed apt-get install libsqlite3-dev; ./configure; make libinstall; make sharedinstall; – oxfn Sep 10 '13 at 14:06

score 38 · Answer 4 · answered Oct 15 '19 at 09:09

38

my python is build from source, the cause is missing options when exec configure python version：3.7.4

./configure --enable-loadable-sqlite-extensions --enable-optimizations
make
make install

fixed

answered Oct 15 '19 at 09:09

Robin

543
1
6
12

Didn't work. bash: ./configure: No such file or directory – Quang Hoàng Minh Dec 05 '22 at 14:22
i mean execute this command in the python source directory, like this:https://github.com/python/cpython – Robin Dec 05 '22 at 15:05
You should cd to your python source directory and in the directory use the `./configure` command @QuangHoàngMinh – Arco May 16 '23 at 18:33

score 31 · Answer 5 · edited Dec 07 '15 at 09:41

31

Install the sqlite-devel package:

yum install sqlite-devel -y
Recompile python from the source:
```
./configure
make
make altinstall
```

edited Dec 07 '15 at 09:41

Nat Dempkowski

2,331
1
19
36

answered Dec 07 '15 at 08:50

John Zhang

611
6
7

5

I did 1(yum install sqlite-devl -y) this was okay. in #2, I got this err `bash: ./configure: No such file or directory`. How can I fix. – jis0324 Jan 08 '21 at 17:21
Taking a lot of time on make command. What exactly this does? Is it recompiling the centOS kernel or what? – Raymond Mar 18 '21 at 18:14
This worked for me, I'm using CENTOs 7, and Python 3.8.14. Thank you. – aletelecomm Oct 03 '22 at 22:13

score 29 · Answer 6 · answered Nov 02 '13 at 23:40

29

This is what I did to get it to work.

I am using pythonbrew(which is using pip) with python 2.7.5 installed.

I first did what Zubair(above) said and ran this command:

sudo apt-get install libsqlite3-dev

Then I ran this command:

pip install pysqlite

This fixed the database problem and I got confirmation of this when I ran:

python manager.py syncdb

answered Nov 02 '13 at 23:40

Joe

3,120
3
25
30

2

in Centos 6.5 run `yum install sqlite-devel` instead of the first line. – Ehsan88 Aug 16 '14 at 10:32
3

That's good for Python 2, but `pysqlite` is now `sqlite3` in Python 3, and you can't `pip -m install` that. – clabe45 Mar 23 '18 at 23:51
9

`pysqlite is not supported on Python 3. When using Python 3, use the sqlite3 module from the standard library` – tread Jun 10 '18 at 14:00
@Joe I think it should be manage.py instead of manager.py – Vinay Kumar Jan 03 '22 at 12:53

score 19 · Answer 7 · answered Oct 16 '20 at 08:21

19

For Python 3.7.8 with Redhat 7 or Centos 7.

Install sqlite-devel

$ yum install sqlite-devel

Compile and install Python3 with sqllite extensions

$ ./configure --enable-optimizations --enable-loadable-sqlite-extensions
$ make install

answered Oct 16 '20 at 08:21

Gara Walid

415
4
5

can confirm this works with 3.10.8 – vencaslac Nov 14 '22 at 15:19
This also worked on Amazon Linux 2 base image, thanks! – the-lay Jan 27 '23 at 13:11

score 14 · Answer 8 · edited Apr 18 '17 at 12:03

14

I found lots of people meet this problem because the Multi-version Python, on my own vps (cent os 7 x64), I solved it in this way:

Find the file "_sqlite3.so"
```
find / -name _sqlite3.so
```
out: /usr/lib64/python2.7/lib-dynload/_sqlite3.so
Find the dir of python Standard library you want to use,

for me /usr/local/lib/python3.6/lib-dynload

Copy the file:

cp   /usr/lib64/python2.7/lib-dynload/_sqlite3.so /usr/local/lib/python3.6/lib-dynload

Finally, everything will be ok.

edited Apr 18 '17 at 12:03

Martin Evans

45,791
17
81
97

answered Apr 18 '17 at 11:51

Ehco

157
1
2

7

Didn't work for me. Got `ImportError: dynamic module does not define module export function (PyInit__sqlite3)` on CentOS 7. – xtluo Aug 12 '19 at 07:04
same to me, is that py2 `.so` can't be used for py3.6.4? @xtluo – MeadowMuffins Apr 08 '20 at 09:23
I got this error instead - `ImportError: libpython2.7.so.1.0: cannot open shared object file: No such file or directory` – bgenchel Apr 09 '20 at 08:30
Seems to work for me: sudo cp /usr/lib64/python3.6/lib-dynload/_sqlite3.cpython-36m-x86_64-linux-gnu.so /usr/local/lib/python3.7/lib-dynload/_sqlite3.so. Now I can run tensorboard without the _sqlite3 error! Thx – John Jiang Nov 24 '21 at 07:56

score 11 · Answer 9 · answered Jul 31 '09 at 04:50

11

My _sqlite3.so is in /usr/lib/python2.5/lib-dynload/_sqlite3.so. Judging from your paths, you should have the file /usr/local/lib/python2.5/lib-dynload/_sqlite3.so.

Try the following:

find /usr/local -name _sqlite3.so

If the file isn't found, something may be wrong with your Python installation. If it is, make sure the path it's installed to is in the Python path. In the Python shell,

import sys
print sys.path

In my case, /usr/lib/python2.5/lib-dynload is in the list, so it's able to find /usr/lib/python2.5/lib-dynload/_sqlite3.so.

answered Jul 31 '09 at 04:50

Glenn Maynard

55,829
10
121
131

2

just checked. the path is in there, but _sqlite3.so is indeed missing. Any suggestions whether i can seperately install it or better to reinstall python? thx! – Alexander van Dijk Jul 31 '09 at 05:02
2

It looks like you built and installed Python manually (are the packages in your OS too old?), since it's in /usr/local. Make sure that the sqlite dev package is installed (libsqlite3-dev in current distros, maybe not in yours), or Python won't be able to build the module. If you install it, you'll need to rebuild Python so it includes that module. – Glenn Maynard Jul 31 '09 at 05:39
Hmm, I installed libsqlite3-dev and rebuild python, but now i get anothe error: ImportError: ./_sqlite3.so: undefined symbol: PyUnicodeUCS4_DecodeUTF8 – Alexander van Dijk Jul 31 '09 at 06:01
I'm confused. Your distro has Python 2.5 already (http://packages.debian.org/lenny/python2.5). Why are you building it yourself? – Glenn Maynard Jul 31 '09 at 07:01
ah, sorry, wrong choice of words. in fact i re-installed python2.5 via apt-get. – Alexander van Dijk Jul 31 '09 at 18:03
1

But you're running Python out of /usr/local. It looks like you installed Python twice--once yourself and once with apt-get, and the one in /usr/local is broken. – Glenn Maynard Jul 31 '09 at 18:36

score 9 · Answer 10 · edited Jul 16 '11 at 06:37

I recently tried installing python 2.6.7 on my Ubuntu 11.04 desktop for some dev work. Came across similar problems to this thread. I mamaged to fix it by:

Adjusting the setup.py file to include the correct sqlite dev path. Code snippet from setup.py:

def sqlite_incdir:
sqlite_dirs_to_check = [
os.path.join(sqlite_incdir, '..', 'lib64'),
os.path.join(sqlite_incdir, '..', 'lib'),
os.path.join(sqlite_incdir, '..', '..', 'lib64'),
os.path.join(sqlite_incdir, '..', '..', 'lib'),
'/usr/lib/x86_64-linux-gnu/'
]

With the bit that I added being '/usr/lib/x86_64-linux-gnu/'.

After running make I did not get any warnings saying the sqlite support was not built (i.e., it built correctly :P ), but after running make install, sqlite3 still did not import with the same "ImportError: No module named _sqlite3" whe running "import sqlite3".

So, the library was compiled, but not moved to the correct installation path, so I copied the .so file (cp /usr/src/python/Python-2.6.7/build/lib.linux-x86_64-2.6/_sqlite3.so /usr/local/python-2.6.7/lib/python2.6/sqlite3/ — these are my build paths, you will probably need to adjust them to your setup).

Voila! SQLite3 support now works.

Thank you! Just the first part was needed for Linux Mint Debian Edition, 2014 — spookylukey, Mar 17 '14 at 17:02
Thank you! Exactly same problem for me. The library is built but not copied to the right directory. — Student222, Jan 09 '17 at 22:15

score 8 · Answer 11 · answered Aug 16 '14 at 10:31

8

This worked for me in Redhat Centos 6.5:

yum install sqlite-devel
pip install pysqlite

answered Aug 16 '14 at 10:31

Ehsan88

3,569
5
29
52

1

just fyi I did not need to do the pip step – Kermit Mar 07 '20 at 20:54
2

```pip install pysqlite3-binary``` worked instead of ```pip install pysqlite3``` – Abhilash Singh Chauhan Jul 11 '22 at 11:57

score 5 · Answer 12 · edited Jul 18 '18 at 11:38

5

sqlite3 ships with Python. I also had the same problem, I just uninstalled python3.6 and installed it again.

Uninstall existing python:

sudo apt-get remove --purge python3.6

Install python3.6:

sudo apt install build-essential checkinstall
sudo apt install libreadline-gplv2-dev libncursesw5-dev libssl-dev libsqlite3-dev tk-dev libgdbm-dev libc6-dev libbz2-dev
wget https://www.python.org/ftp/python/3.6.0/Python-3.6.0.tar.xz
tar xvf Python-3.6.0.tar.xz
cd Python-3.6.0/
./configure
sudo make altinstall

edited Jul 18 '18 at 11:38

hidefromkgb

5,834
1
13
44

answered Jul 18 '18 at 11:15

Mastan Basha Shaik

144
1
5

Works well on Debian Buster – emilie zawadzki Oct 25 '21 at 16:09

bryan · Answer 13 · 2009-07-31T04:56:35.563

4

Is the python-pysqlite2 package installed?

sudo apt-get install python-pysqlite2

edited Jul 31 '09 at 04:56

answered Jul 31 '09 at 04:23

bryan

2,223
1
22
19

1

sqlite is installed with Python; you don't need to install a separate package for it, and we can tell that he does already have the Python-supplied library. Installing python-sqlite would be confusing at best. – Glenn Maynard Jul 31 '09 at 04:47
Brain cramp. I meant the python-pysqlite2 package. I could not get Django/sqlite to work on lenny without this package. I've updated my answer. – bryan Jul 31 '09 at 04:58
I have python-pysqlite2 installed. – Alexander van Dijk Jul 31 '09 at 05:04

tosky · Answer 14 · 2022-12-27T10:11:50.907

4

i got the same problem, nothing worked for me from the above ans but now i fixed it by

just remove python.pip and sqlite3 and reinstall

sudo apt-get remove python.pip
sudo apt-get remove sqlite3

now install it again

sudo apt-get install python.pip
sudo apt-get install sqlite3

in my case while installing sqlite3 again it showed some error then i typed

sqlite3

on terminal to check if it was removed or not and it started unpacking it

once the sqlite3 is installed fireup terminal and write

sqlite3
database.db (to create a database) i'm sure this will definately help you

edited Dec 27 '22 at 10:11

answered Mar 14 '18 at 08:37

tosky

41
3

Does not work on Ubuntu, Python 3.7.10, Jupyter 6.1.5 – Steve Gon Apr 18 '21 at 19:44

score 3 · Answer 15 · edited Jan 07 '10 at 09:39

3

Checking your settings.py file. Did you not just write "sqlite" instead of "sqlite3" for the database engine?

edited Jan 07 '10 at 09:39

Peter Mortensen

30,738
21
105
131

answered Oct 20 '09 at 15:29

myselfhimself

31
1

score 3 · Answer 16 · answered Mar 07 '20 at 05:33

Putting answer for anyone who lands on this page searching for a solution for Windows OS:

You have to install pysqlite3 or db-sqlite3 if not already installed. you can use following to install.

pip install pysqlite3
pip install db-sqlite3

For me the issue was with DLL file of sqlite3.

Solution:

I took DLL file from sqlite site. This might vary based on your version of python installation.
I pasted it in the DLL directory of the env. for me it was "C:\Anaconda\Lib\DLLs", but check for yours.

I had the exact error. This somehow solved my problem. Thanks! — uqji, May 07 '20 at 14:14

score 3 · Answer 17 · answered May 06 '20 at 12:08

I was disappointed this issue still exist till today. As I have recently been trying to install vCD CLI on CentOS 8.1 and I was welcomed with the same error when tried to run it. The way I had to resolve it in my case is as follow:

Install SQLite3 from scratch with the proper prefix
Make clean my Python Installation
Run Make install to reinstall Python

As I have been doing this to create a different blogpost about how to install vCD CLI and VMware Container Service Extension. I have end up capturing the steps I used to fix the issue and put it in a separate blog post at:

http://www.virtualizationteam.com/cloud/running-vcd-cli-fail-with-the-following-error-modulenotfounderror-no-module-named-_sqlite3.html

I hope this helpful, as while the tips above had helped me get to a solution, I had to combine few of them and modify them a bit.

Thank you for disclosing your affiliation with the link you are providing! It is appreciated. — Robert Columbia, May 06 '20 at 12:10

score 3 · Answer 18 · answered Oct 14 '21 at 03:54

I had the same problem after installing Python 3.8.11 using asdf

To fix the issue:

I had to install libsqlite3-dev

sudo apt-get install libsqlite3-dev

Then uninstall Python via asdf

asdf uninstall python 3.8.11

And install Python again via asdf

asdf install python 3.8.11

score 2 · Answer 19 · edited May 01 '14 at 19:58

2

you must be in centos or redhat and compile python yourself， it is python‘s bug do this in your python source code dir and do this below

curl -sk https://gist.github.com/msabramo/2727063/raw/59ea097a1f4c6f114c32f7743308a061698b17fd/gistfile1.diff | patch -p1

edited May 01 '14 at 19:58

Oben Sonne

9,893
2
40
61

answered Jan 07 '14 at 03:13

wolfkdy

21
1

score 2 · Answer 20 · answered Dec 21 '20 at 10:27

2

Try installing sqlite like this if you are using FreeBSD.

pkg install py27-sqlite3-2.7.10_6

answered Dec 21 '20 at 10:27

Akshat Maheshwari

21
3

score 2 · Answer 21 · answered Feb 02 '22 at 19:59

The following worked for Python 3.9 with a virtual environment:

Install the sqlite3 library.
```
sudo apt-get install libsqlite3-dev
```
Activate the Python virtual environment.
```
source env/bin/activate
```

Copy the sqlite3 file into the Python virtual environment and rename it to support Python 3.9.

cp /usr/lib/python3.8/lib-dynload/_sqlite3.cpython-38-x86_64-linux-gnu.so ./env/lib/python3.9/site-packages
mv ./env/lib/python3.9/site-packages/_sqlite3.cpython-38-x86_64-linux-gnu.so ./env/lib/python3.9/site-packages/_sqlite3.cpython-39-x86_64-linux-gnu.so

Note, we're renaming 38 to 39 in the file name to support Python 3.9.

score 2 · Answer 22 · edited Oct 13 '11 at 13:56

2

I have the problem in FreeBSD 8.1:

- No module named _sqlite3 -

It is solved by stand the port ----------

/usr/ports/databases/py-sqlite3

after this one can see:

OK ----------
'>>>' import sqlite3 -----
'>>>' sqlite3.apilevel -----
'2.0'

edited Oct 13 '11 at 13:56

answered Aug 29 '11 at 23:40

george

101
1

15

This answer makes very little sense. Can you revise it? – Tim Post Aug 30 '11 at 06:51
I had same issue, FreeBSD 8.2 w/Py2.7.2. Resolved by just running through make/install again, for py-sqlite3. – Justin Nov 02 '11 at 22:59
you have to make deinstall if it seems installed at first. freebsd 10.2 – Kunthar Mar 18 '16 at 08:36

score 1 · Answer 23 · answered Feb 22 '22 at 16:25

I faced this issue with multiple python dependent package while setup in python virtual enironment in Ubuntu.It is because of sqlite binding for our python.

Error I got:

    from pysqlite2 import dbapi2 as sqlite3
ModuleNotFoundError: No module named 'pysqlite2'

I resolved it by --enable-loadable-sqlite-extensions=yes 1.) First find your python or python version you used for creating virtual env. I have used python3.8 e.g

$ whereis python
python: /usr/bin/python3.6m /usr/bin/python /usr/bin/python3.8 /usr/bin/python2.7-config /usr/bin/python3.8-config  python

$ cd /usr/bin

$ls
python3.8
python3.8-config

Note: there will be many package check for pytho. you will find configure file for each python version, now use specific python version

ox:/usr/bin$ ./python3.8-config --enable-loadable-sqlite-extensions=yes

OR

ox:/usr/bin$ ./python3.8-config --enable-optimizations --enable-loadable-sqlite-extensions

Now, create your virtual env using that python version e.g Go the folder where you want to create the virtual env

$ python3.8 -m venv mlwen_jup_env
$ source mlwen_jup_env/bin/activate

Its done, now you can install packages

score 1 · Answer 24 · answered Oct 31 '22 at 16:10

I ran into this same problem on a NetBSD server. A missing .so file needed to be installed using pkgin. To identify what package to install, I ran

pkgin search sqlite

which had lots of results, including

...

py38-aiosqlite-0.17.0nb1  Async bridge to the standard sqlite3 module
py38-apsw-3.37.0nb2  Python wrapper for SQLite
py38-peewee-3.15.0   Small, expressive ORM for PostgreSQL, MySQL and SQLite
py38-sqlite3-3.8.13nb22  Built-in sqlite support for Python 2.5 and up
py39-aiosqlite-0.17.0nb1  Async bridge to the standard sqlite3 module
py39-apsw-3.37.0nb2  Python wrapper for SQLite
py39-peewee-3.15.0   Small, expressive ORM for PostgreSQL, MySQL and SQLite
py39-sqlite3-3.9.13nb22  Built-in sqlite support for Python 2.5 and up
...

(and other python versions as well). I'm using python 3.9, so py39-sqlite3-3.9.13nb22 was the correct choice in my case. Running

sudo pkgin install py39-sqlite3-3.9.13nb22

fixed the issue for me.

NetBSD does not necessarily come with `pkgin` preinstalled. This page has the official instructions for installing `pkg_add` and then `pkgin`: https://www.netbsd.org/docs/pkgsrc/using.html — Alex Grounds, Dec 05 '22 at 16:38

score 0 · Answer 25 · edited Oct 18 '16 at 12:34

0

Download sqlite3:

wget http://www.sqlite.org/2016/sqlite-autoconf-3150000.tar.gz

Follow these steps to install:

$tar xvfz sqlite-autoconf-3071502.tar.gz
$cd sqlite-autoconf-3071502
$./configure --prefix=/usr/local
$make install

edited Oct 18 '16 at 12:34

Khris

3,132
3
34
54

answered Oct 18 '16 at 11:27

Narendra Kumar

29

1

This question was asked in 2009 and was about Debian 5. sqlite3 is now [available in the repos](https://packages.debian.org/wheezy/sqlite3) (since Wheezy) so there is no need to install it manually. I guess this is true for most distros as well. – Jérôme Oct 18 '16 at 11:55

score -3 · Answer 26 · answered Sep 20 '13 at 08:25

-3

You need to install pysqlite in your python environment:

    $ pip install pysqlite

answered Sep 20 '13 at 08:25

Darwin M.

25
4

score -4 · Answer 27 · edited Sep 02 '18 at 02:57

-4

Try copying _sqlite3.so so that Python can find it.

It should be as simple as:

cp /usr/lib64/python2.6/lib-dynload/_sqlite3.so /usr/local/lib/python2.7/

Trust me, try it.

edited Sep 02 '18 at 02:57

James Lim

12,915
4
40
65

answered Sep 02 '18 at 01:46

sen john

9
1

No module named _sqlite3

27 Answers27

Linked

Related