StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<ul> <li><p>thinking_sphinx and sphinx work beautifully, no indexing, query, install problems ever (5 or 6 install, including production slicehost )</p></li> <li><p>why doesn't everybody use sphinx, like, say craigslist? read here about its limitations (year and a half old articles. The sphinx developer, Aksyonoff, is working on these and he's putting in features and reliability and stamping out bugs at an amazing pace)</p></li> </ul> <p><a href="http://codemonkey.ravelry.com/2008/01/09/sphinx-for-search/" rel="nofollow noreferrer">http://codemonkey.ravelry.com/2008/01/09/sphinx-for-search/</a></p> <p><a href="http://www.ibm.com/developerworks/opensource/library/os-php-apachesolr/" rel="nofollow noreferrer">http://www.ibm.com/developerworks/opensource/library/os-php-apachesolr/</a></p> <p><a href="https://stackoverflow.com/questions/737275/pros-cons-of-full-text-search-engine-lucene-sphinx-postgresql-full-text-searc">Comparison of full text search engine - Lucene, Sphinx, Postgresql, MySQL?</a></p> <ul> <li><p>ferret: easy install, doesn't stem properly, very slow indexing (one mysql db: sphinx: 3 seconds, ferret: 50 minutes). Well documented problems (index corruption) in drb servers in production under load. Having said that, i have use it in develometn since acts-as_ferret came out 3 years ago, and it has served me well. Not adhering to porter stemming is an advantage in some contexts.</p></li> <li><p>Lucene and Solr is the gorilla/mack truck / heavyweight champ of open source search. The teams have been doing an impressive number of new features in <a href="http://www.lucidimagination.com/blog/2009/02/05/looking-forward-to-new-features-in-solr-14/" rel="nofollow noreferrer">solr 14 release:</a></p></li> <li><p>acts-as-solr: works well, once the tomcat or jetty is in place, but those sometimes are a pain. The <a href="http://mattmatt.github.com/acts_as_solr/" rel="nofollow noreferrer">A-A-S fork by mattmatt</a> is the main fork, but the project is relatively unmaintained.</p></li> <li><p>re the tomcat install: SOLR/lucene has unquestionably the best knowledge base/ support search engine of any software package i've seen ( i guess i'm not that surprised), the search box here:</p></li> </ul> <p><a href="http://www.lucidimagination.com/" rel="nofollow noreferrer">http://www.lucidimagination.com/</a></p> <ul> <li><p><a href="http://www.linux-mag.com/id/7341" rel="nofollow noreferrer">Sunspot the new</a> ruby wrapper, build on solr-ruby. Looks promising, but I couldn't get it to install on OSX. Indexes all ruby objects, not just databases through AR </p></li> <li><p>one thing that's really instructive is to install 2 search plugins, e.g. sphinx and SOLR, sphinx and ferret, and see what different results they return. It's as easy as <code>@sphinx_results - @ferret_results</code></p></li> </ul> <hr> <p>just saw this post and responses</p> <p><a href="http://zooie.wordpress.com/2009/07/06/a-comparison-of-open-source-search-engines-and-indexing-twitter/" rel="nofollow noreferrer">http://zooie.wordpress.com/2009/07/06/a-comparison-of-open-source-search-engines-and-indexing-twitter/</a></p> <p><a href="http://www.jroller.com/otis/entry/open_source_search_engine_benchmark" rel="nofollow noreferrer">http://www.jroller.com/otis/entry/open_source_search_engine_benchmark</a></p> <p><a href="http://www.flax.co.uk/blog/2009/07/07/xapian-compared/" rel="nofollow noreferrer">http://www.flax.co.uk/blog/2009/07/07/xapian-compared/</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload