[Brug-talk] Ferret - sphinx - Solr

[Peter Vandenabeele]

On Jan 21, 2008 10:47 AM, Peter De Berdt (10-forward)
<peter at 10-forward.be> wrote:
...
> Over the last couple of days, I've been looking into other possible
> solutions, such as acts_as_solr, acts_as_searchable (using Hyperestraier),
> and the MySQL MyISAM extra table thingie of which the name escapes me for
> the moment. I'm currently leaning towards solr, but Sphinx looks mighty
> tempting. I might run a few tests with it to see how well it copes. Anyone
> have any realworld experience?

Well ... it looks like we have a topic for a BoF (Beards of a Feather) at the
Ruby and Rails room at fosdem ... Peter also just update the program :-)

  http://wiki.rubyist.be/wiki/show/FosdemDevroom2008AceptedPapers

It seems a few people are fighting this topic. We could easily spend a few
hours hacking away at this particular problem ("advanced search in Rails").

I am currently looking into the postgresql + tsearch2 path. Also seems promising
(if you can do it inside the database, shouldn't that be more
performant ? and we
can ask instant advise to the neighbours in the postgresql DevRoom ...

  http://fosdem.org/2008/schedule/devroom/bsdpostgresql

I am not convinced yet of the "mysql thingie" (fulltext search in the MyISAM
tables) since I see little possibility for tweaking it and the discussions on

  http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

don't add too much positive vibes to my gut feeling about it (we are running
mysql 5.0 on debian stable=etch maybe things improv in mysql 5.1 or 6 ?).

I currently see 2 paths:
* "in database" full text search with tsearch2 in postgresql
* Sphinx

Peter