Geek Answers Handbook

What are the differences between sqlite3 from python2.5, pysqlite and apsw

I would like to know the differences between sqlite3 from python2.5, pysqlite and apsw ? I have an uneven job when trying to install pysqlite on Vista using python2.5, see below:

  • download sqlite from http://sqlite.org/download.html and unzip them in a folder windows/system32and put sqlite3.dll in a folderc:/python25/Lib
  • download pysqlite windows installer

  • when trying to execute the 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 if anyone who has experience with the above three types of sqlite bindings to python can comment on their pros and cons, such as appearances, I wonder if it is worth trying pysqlite or apsw

thank

+5
2

pysqlite - , sqlite3 ( Windows python 2.5)

+3

, pysqlite . 2.6.0, - 2.3.2. pysqlite2.test , pysqlite ( - ).

apsw http://code.google.com/p/apsw

+2

More articles:


All Articles