Hi, I''ve been asked to move an application to Oracle. It uses Ferret drb for text search [& its been really stable thank you very much]. Any one have any thoughts on how to do text searching in Oracle? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Matt Stone1 wrote:> I''ve been asked to move an application to Oracle. > > It uses Ferret drb for text search [& its been really stable thank you > very much]. > > Any one have any thoughts on how to do text searching in Oracle?Write a cron job that reads Oracle and writes Ferret every day, and trigger this cron in some kind of "update" mode when specific new data come in. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Phlip wrote:> Matt Stone1 wrote: > >> I''ve been asked to move an application to Oracle. >> >> It uses Ferret drb for text search [& its been really stable thank you >> very much]. >> >> Any one have any thoughts on how to do text searching in Oracle? > > Write a cron job that reads Oracle and writes Ferret every day, and > trigger this > cron in some kind of "update" mode when specific new data come in.Thanks Phlip, Yep, that would work. I guess I was hoping that oracle had its own elegant text search features that could be accessed by rails, possible via stored procedures. - matt. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
>> Write a cron job that reads Oracle and writes Ferret every day, and >> trigger this >> cron in some kind of "update" mode when specific new data come in.> I guess I was hoping that oracle had its own elegant text search > features that could be accessed by rails, possible via stored > procedures.If you do it my way, you can deploy the feature first. Then you would have lots of time to research the awesome toy that is Oracle, without making your clients wait for their feature. Software development should always be incremental - even if you must temporarily degrade performance just to avoid rewriting too much. Your network admins might ask about your new CPU load, though... (-: --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
> I''ve been asked to move an application to Oracle. > > It uses Ferret drb for text search [& its been really stable thank you > very much]. > > Any one have any thoughts on how to do text searching in Oracle?You might want to look into Oracle Text. http://www.oracle.com/technology/products/text/index.html http://www.oracle.com/technology/pub/articles/asplund-textsearch.html --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---