What are the differences among sqlite3 from python2.5, pysqlite and apsw
- by leo
Hi,
I would like to know the differences among sqlite3 from python2.5, pysqlite and apsw?
I have a bumpy run when trying to install pysqlite on windows vista with python2.5, see following:
download sqlite from http://sqlite.org/download.html and unzip them into windows/system32 folder and put sqlite3.dll into c:/python25/Lib folder
download pysqlite windows installer
when trying to run following in python shell:
>>> from pysqlite2 import test
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "pysqlite2\test\__init__.py", line 35, in <module>
from pysqlite2.test import dbapi, types, userfunctions, factory, transactions,\
File "pysqlite2\test\dbapi.py", line 27, in <module>
import pysqlite2.dbapi2 as sqlite
File "pysqlite2\dbapi2.py", line 27, in <module>
from pysqlite2._sqlite import *
ImportError: No module named _sqlite
I am wondering anybody with experiences of the above three types of sqlite binding to python can comment their pros and cons such as performances
I am wondering is it worthwhile to try the pysqlite or apsw
thanks