[Python-Dev] framework build for 2.7 using old sqlite?

[Doug Hellmann]

On Oct 3, 2010, at 11:29 AM, Doug Hellmann wrote:

> I'm trying to write a little program that uses the full text search extension module for sqlite with Python 2.7 on Snow Leopard.  I installed Python by downloading the DMG file from python.org.  According to the Python docs (http://docs.python.org/library/sqlite3.html#sqlite3.Connection.enable_load_extension), 2.7 should include the functions for handling extension modules, but when I try to use them they are not defined (I get an AttributeError when I call the related methods on the Connection object).
> 
> In Modules/_sqlite/connection.c I see that there is an #ifdef for HAVE_LOAD_EXTENSION, which is in turn only defined if both the version number is high enough and SQLITE_OMIT_LOAD_EXTENSION is not set.
> 
> I think the problem is that the build of Python in the DMG I download was created with an old version of the SQLite libraries:
> 
> 	farnsworth:dhellmann:~:503 $ which python
> 	/Library/Frameworks/Python.framework/Versions/2.7/bin/python
> 
> 	farnsworth:dhellmann:~:501 $ python
> 	Python 2.7 (r27:82508, Jul  3 2010, 21:12:11) 
> 	[GCC 4.0.1 (Apple Inc. build 5493)] on darwin
> 	Type "help", "copyright", "credits" or "license" for more information.
> 	>>> import sqlite3
> 	>>> sqlite3.version_info
> 	(2, 6, 0)

Forget that, the version info is for pysqlite, not the underlying libraries.

I found that Python's setup.py has SQLITE_OMIT_LOAD_EXTENSION set, which disables this feature (http://svn.python.org/view?view=rev&revision=78688).

Doug