Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder.erje.net!eu.feeder.erje.net!xlned.com!feeder7.xlned.com!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <jcasale@activenetwerx.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.000
X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'python.': 0.02; 'subject:text': 0.05; 'binary': 0.07; 'subject: + ': 0.07; '32-bit': 0.09; '[1]:': 0.09; '[2]:': 0.09; '[3]:': 0.09; 'enabled.': 0.09; 'python': 0.11; 'windows': 0.15; 'dll,': 0.16; 'received:172.18.0': 0.16; 'sqlite': 0.16; 'subject:search': 0.16; 'thoroughly.': 0.16; 'bit': 0.19; 'import': 0.22; 'to:name:python- list@python.org': 0.22; 'enhanced': 0.24; 'replace': 0.24; 'header:Received:8': 0.24; 'header:In-Reply-To:1': 0.27; '[1]': 0.29; 'skip:( 20': 0.30; 'subject: (': 0.35; 'but': 0.35; 'module.': 0.36; 'done': 0.36; 'charset:us-ascii': 0.36; 'list': 0.37; 'nov': 0.38; 'to:addr:python-list': 0.38; 'to:addr:python.org': 0.39; 'mailing': 0.39; 'received:unknown': 0.61; 'gain': 0.79; 'worth,': 0.84; '2013,': 0.91
X-Cloudmark-SP-Filtered: true
X-Cloudmark-SP-Result: v=1.1 cv=W0/jygPWOP4vNGB1giqMd6hViTlTWopR5z2gXdBWnF4= c=1 sm=1 a=8pJYMNX3tZgA:10 a=7PYXob_7ZXMA:10 a=AgG5ixNBvo4A:10 a=BLceEmwcHowA:10 a=kj9zAlcOel0A:10 a=xqWC_Br6kY4A:10 a=oNw28mxuUhXRB3mVwYQ4Ag==:17 a=8AHkEIZyAAAA:8 a=4LhTVkQvTiSgR_TlieIA:9 a=CjuIK1q_8ugA:10 a=HpAAvcLHHh0Zw7uRqdWCyQ==:117
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=activenetwerx.com; s=default; t=1390483422; bh=R4qP4MvjaAV92njrjJF0DirdohekCQBHYi+Xx3gKMW4=; h=From:To:Subject:Date:References:In-Reply-To; b=nEls85wUInSf40ZN+fwzj9p2degIcjKy1tFiHfqsZHkDOzD1W1k3TpodRMHxbCaHw 0LZjMQyhl58TlUFDAP/ly3uyreveZNlRP5aivnEcz/wL0F9InEsXrDBzwfSZ2mPsCP +rApzwRJanSkpQWlbyuvdbln0vBk7l79UIAuEMk0=
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=activenetwerx.com; s=default; t=1390483422; bh=R4qP4MvjaAV92njrjJF0DirdohekCQBHYi+Xx3gKMW4=; h=From:To:Subject:Date:References:In-Reply-To; b=nEls85wUInSf40ZN+fwzj9p2degIcjKy1tFiHfqsZHkDOzD1W1k3TpodRMHxbCaHw 0LZjMQyhl58TlUFDAP/ly3uyreveZNlRP5aivnEcz/wL0F9InEsXrDBzwfSZ2mPsCP +rApzwRJanSkpQWlbyuvdbln0vBk7l79UIAuEMk0=
X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on mail.activenetwerx.com
X-Spam-Level: 
X-Spam-Status: No, score=-1.0 required=5.0 tests=ALL_TRUSTED autolearn=ham version=3.3.1
From: "Joseph L. Casale" <jcasale@activenetwerx.com>
To: "python-list@python.org" <python-list@python.org>
Subject: RE: SQLite + FTS (full text search)
Thread-Topic: SQLite + FTS (full text search)
Thread-Index: AQHPGDZnMj8Z0RVgjkaxsj+n/95JnpqSSrhA
Date: Thu, 23 Jan 2014 13:23:40 +0000
References: <dd786a2e-a485-4819-8e5f-8336f2d4f98d@googlegroups.com>
In-Reply-To: <dd786a2e-a485-4819-8e5f-8336f2d4f98d@googlegroups.com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
x-originating-ip: [172.18.0.201]
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Virus-Scanned: ClamAV using ClamSMTP
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.5887.1390483494.18130.python-list@python.org>
Lines: 31
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1390483494 news.xs4all.nl 2973 [2001:888:2000:d::a6]:37823
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:64604

> 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 p=
refer
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 bi=
t (AMD64)]
...
IPython 2.0.0-dev -- An enhanced Interactive Python.
...

In [1]: import apsw

In [2]: c =3D 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=3D1',)

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.