lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erik Hatcher <e...@ehatchersolutions.com>
Subject Re: The indexer
Date Tue, 20 Jul 2004 14:09:01 GMT

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


Mime
View raw message