4

I'm trying to create a full text search facility for a small blog which is running against a SQL Compact Edition 4 database.

There seems to be almost no information out there about this (though I'd be happy if someone can prove me wrong), but as far as I can gather, SQL CE doesn't support the normal SQL Server full-text indexing.

I have briefly looked into using Lucene.Net, but it seems quite complex at first glance; would this be my best option here, or is there a simpler solution which I'm missing?

ErikEJ
  • 40,951
  • 5
  • 75
  • 115
Mark Bell
  • 28,985
  • 26
  • 118
  • 145

3 Answers3

3

Lucene.Net would be a good choice even if you had the option of full text search.

Lucene.Net expands past what FTS (full text sql) offers. Including boosting terms, fuzzy queries, simple faceted search which can be found in a contrib project on the 2.9.4g branch, etc.

Its opensource so you don't have to wait on someone else's cycle to modify it or have it extended or add features.

There are a couple of posts and even FOSS contrib projects to help circumvent the higher barrier to entry. I'd recommend the content in the list below over starting with Lucene in Action.

The book is a great resource, but the lastest edition is aimed at Lucene 3.0, the java version, which includes newer APIs that have not made it into the .NET version.

Lucene.Net will also pay off as a decent library to add to your overall programming repertoire of skill-sets. Search is pretty much apart of most applications these days.

The Lucene.Net project has gone back into incubation with a newer set of committers and goals One of those goals is to make it more .NET idiomatic and easier to use. However, its definitely going to take time and cycles to reach this point.

In the mean time you can always hit up the mailing lists for help or the irc channel #lucene.net for help.

Michael Herndon
  • 56
  • 1
  • Thanks, this was very helpful. I ended up using SimpleLucene which was relatively painless to set up and works like a charm. – Mark Bell Jun 20 '11 at 08:21
2

Lucene is the way to go - a colleague of mine recommends "Lucene in Action" free PDF book, and after first 3 chapters you are up and running.

ErikEJ
  • 40,951
  • 5
  • 75
  • 115
1

If it's a small blog, you may want to use IndexTank because it's free. There's a WordPress plugin that gives you instant search like this:

http://bothsidesofthetable.com

Diego Basch
  • 12,764
  • 2
  • 29
  • 24