Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #64604
| From | "Joseph L. Casale" <jcasale@activenetwerx.com> |
|---|---|
| Subject | RE: SQLite + FTS (full text search) |
| Date | 2014-01-23 13:23 +0000 |
| References | <dd786a2e-a485-4819-8e5f-8336f2d4f98d@googlegroups.com> |
| Newsgroups | comp.lang.python |
| Message-ID | <mailman.5887.1390483494.18130.python-list@python.org> (permalink) |
> 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.
Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
SQLite + FTS (full text search) Mark Summerfield <list@qtrac.plus.com> - 2014-01-23 04:20 -0800
Re: SQLite + FTS (full text search) Asaf Las <roegltd@gmail.com> - 2014-01-23 05:24 -0800
Re: SQLite + FTS (full text search) Mark Lawrence <breamoreboy@yahoo.co.uk> - 2014-01-23 13:39 +0000
Re: SQLite + FTS (full text search) Asaf Las <roegltd@gmail.com> - 2014-01-23 05:49 -0800
Re: SQLite + FTS (full text search) Rustom Mody <rustompmody@gmail.com> - 2014-01-23 07:23 -0800
Re: SQLite + FTS (full text search) Chris Angelico <rosuav@gmail.com> - 2014-01-24 01:13 +1100
Re: SQLite + FTS (full text search) Terry Reedy <tjreedy@udel.edu> - 2014-01-23 19:59 -0500
RE: SQLite + FTS (full text search) "Joseph L. Casale" <jcasale@activenetwerx.com> - 2014-01-23 13:23 +0000
Re: SQLite + FTS (full text search) Antoine Pitrou <solipsis@pitrou.net> - 2014-01-23 14:09 +0000
Re: SQLite + FTS (full text search) Mark Summerfield <list@qtrac.plus.com> - 2014-01-23 06:39 -0800
csiph-web