3 ms·
You should use the right tool for the job. Sphinx is a very functional search product, is available as a Ubuntu package and is easy to integrate to e.g. Django
by kennu 15y ago
You should use the right tool for the job. Sphinx is a very functional search product, is available as a Ubuntu package and is easy to integrate to e.g. Django data models.
(The article links to some weird page in http://www.sphinxsearch.org/ http://www.sphinxsearch.org/. The right link is http://sphinxsearch.com/. http://sphinxsearch.com/.)
- rick888 15y agoI've used it before. I agree. Sphinx works very well. Craigslist even switched over to it a couple of years ago.
- regularfry 15y agoSometimes you just can't. One of my first projects as a freelancer involved hacking full-text search onto a niche news site hosted on a shared host with a shared MySQL instance (specced before my time, and not something I could change). Sphinx wasn't available, Lucene certainly wasn't an option, and the immutable MySQL fulltext config wouldn't let words of 3 letters or less be indexed. However, that wasn't good enough, because there were a lot of important 3-letter company names in the niche. So, what did I do? I prepended 'zzz' to every word before it went into the fulltext index. Dirty, hacky, inefficient, and let me deliver working functionality the same day the request came in.