# What´s the easier way to implement a full te xt search in my app

**URL:** <https://www.ruby-forum.com/t/whata-s-the-easier-way-to-implement-a-full-te-xt-search-in-my-app/167568>\
**Category:** Rails\
**Created:** [May 9, 2009, 4:22pm UTC](https://www.ruby-forum.com/t/whata-s-the-easier-way-to-implement-a-full-te-xt-search-in-my-app/167568 "2009-05-09T16:22:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![flaubert](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/858c86/32.png) [@flaubert](https://www.ruby-forum.com/u/flaubert)\
**Post date:** [May 9, 2009, 4:22pm UTC](https://www.ruby-forum.com/t/whata-s-the-easier-way-to-implement-a-full-te-xt-search-in-my-app/167568/1 "2009-05-09T16:22:28Z")

</div>

Plugin? what?  
Manually? How? (Soma links please)

---

<div class="post-metadata">

**Author:** ![flaubert](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/858c86/32.png) [@flaubert](https://www.ruby-forum.com/u/flaubert)\
**Post date:** [May 9, 2009, 5:21pm UTC](https://www.ruby-forum.com/t/whata-s-the-easier-way-to-implement-a-full-te-xt-search-in-my-app/167568/2 "2009-05-09T17:21:39Z")

</div>

On May 9, 3:21 pm, flaubert [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Plugin? what?  
> Manually? How? (Soma links please)

Assuming you are using mysql the easiest way is probably mysql’s  
fulltext search (because you don’t need to worry about running  
indexing tools, having a search daemon running etc.)

Fred

---

<div class="post-metadata">

**Author:** ![flaubert](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/858c86/32.png) [@flaubert](https://www.ruby-forum.com/u/flaubert)\
**Post date:** [May 9, 2009, 5:41pm UTC](https://www.ruby-forum.com/t/whata-s-the-easier-way-to-implement-a-full-te-xt-search-in-my-app/167568/3 "2009-05-09T17:41:35Z")

</div>

On May 9, 4:20 pm, Frederick C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> On May 9, 3:21 pm, flaubert [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> 
> > Plugin? what?  
> > Manually? How? (Soma links please)
> 
> Assuming you are using mysql the easiest way is probably mysql’s  
> fulltext search (because you don’t need to worry about running  
> indexing tools, having a search daemon running etc.)

should add that this lacks some of the sophistication of other  
solutions and that the reason I stopped using it on one app was  
because it was getting pretty sluggish with a couple of hundred  
thousand documents.

Fred

---

<div class="post-metadata">

**Author:** ![flaubert](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/858c86/32.png) [@flaubert](https://www.ruby-forum.com/u/flaubert)\
**Post date:** [May 9, 2009, 7:58pm UTC](https://www.ruby-forum.com/t/whata-s-the-easier-way-to-implement-a-full-te-xt-search-in-my-app/167568/4 "2009-05-09T19:58:42Z")

</div>

On May 9, 10:40 am, Frederick C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> On May 9, 4:20 pm, Frederick C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> wrote:\> On May 9, 3:21 pm, flaubert [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> 
> > > Plugin? what?

In Nick Plante and David Berube’s book “Practical Rails Plugins”  
Chapter 16 talks about implementing the plugin Sphinx to do Full Text  
Search.