Re: SQLite + FTS (full text search)

2014-01-23 Thread Terry Reedy
On 1/23/2014 8:24 AM, Asaf Las wrote: On Thursday, January 23, 2014 2:20:31 PM UTC+2, Mark Summerfield wrote: Hi, On my Debian stable 64-bit system, SQLite3 has FTS (full text search) enabled (although at version 3 rather than the recommended version 4): Python 3.2.3 (default, Feb 20 2013, 14:4

Re: SQLite + FTS (full text search)

2014-01-23 Thread Rustom Mody
On Thursday, January 23, 2014 7:09:08 PM UTC+5:30, Mark Lawrence wrote: > On 23/01/2014 13:24, Asaf Las wrote: > > It is compile time option. > > http://www.sqlite.org/compile.html#enable_fts3 > > you have to build it with this option enabled. > As an option can be represented in a single bit then

Re: SQLite + FTS (full text search)

2014-01-23 Thread Mark Summerfield
On Thursday, 23 January 2014 14:09:19 UTC, Antoine Pitrou wrote: > Hi, > > > > Mark Summerfield qtrac.plus.com> writes: > > > > > > My guess is that on Debian, the packagers install a full SQLite 3 and the > > Python package uses that. But on > > > Windows I think the Python packagers bun

Re: SQLite + FTS (full text search)

2014-01-23 Thread Chris Angelico
On Fri, Jan 24, 2014 at 12:39 AM, Mark Lawrence wrote: >> >> It is compile time option. >> http://www.sqlite.org/compile.html#enable_fts3 >> you have to build it with this option enabled. >> > > As an option can be represented in a single bit then presumably the Windows > msi file only needs an ex

Re: SQLite + FTS (full text search)

2014-01-23 Thread Antoine Pitrou
Hi, Mark Summerfield qtrac.plus.com> writes: > > My guess is that on Debian, the packagers install a full SQLite 3 and the Python package uses that. But on > Windows I think the Python packagers bundle their own SQLite (quite rightly since it might not already be installed). > > I'd like the W

Re: SQLite + FTS (full text search)

2014-01-23 Thread Asaf Las
On Thursday, January 23, 2014 3:39:08 PM UTC+2, Mark Lawrence wrote: > On 23/01/2014 13:24, Asaf Las wrote: > As an option can be represented in a single bit then presumably the > Windows msi file only needs an extra bit to allow for this, or have I > missed something? While I'm at it what is th

Re: SQLite + FTS (full text search)

2014-01-23 Thread Mark Lawrence
On 23/01/2014 13:24, Asaf Las wrote: On Thursday, January 23, 2014 2:20:31 PM UTC+2, Mark Summerfield wrote: Hi, On my Debian stable 64-bit system, SQLite3 has FTS (full text search) enabled (although at version 3 rather than the recommended version 4): Python 3.2.3 (default, Feb 20 2013, 14:44

Re: SQLite + FTS (full text search)

2014-01-23 Thread Asaf Las
On Thursday, January 23, 2014 2:20:31 PM UTC+2, Mark Summerfield wrote: > Hi, > On my Debian stable 64-bit system, SQLite3 has FTS (full text search) > enabled (although at version 3 rather than the recommended version 4): > > Python 3.2.3 (default, Feb 20 2013, 14:44:27) [GCC 4.7.2] on linux2 >

RE: SQLite + FTS (full text search)

2014-01-23 Thread Joseph L. Casale
> 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.16

SQLite + FTS (full text search)

2014-01-23 Thread Mark Summerfield
Hi, On my Debian stable 64-bit system, SQLite3 has FTS (full text search) enabled (although at version 3 rather than the recommended version 4): Python 3.2.3 (default, Feb 20 2013, 14:44:27) [GCC 4.7.2] on linux2 Type "copyright", "credits" or "license()" for more information. >>> import sqlite3