How can I add the sqlite3 module to Python?

Question

Can someone tell me how to install the sqlite3 module alongside the most recent version of Python? I am using a Macbook, and on the command line, I tried:

pip install sqlite

but an error pops up.

If your python is built from source manually , and meet this error, you should install sqlite-devel package first, then rebuild python, as @falsetru said, the package name will be vary depending on the Operating system. — ngn999
– ngn999, Commented Mar 28, 2016 at 1:54
For everone trying to build python from source and running into this error: This really good answer adresses the bulild process and the dependencys you need. stackoverflow.com/a/6171511/6273503 — Harper
– Harper, Commented Sep 28, 2017 at 8:35

falsetru · Accepted Answer · 2013-10-23 01:03:19Z

361

You don't need to install sqlite3 module. It is included in the standard library (since Python 2.5).

answered Oct 23, 2013 at 1:03

falsetru

371k69 gold badges769 silver badges659 bronze badges

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

8 Comments

shevy Over a year ago

I actually have a python 2.5.4 that does not included sqlite3 :(

falsetru Over a year ago

@user722915, According to What's New in Python 2.5, The pysqlite module (pysqlite.org), a wrapper for the SQLite embedded database, has been added to the standard library under the package name sqlite3.

ngn999 Over a year ago

if your python3 is built from source manually , and meet this error, you should install sqlite-devel package first, then rebuild python3.

falsetru Over a year ago

@ngn999, BTW, the package name will be vary depending on the Operating system. For example, in Ubuntu, it's libsqlite3-dev.

NoName Over a year ago

LITERALLY LIFED MY SAVE!

|

ted · Accepted Answer · 2018-06-25 20:48:15Z

82

For Python version 3:

pip install pysqlite3

edited Jun 25, 2018 at 20:48

ted

14.9k10 gold badges70 silver badges117 bronze badges

answered Jun 25, 2018 at 20:06

Hoss

1,0217 silver badges3 bronze badges

2 Comments

Paulo Carvalho Over a year ago

pysqlite3 is just a wrapper. It won't work if you don't actually have the SQLite libraries in your system (or the devel package if you built Python from sources).

ptn77 Over a year ago

I tried this and it installed, but I still couldn't use it. Any ideas? Here's what it says when I run the command: Preparing metadata (setup.py) ... done Using legacy 'setup.py install' for pysqlite3, since package 'wheel' is not installed. Installing collected packages: pysqlite3 Running setup.py install for pysqlite3 ... done Successfully installed pysqlite3

nicolimo86 · Accepted Answer · 2015-03-10 09:06:58Z

43

I have python 2.7.3 and this solved my problem:

pip install pysqlite

answered Mar 10, 2015 at 9:06

nicolimo86

78812 silver badges22 bronze badges

1 Comment

Phyticist Over a year ago

Consider that this is not applicable to Python 3.

Jonathan Komar · Accepted Answer · 2021-02-07 10:25:45Z

29

Normally, it is included. However, as @ngn999 said, if your python has been built from source manually, you'll have to add it.

Here is an example of a script that will setup an encapsulated version (virtual environment) of Python3 in your user directory with an encapsulated version of sqlite3.

INSTALL_BASE_PATH="$HOME/local"
cd ~
mkdir build
cd build
[ -f Python-3.6.2.tgz ] || wget https://www.python.org/ftp/python/3.6.2/Python-3.6.2.tgz
tar -zxvf Python-3.6.2.tgz

[ -f sqlite-autoconf-3240000.tar.gz ] || wget https://www.sqlite.org/2018/sqlite-autoconf-3240000.tar.gz
tar -zxvf sqlite-autoconf-3240000.tar.gz

cd sqlite-autoconf-3240000
./configure --prefix=${INSTALL_BASE_PATH}
make
make install

cd ../Python-3.6.2
LD_RUN_PATH=${INSTALL_BASE_PATH}/lib configure
LDFLAGS="-L ${INSTALL_BASE_PATH}/lib"
CPPFLAGS="-I ${INSTALL_BASE_PATH}/include"
LD_RUN_PATH=${INSTALL_BASE_PATH}/lib make
./configure --prefix=${INSTALL_BASE_PATH}
make
make install

cd ~
LINE_TO_ADD="export PATH=${INSTALL_BASE_PATH}/bin:\$PATH"
if grep -q -v "${LINE_TO_ADD}" $HOME/.bash_profile; then echo "${LINE_TO_ADD}" >> $HOME/.bash_profile; fi
source $HOME/.bash_profile

Why do this? You might want a modular python environment that you can completely destroy and rebuild without affecting your managed package installation. This would give you an independent development environment. In this case, the solution is to install sqlite3 modularly too.

edited Feb 7, 2021 at 10:25

answered Jun 15, 2018 at 11:24

Jonathan Komar

3,1864 gold badges39 silver badges47 bronze badges

2 Comments

MarkNS Over a year ago

Can also happen if you use pyenv to manage your Python versions, but you didn't have all the system packages installed when the Python interpreter was installed.

Anurag Over a year ago

I had a requirement where I didn't want to disturb the existing python setup. This is exactly what I needed. Thanks !!

Youssri Abo Elseod · Accepted Answer · 2020-10-11 10:38:13Z

7

if you have error in Sqlite built in python you can use Conda to solve this conflict

conda install sqlite

answered Oct 11, 2020 at 10:38

Youssri Abo Elseod

8111 gold badge12 silver badges24 bronze badges

Comments

Ali Samie · Accepted Answer · 2024-06-09 21:30:57Z

2

For Jupyter Notebook and pyenv users I found this: https://github.com/jupyterlab/jupyterlab/issues/4181

So basically sqlite3 did not come with python 3.6 or something of that sort

You need to:

Install libsqlite3-dev

sudo apt install libsqlite3-dev

Reinstall python 3.6 with pyenv

pyenv install 3.6

answered Jun 9, 2024 at 21:30

Ali Samie

5175 silver badges16 bronze badges

Comments

José · Accepted Answer · 2022-11-02 03:37:21Z

0

For Windows + Conda users: you have to download the sqlite3 dll, uncompress and copy the file into the DLL dir in Conda installion path

Check this answer for more detail

answered Nov 2, 2022 at 3:37

José

2,3511 gold badge24 silver badges23 bronze badges

Comments

prtkp · Accepted Answer · 2023-09-05 15:17:19Z

-3

sqlite3 automatically comes with python. You can upgrade python version if you need latest version of sqlite3 or follow steps from https://www.sqlite.org/download.html

answered Sep 5, 2023 at 15:17

prtkp

5701 gold badge6 silver badges9 bronze badges

1 Comment

Martin K. Over a year ago

It depends very much how you install python and on which platform if sqlite3 if included

Collectives™ on Stack Overflow

How can I add the sqlite3 module to Python?

8 Answers 8

8 Comments

2 Comments

1 Comment

2 Comments

Comments

Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

8 Comments

2 Comments

1 Comment

2 Comments

Comments

Comments

Comments

1 Comment

Linked

Related