The documentation for the sqlite3 module describes enable_load_extension() and load_extension() methods of the Connection object, but those functions are only available if the user has compiled from source *after* modifying the setup.py to turn off SQLITE_OMIT_LOAD_EXTENSION.

I'd like to see the functions enabled by default (by changing setup.py) but at the very least the documentation should be updated.

Without SQLITE_OMIT_LOAD_EXTENSION, builds will break on Mac OS X 10.5 and 10.6 and maybe other platforms.

Fixed in r85208 by adding a note to the docs.

Thanks, Gerhard!

Has this been fixed in 3.1 and 2.7 too?

Attached patch for Python 2.7. 

Since Issue10268 has not been applied to Python 2.7 the sentence "you must modify setup.py and and remove the line that sets SQLITE_OMIT_LOAD_EXTENSION" still applies.

Fixed typo (double and).

New changeset 804a60029091 by Senthil Kumaran in branch '2.7':
Fix Issue10020 - Doc update to sqlite3 module in 2.7 branch.
http://hg.python.org/cpython/rev/804a60029091

Fixed in branch 2.7. Thanks Kristan. Eric, the documentation patch does not apply to 3.1 because those functions are not present in 3.1.

I just noticed that the blocks in reST should use three-space indent, not two.

Eric, you mean for the whole of sqlite3 docmentation or the part in the footnote?

I mean in the two commits.  I can check the whole file later (and also use automatic reST footnotes, [#] instead of [#fn1]).

Fixed the indentation issues. We could not use automatic reST
footnotes because two links refer to same footnote, so left it as
such.