Return-Path: 
 <java-user-return-35985-apmail-lucene-java-user-archive=lucene.apache.org@lucene.apache.org>
Delivered-To: apmail-lucene-java-user-archive@www.apache.org
Received: (qmail 97907 invoked from network); 8 Sep 2008 18:34:56 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 8 Sep 2008 18:34:56 -0000
Received: (qmail 65133 invoked by uid 500); 8 Sep 2008 18:34:37 -0000
Delivered-To: apmail-lucene-java-user-archive@lucene.apache.org
Received: (qmail 65094 invoked by uid 500); 8 Sep 2008 18:34:36 -0000
Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:java-user-help@lucene.apache.org>
List-Unsubscribe: <mailto:java-user-unsubscribe@lucene.apache.org>
List-Post: <mailto:java-user@lucene.apache.org>
List-Id: <java-user.lucene.apache.org>
Reply-To: java-user@lucene.apache.org
Delivered-To: mailing list java-user@lucene.apache.org
Received: (qmail 65074 invoked by uid 99); 8 Sep 2008 18:34:36 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Sep 2008 11:34:36 -0700
X-ASF-Spam-Status: No, hits=1.5 required=10.0
	tests=SPF_PASS,WEIRD_PORT
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of petite_abeille@mac.com
 designates 17.148.16.86 as permitted sender)
Received: from [17.148.16.86] (HELO asmtpout011.mac.com) (17.148.16.86)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Sep 2008 18:33:34 +0000
MIME-version: 1.0
Content-type: text/plain; charset=WINDOWS-1252; format=flowed; delsp=yes
Received: from [192.168.1.3] ([89.217.19.110])
 by asmtp011.mac.com (Sun Java(tm) System Messaging Server 6.3-7.03 (built Aug
 7 2008; 32bit)) with ESMTPSA id <0K6W00LT83KRLIM0@asmtp011.mac.com> for
 java-user@lucene.apache.org; Mon, 08 Sep 2008 11:34:05 -0700 (PDT)
Message-id: <2D00B7AE-6732-43E0-8FF4-0267DADA882C@mac.com>
From: Petite Abeille <petite_abeille@mac.com>
To: java-user@lucene.apache.org
In-reply-to: <7e536b1f0809081049g7527a7f6t7882b0c374a050ca@mail.gmail.com>
Content-transfer-encoding: quoted-printable
Subject: Re: Haloe (Lucene package) released!
Date: Mon, 08 Sep 2008 20:34:02 +0200
References: <7e536b1f0809072143h79730af3u40c019e837d87d99@mail.gmail.com>
 <9BD56F35-2521-4A6A-BDF5-9D363E2764E7@mac.com>
 <7e536b1f0809081049g7527a7f6t7882b0c374a050ca@mail.gmail.com>
X-Mailer: Apple Mail (2.926)
X-Virus-Checked: Checked by ClamAV on apache.org


On Sep 8, 2008, at 7:49 PM, Marcus Herou wrote:

> :) Whoof so much high quality info and at the same time a huge =20
> amount of useless data, splogs and spam.

Incidentally, if you search needs are humbler and do not require the =20
full fire power of mighty Lucene, SQLite provides a very handy Full =20
Text Search (FTS) module:

http://www.sqlite.org/cvstrac/wiki?p=3DFtsUsage

Rather straightforward to use as well:

(1) Create a table

     create virtual table document using fts3
     (
         name,
         content,
         tokenize porter
     )

(2) Populate it

     insert into document( name, content ) values( %s, %s )

(3) Search it

     select      document.name as name,
                 snippet( document, '<i>', '</i>', '=85' ) as extract
     from        document
     where       document.content match %s

Here is an example of FTS at work:

http://svr225.stepx.com:3388/search?q=3Dblog

Cheers,

--
PA.
http://alt.textdrive.com/nanoki/







---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org