> But on Windows when I use the official Python 3.3 32-bit binary from > www.python.org this is not enabled.
For an unobtrusive way [1] to gain this, see apsw. For what it's worth, I prefer this package over the built in module. Python 3.3.3 (v3.3.3:c3896275c0f6, Nov 18 2013, 21:19:30) [MSC v.1600 64 bit (AMD64)] ... IPython 2.0.0-dev -- An enhanced Interactive Python. ... In [1]: import apsw In [2]: c = apsw.Connection(':memory:') In [3]: for x in c.cursor().execute('pragma compile_options'): print(x) ('ENABLE_FTS3',) ('ENABLE_FTS3_PARENTHESIS',) ('ENABLE_FTS4',) ('ENABLE_RTREE',) ('THREADSAFE=1',) hth, jlc [1] See the sqlite mailing list for a way to replace the dll, while I have done it I also have tested it thoroughly. -- https://mail.python.org/mailman/listinfo/python-list