Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #64604

RE: SQLite + FTS (full text search)

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> (permalink)
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

Show key headers only | View raw

> 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

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