Install pysqlite in virtualenv with python3 support

Question

I've created virtualenv with:

mkvirtualenv -p /usr/bin/python3.4 django

After, I tried install pysqlite:

pip install pysqlite

But I got:

Downloading/unpacking pysqlite
  Downloading pysqlite-2.6.3.tar.gz (76kB): 76kB downloaded
  Running setup.py (path:/home/sigo/.virtualenvs/django/build/pysqlite/setup.py) egg_info for package pysqlite
    Traceback (most recent call last):
      File "<string>", line 17, in <module>
      File "/home/sigo/.virtualenvs/django/build/pysqlite/setup.py", line 85
        print "Is sphinx installed? If not, try 'sudo easy_install sphinx'."
                                                                           ^
    SyntaxError: invalid syntax
    Complete output from command python setup.py egg_info:
    Traceback (most recent call last):

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

  File "/home/sigo/.virtualenvs/django/build/pysqlite/setup.py", line 85

    print "Is sphinx installed? If not, try 'sudo easy_install sphinx'."

                                                                       ^

SyntaxError: invalid syntax

It seems that pip try use python2. How can I resolve this?

Check that you have pip for python 3. This will be named something like pip-3.2. — Dale Myers
– Dale Myers, Commented Apr 20, 2014 at 10:54
A quick look seems to suggest you need to install pysqlite3 — Dale Myers
– Dale Myers, Commented Apr 20, 2014 at 10:58
That syntax error about the print statement reveals pysqlite is written in Python2, not Python3. sadlly, seems like the @ghaering answer is right. — jgomo3
– jgomo3, Commented Feb 26, 2015 at 14:35

ghaering · Accepted Answer · 2014-05-01 18:34:28Z

10

There is no public version of pysqlite for Python 3.x. For Python 3.x, the sqlite3 module in the standard library is the most up-to date version of pysqlite there is.

answered May 1, 2014 at 18:34

ghaering

3683 silver badges6 bronze badges

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

3 Comments

Karl Bartel Over a year ago

Do you have a suggestion on how to get FTS3/4 support for sqlite3 then? I was hoping to get it by installing a pysqlite with pip.

ghaering Over a year ago

If Python loads a SQLite shared library with FTS3/FTS4 support, then you're fine. The Python sqlite3 module or pysqlite do not need to be recompiled.

ghaering Over a year ago

If you download the latest sqlite-autoconf-* file and install it with ./configure --prefix=/opt/sqlite3 make -j4 install then it is by default built with the fts3 and rtree extensions. You can then export LD_LIBRARY_PATH=/opt/sqlite3/lib and subsequently started Python processes will pick up the just installed sqlite3 library. On Mac, it's DYLD_LIBRARY_PATH instead.

Richard Erickson · Accepted Answer · 2016-04-04 16:14:28Z

1

I'm following this procedure to include the JSON1 extension for SQLite.

When running the

python setup.py install

command for pysqlite within a virtual environment (miniconda) I receive the following output:

pysqlite is not supported on Python 3. When using Python 3, use the sqlite3 module from the standard library.

Setting

export LD_LIBRARY_PATH=~/bin/jqlite/lib

doesn't change this.

edited Apr 4, 2016 at 16:14

Richard Erickson

2,6638 gold badges32 silver badges45 bronze badges

answered Apr 4, 2016 at 15:27

markj

111 bronze badge

1 Comment

markj Over a year ago

My fault. I got confused here. Pysqlite is not needed as I understand and by setting the LD_LIBRARY_PATH within the virtual environment it should be possible to use the JSON1 extension of the sqlite3 module. I will check and provide information on that soon.

Collectives™ on Stack Overflow

Install pysqlite in virtualenv with python3 support

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related