Hi guys,
I need to add a search engine to my web application. I use the
word ADD because I don't want to write one!
Requirement:
1. Search a database - either SQL Server, Pointbase or MySQL (as many as possible)
2. Span multiple fields in a single table (so not just look in a single field)
3. Be reasonably smart, but not kick-ass
4. Happy to pay money, but it would need to be royalty-free
I've had a look at Lucene and can see how it would be implemented around a database but I'm concerned about server cluster support - not sure if it supports clustered environments if the index is on the application server. It also feels like a botch of a very webby search engine.
I've also had a look at SQLOne, DieselPoint and Netrics. They're all a bit too cool for school for my requirements and I'm pretty sure the licensing isn't going to be right.
I've also looked at using database specific indexing - which means we have to write database specific SQL and setup instructions which isn't really desirable. We have a very simple installer and this would add a lot of complexity if they're using SQL Server vs MySQL.
Is there anything I should look at? Do any of you guys know of a good component we can purchase?
I want it all obviously - any help is very much appreciated!
Cheers,
Steve
