Python 导入 SQLite 错误

Question

在macOS 10.8上，通过homebrew安装了python2.7和sqlite3。
而pysqlite是通过pip安装的。

当我在python的交互式环境中输入import sqlite3时，出现了下面的错误：

>>> 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

怎么才能解决这个错误呢？

Answer 1

解决办法是先卸载 sqlite 和 python 这两个软件：

brew rm sqlite python

然后再重新安装 Python（这样也会自动安装 SQLite3，因为它是 Python 的一个依赖项）：

brew install python