ImportError: No module named '_sqlite3' in

Question

sqlite3 error

import sqlite3
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python3.3/sqlite3/__init__.py", line 23, in <module>
    from sqlite3.dbapi2 import *
  File "/usr/local/lib/python3.3/sqlite3/dbapi2.py", line 26, in <module>
    from _sqlite3 import *
ImportError: No module named '_sqlite3'

i use sqlite3 install command

pip install pysqlite
Downloading/unpacking pysqlite
  Downloading pysqlite-2.6.3.tar.gz (76kB): 76kB downloaded
  Running setup.py egg_info for package pysqlite
    Traceback (most recent call last):
      File "<string>", line 16, in <module>
      File "/usr/local/lib/python3.3/codecs.py", line 300, in decode
        (result, consumed) = self._buffer_decode(data, self.errors, final)
    UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe4 in position 98: invalid continuation byte 
    Complete output from command python setup.py egg_info:
    Traceback (most recent call last):

  File "<string>", line 16, in <module>

  File "/usr/local/lib/python3.3/codecs.py", line 300, in decode

    (result, consumed) = self._buffer_decode(data, self.errors, final)

UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe4 in position 98: invalid continuation byte

----------------------------------------
Cleaning up...
Command python setup.py egg_info failed with error code 1 in /tmp/pip_build_root/pysqlite
Storing complete log in /root/.pip/pip.log

Answer 1

I think it must be you not install sqlite3,you can do like this

 apt-get install sqlite3  
 sqlite3 -version  
 apt-get install python-pysqlite2  
 apt-get install python-pysqlite2-dbg  
 apt-get install libsqlite3-dev   
 apt-get install sqlite  
 pip install pysqlite 

then you will will find the sqlite3

Answer 2

For Python3 in Ubuntu:

• sudo apt-get install libsqlite3-dev
• wget https://www.python.org/ftp/python/3.6.3/Python-3.6.3.tar.xz (replace the version number by your python3 version)
• tar -xf Python-3.6.3.tar.xz
• cd Python-3.6.3/
• ./configure --enable-loadable-sqlite-extensions && make && sudo make install

refer: https://github.com/sloria/TextBlob/issues/173

Answer 3

I am a Fedora 20 user. To solve this:

1. Install sqlite-devel package, using:

   yum install sqlite-devel
   

2. After installing,recompile python from the source using:

   ./configure
   make && make install
   

For multiple versions of Python, use altinstall instead of install.

Answer 4

The compile package is short of something,you should use yum to install these 5,and then recompile and install python3

yum install readline-devel
yum install tk-devel
yum install tcl-devel  
yum install openssl-devel   
yum install sqlite-devel 

and then recompile the python3

tar Jxvf  Python-3.5.0.tar.xz
cd Python-3.5.0
./configure --prefix=/usr/local/python3
make && make install