Rails - Jul 2006 - searching

I''ve been searching for a way to implement a search feature across
articles posted in a table.  All the google results I get refer to
"live"
search and I''m not interested an automcomplete function, but because of
the prevalence of tutorials on the subject, I can''t seem to find what I
want.

I have implemented a search in PHP before where I had MySQL perform an
indexing on a couple tables and then I could perform a sort ranked by
relevence.

Is there any advice you all could give me on the topic?  I''m really at
a
loss here. :(  I hope that the list is somewhat active even though it''s
a
US holiday today.

Thanks,
David

try this link:
http://www.bigbold.com/snippets/posts/show/525

don''t forget about necessary utf-8 issues if you need that:
http://wiki.rubyonrails.com/rails/pages/HowToUseUnicodeStrings


On Jul 4, 2006, at 10:01 PM, David M wrote:
> I''ve been searching for a way to implement a search feature across
> articles posted in a table.  All the google results I get refer to  
> "live"
> search and I''m not interested an automcomplete function, but  
> because of
> the prevalence of tutorials on the subject, I can''t seem to find  
> what I
> want.
>
> I have implemented a search in PHP before where I had MySQL perform an
> indexing on a couple tables and then I could perform a sort ranked by
> relevence.
>
> Is there any advice you all could give me on the topic?  I''m
really
> at a
> loss here. :(  I hope that the list is somewhat active even though  
> it''s a
> US holiday today.
>
> Thanks,
> David
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails

If you''re not adverse to switching to PostgreSQL, I''ve had
great
success with the tsearch2 module for PostgreSQL.

Mike

On Jul 4, 2006, at 7:33 AM, ke han wrote:
> try this link:
> http://www.bigbold.com/snippets/posts/show/525
>
> don''t forget about necessary utf-8 issues if you need that:
> http://wiki.rubyonrails.com/rails/pages/HowToUseUnicodeStrings
>
>
> On Jul 4, 2006, at 10:01 PM, David M wrote:
>
>> I''ve been searching for a way to implement a search feature
across
>> articles posted in a table.  All the google results I get refer to  
>> "live"
>> search and I''m not interested an automcomplete function, but  
>> because of
>> the prevalence of tutorials on the subject, I can''t seem to
find
>> what I
>> want.
>>
>> I have implemented a search in PHP before where I had MySQL  
>> perform an
>> indexing on a couple tables and then I could perform a sort ranked by
>> relevence.
>>
>> Is there any advice you all could give me on the topic?  I''m  
>> really at a
>> loss here. :(  I hope that the list is somewhat active even though  
>> it''s a
>> US holiday today.
>>
>> Thanks,
>> David
>> _______________________________________________
>> Rails mailing list
>> Rails@lists.rubyonrails.org
>> http://lists.rubyonrails.org/mailman/listinfo/rails
>
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2414 bytes
Desc: not available
Url :
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060704/9d5437ac/smime.bin