Can Lucene be Used To Substitute Real Database?

Submitted by will on Tue, 2005-10-25 13:09.
 > Can Lucene to be used in place of mysql so that
 > website visitors can input data that will in turn
 > inserting row into Lucene just like mysql db?
 That's a bad idea. Lucene lacks a real update (you need to delete and
 re-add) and also sees everything as a string, even numbers. So although
 it's technically possible you don't want to do it.

First of all, just using Lucene to replace rdms is quite possible in some specific cases.

In addition to updating and string/number issues, Lucene also lacks many rdms functionalities. One of them is aggregation functions like SUM(), or "group by".

Of course, in some case, you may be able to get around it by just using Lucene's existing functionalities. But you will need to worry about multi-threaded updating, Lucene index optimization, etc.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Submitted by vikas_khengare on Wed, 2005-11-09 22:21.

Hi to All,

I want to develop search engine with Lucent to search Database. Can you tell me steps for creating index, maintaining index, Updating index, Searching index & Display results.

I want only idea / stucture of events for development.


vikas Khengare
[ ]

Submitted by will on Fri, 2005-12-16 07:46.

The example should be helpful. Let me know if you have more questions.