4

when we are using winform to index data through lucene.net then think say 10 same win apps is running in a office and they all index data. if the index segment file is created in every pc then it will be problem or we can create in any centralize pc but problem occur when that pc suddenly being unavailable from network. so i like to know can we store lucene.net index in sql server for centralize access. if possible please guide me. i search lot for storing lucene.net index in sql server but found none. i got a article on java and they i saw it is possible. here is the link http://kalanir.blogspot.in/2008/06/creating-search-index-in-database.html

they said Lucence contains the JdbcDirectory interface for this purpose but i am working with lucene.net & c# so please anyone guide me how make it possible to store lucene index in sql server.

thanks

Improve this question
4
  • What if the server running sql server is suddenly unavailable? Don't you still have that problem? Commented Jul 14, 2014 at 14:01
  • 1
    Use Solr Commented Jul 14, 2014 at 14:02
  • Or ElasticSearch Commented Jul 14, 2014 at 14:06
  • Solr and ElasticSearch both require installing the JVM. I might consider that if they stop releasing adware with it. Commented May 18, 2016 at 14:57

1 Answer 1

Reset to default
3

It is possible to create a custom Directory but, it is quite painful. I've seen several project try this and fail.

The show stopper for your approach is that the IndexWriter assumes that it has sole access to the Directory. So having multiple machines writing docs to the same Directory is flawed and will break many assumptions.

The best approach is to treat Lucene like a database. You wouldn't expect many machines to all write directly to files of a db. That's why there is a service that the clients talk to (SQL Server, MySql, Postgres etc etc).

Remember Lucene is just a library not a "product". What you need is a service with an api for the machines to talk to.

ElasticSearch has been mentioned elsewhere and it is very good. Highly recommended you look into it. Redundancy, speed, latest features etc (yes it does require the JVM, more accurately the JRE. If you look carefully there is a download/installer that does not also install crapware).

It is also quite straight forward to write a service that self-hosts ASP.net WebAPI and wraps Lucene. Creating a client that talks to it is also quite easy. Just a wrapper around HttpClient. (I have done this several times. Getting a POC working should only take a day or two. But the devil is in the detail.)

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.