Mailing-List: contact lucene-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Lucene Users List" <lucene-user@jakarta.apache.org>
Mime-Version: 1.0 (Apple Message framework v618)
In-Reply-To: <20040720132912.625A7395D@sitemail.everyone.net>
References: <20040720132912.625A7395D@sitemail.everyone.net>
Content-Type: text/plain; charset=US-ASCII; format=flowed
Message-Id: <59D7F60C-DA56-11D8-81B3-000393A564E6@ehatchersolutions.com>
Content-Transfer-Encoding: 7bit
From: Erik Hatcher <erik@ehatchersolutions.com>
Subject: Re: The indexer
Date: Tue, 20 Jul 2004 10:09:01 -0400
To: "Lucene Users List" <lucene-user@jakarta.apache.org>


On Jul 20, 2004, at 9:29 AM, Ian McDonnell wrote:
> Basically i add details about a movie clip as various fields in an sql 
> db using a jsp form. When the form submits i want to add the details 
> into the db and also want the fields to be stored as a searchable 
> lucene index on the server.
>
> Is this possible?

Of course.  But you'll have to code it.  It's only a few lines of code 
to index a "document" into a Lucene index, but it is up to you to code 
those into the appropriate spot in your system (most likely right where 
you insert into mysql).

	Erik

>
> Ian
>
>
> --- Erik Hatcher <erik@ehatchersolutions.com> wrote:
> On Jul 20, 2004, at 8:44 AM, Ian McDonnell wrote:
>> Can Lucenes indexer be used to store info in fields in a mysql db?
>
> I'm not quite clear on your question.  You want to store a Lucene index
> (aka Directory) within mysql?
>
> Or, you want to index data from your existing mysql database into a
> Lucene index?
>
> A Directory implementation for Berkeley DB was created by the Chandler
> project and contributed to the Lucene sandbox (see Lucene's website for
> details on the sandbox and how to get to it).  There has been some
> efforts to put a Lucene index into SQL Server, I believe, but I haven't
> seen mention of that in a while.  It *can* be done, but I'm skeptical
> of the performance hit of adding in a relational database layer - and
> to do it well would certainly be non-trivial.
>
> As for indexing data from mysql - there have been lots of discussions
> of that recently, so check the archives.  Basically you read the data,
> and index it with Lucene's API.  And you are responsible for keeping it
> in sync.
>
> 	Erik
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: lucene-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: lucene-user-help@jakarta.apache.org
>
>
>
> _____________________________________________________________
> Sign up for FREE email from SpinnersCity Online Dance Magazine & 
> Vortal at http://www.spinnerscity.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: lucene-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: lucene-user-help@jakarta.apache.org


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