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

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

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

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

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>', '…' ) as extract
    from        document
    where       document.content match %s

Here is an example of FTS at work:

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

Cheers,

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







---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to