SQLite + FTS (full text search)
Joseph L. Casale
jcasale at activenetwerx.com
Thu Jan 23 08:23:40 EST 2014
> 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.
More information about the Python-list
mailing list