python import sqlite error

Question

python2.7 and sqlite3 were installed by homebrew on macos 10.8
pysqlite is installed by pip

when I type import sqlite3 in python interapter, it show errors below:

>>> import sqlite3
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/Cellar/python/2.7.3/Frameworks/Python.framework/Versions/2.7/lib/python2.7/sqlite3/__init__.py", line 24, in <module>
from dbapi2 import *
  File "/usr/local/Cellar/python/2.7.3/Frameworks/Python.framework/Versions/2.7/lib/python2.7/sqlite3/dbapi2.py", line 27, in <module>
from _sqlite3 import *
ImportError: dlopen(/usr/local/Cellar/python/2.7.3/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynload/_sqlite3.so, 2): Library not loaded: /usr/local/lib/libsqlite3.0.8.6.dylib
  Referenced from: /usr/local/Cellar/python/2.7.3/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynload/_sqlite3.so
  Reason: image not found

how to correct that error?

On my Mac Python 2.7, pysqlite and Sqlite 3 are installed by default. Couldn't you use those? — uselpa
– uselpa, Commented Mar 24, 2013 at 7:28
Why do you install a new version of Python when there are already Pyhon 2.7 installed by default ? It is a problem of Homebrew — gene
– gene, Commented Mar 24, 2013 at 9:16
@gene: because the Python that comes with OS X is usually a few minor versions behind the latest one. — Erik Kaplun
– Erik Kaplun, Commented Oct 4, 2013 at 20:06

Erik Kaplun · Accepted Answer · 2013-10-14 11:31:54Z

7

The solution is to uninstall both the sqlite as well as python kegs:

brew rm sqlite python

and then reinstall Python (which also installs SQLite3 as its dependency):

brew install python

edited Oct 14, 2013 at 11:31

answered Oct 4, 2013 at 20:05

Erik Kaplun

38.5k15 gold badges102 silver badges113 bronze badges

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

Collectives™ on Stack Overflow

python import sqlite error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related