如何在 Python 2.6 中升级 sqlite3 包?

我使用 Python 2.6.5 来构建我的应用程序，它与 sqlite3 3.5.9 一起提供.显然，正如我在我的另一个问题中发现的那样，直到版本 3.6.19 才在 sqlite3 中引入外键支持.但是，Python 2.7 带有 sqlite3 3.6.21，所以这项工作 - 我决定要在我的应用程序中使用外键，所以我尝试升级到 python 2.7.

我使用的是twisted，但我终其一生都无法构建它.Twisted 依赖于 zope.interface 并且我找不到 python 2.7 的 zope.interface——我认为它可能只是工作"，但我必须自己复制所有文件，并让一切工作我自己，而不仅仅是使用自安装包.

所以我认为重新构建 python 2.6 并将其链接到新版本的 sqlite3 可能更明智.但我不知道如何--

我该怎么做?

我安装了 Visual Studio 2008 作为编译器，我读到这是唯一真正支持 Windows 的编译器，而且我运行的是 64 位操作系统

解决方案

sqlite3 不是内置模块；它是一个扩展模块(二进制文件是 C:Python26DLLs_sqlite3.pyd(在我的机器上)).pyd 是具有不同文件扩展名且只有 1 个入口点的 DLL.还有一个 sqlite3.dll，其中包含 SQLite 代码.python.exe 不与其中任何一个链接，因此重建 python.exe 没有意义.

下一个想法是访问 pysqlite2 下载站点，并获取适用于 Python 2.6 的最新 Windows 安装程序.不幸的是，没有关于它包含哪个版本的 SQLite 的文档；一个人需要安装它然后乱搞:

<预><代码>>>>导入 sqlite3 作为标准>>>从 pysqlite2 导入 dbapi2 作为最新版本>>>对于 m in(标准，最新):... 打印 m.sqlite_version...3.5.93.6.2>>>

因此，它仅包含 SQLite 3.6.2 版，它没有您想要的真正的外键支持.

我建议您查看邮件列表以查看是否您的问题在那里得到了回答，如果没有，请询​​问 Python 2.6 安装程序是否有可能包含更高版本的 SQLite(例如 Python 2.7 中包含的那个).

I was using Python 2.6.5 to build my application, which came with sqlite3 3.5.9. Apparently though, as I found out in another question of mine, foreign key support wasn't introduced in sqlite3 until version 3.6.19. However, Python 2.7 comes with sqlite3 3.6.21, so this work -- I decided I wanted to use foreign keys in my application, so I tried upgrading to python 2.7.

I'm using twisted, and I couldn't for the life of me get it to build. Twisted relies on zope.interface and I can't find zope.interface for python 2.7 -- I thought it might just "work" anyway, but I'd have to just copy all the files over myself, and get everything working myself, rather than just using the self-installing packages.

So I thought it might be wiser to just re-build python 2.6 and link it against a new version of sqlite3. But I don't know how--

How would I do this?

I have Visual Studio 2008 installed as a compiler, I read that that is the only one that is really supported for Windows, and I am running a 64 bit operating system

解决方案

sqlite3 is not a built-in module; it's an extension module (the binary is C:Python26DLLs_sqlite3.pyd (on my machine)). A pyd is a DLL with a different filename extension and only 1 entry point. There's also a sqlite3.dll, which contains the SQLite code. python.exe is not linked against either of those, and thus rebuilding python.exe has no point.

The next idea is to go to the pysqlite2 download site, and get the latest Windows installer for Python 2.6. Unfortunately there's no docs about which version of SQLite it contains; one needs to install it and then muck about:

>>> import sqlite3 as standard
>>> from pysqlite2 import dbapi2 as latest
>>> for m in (standard, latest):
...    print m.sqlite_version
...
3.5.9
3.6.2
>>>

So, it contains only SQLite version 3.6.2, which doesn't have the real foreign key support that you want.

I suggest that you check the mailing list to see if your question is answered there, and if not ask about the possibility of a Python 2.6 installer containing a later SQLite (e.g. the one included with Python 2.7).