sqlite3与python2.5,pysqlite和apsw有什么区别

我想知道python2.5,pysqlite和apsw的 sqlite3之间的区别？当我尝试使用python2.5在windows vista上安装pysqlite时,我有一个颠簸的运行,请参阅以下内容:

从http://sqlite.org/download.html下载sqlite 并将它们解压缩到windows/system32文件夹中并将sqlite3.dll放入c:/python25/Lib文件夹

下载pysqlite windows安装程序

当试图在python shell中运行以下时:

>>> from pysqlite2 import test
Traceback (most recent call last):
  File "", line 1, in 
  File "pysqlite2\test\__init__.py", line 35, in 
    from pysqlite2.test import dbapi, types, userfunctions, factory, transactions,\
  File "pysqlite2\test\dbapi.py", line 27, in 
    import pysqlite2.dbapi2 as sqlite
  File "pysqlite2\dbapi2.py", line 27, in 
    from pysqlite2._sqlite import *
ImportError: No module named _sqlite

我想知道任何有以上三种类型的sqlite绑定到python的经验可以评论他们的优点和缺点如表演我想知道是否值得尝试pysqlite或apsw

谢谢