Chris, Your solution is very interesting and I would like to consider it. At the moment I'm going to focus on (N)Hibernate Search (in the .NET version is released in the SVN), which also covers the requirement of persistence.
If the result of the tests won't be successful, I will immediately focus on DBSight. Thanks again to all of you. Antonello On 8/10/07, Chris Lu <[EMAIL PROTECTED]> wrote: > Hi, Antonello, > > I think you should try DBSight. Although it's a Java implementation, > you don't need to worry about java coding at all. Just point the > connection string to a database, and specify by you SQL, then you will > have scheduling, incremental indexing, recreating indexes, sync with > deleted records, and you can use Lucene query syntax directly, use > existing templates or XML/JSON/HTML/JSP to render your results. > > It's an instant and scalable solution. Check out Lucene Database > Search in 3 minutes: > http://wiki.dbsight.com/index.php?title=Create_Lucene_Database_Search_in_3_minutes > > You can use it on any databases. > > Thanks! > > -- > Chris Lu > ------------------------- > Instant Scalable Full-Text Search On Any Database/Application > site: http://www.dbsight.net > demo: http://search.dbsight.com > Lucene Database Search in 3 minutes: > http://wiki.dbsight.com/index.php?title=Create_Lucene_Database_Search_in_3_minutes > > > On 8/10/07, Antonello Provenzano <[EMAIL PROTECTED]> wrote: > > Hi There! > > > > I've been working for a while on the implementation of a website > > oriented to contents that would contain millions of entries, most of > > them indexable (such as descriptions, texts, names, etc.). > > The ideal solution to make them searchable would be to use Lucene as > > index and search engine. > > > > The reason I'm posting the mailing list is the following: since all > > the entries will be stored in a database (most likely MySQL InnoDB or > > Oracle), what's the best technique to implement a system that indexes > > in "real time" (eg. when an entry is inserted into the databsse) the > > content and make it searchable? Based on my understanding of Lucene, > > such this thing is not possible, since the index must be re-created to > > be able to search the indexed contents. Is this true? > > > > Eventually, could anyone point me to a working example about how to > > implement such a similar context? > > > > > > Thank you for the support. > > Antonello > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
