Can anyone recommend a search engine for Rails that works with MS SQL Server? I have good experience in using Sphinx and the Rails plugin UltraSphinx. Unfortunately, it supports only MySQL and PostgreSQL. The newest beta version does add support for MSSQLServer, but only if Sphinx is installed on a Windows machine - and I have to run it on Debian Linux. So if anyone knows of a similar search engine, that supports the above, I would be very grateful. Especially if it already has a plugin for Rails. :-) - Carsten -- 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 -~----------~----~----~----~------~----~------~--~---
Why don''t you use a full text search engine that doesn''t require a database -> http://lucene.apache.org/solr/ Can''t understand why people still try to use Sphinx, when it doesn''t get any near Solr''s features and doesn''t update the indexes on the fly. - Maurício Linhares http://alinhavado.wordpress.com/ (pt-br) | http://blog.codevader.com/ (en) On Wed, Feb 25, 2009 at 4:34 AM, Carsten Gehling <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > Can anyone recommend a search engine for Rails that works with MS SQL > Server? > > I have good experience in using Sphinx and the Rails plugin UltraSphinx. > Unfortunately, it supports only MySQL and PostgreSQL. The newest beta > version does add support for MSSQLServer, but only if Sphinx is > installed on a Windows machine - and I have to run it on Debian Linux. > > So if anyone knows of a similar search engine, that supports the above, > I would be very grateful. Especially if it already has a plugin for > Rails. :-) > > - Carsten > -- > 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 25 Feb 2009, at 15:22, Maurício Linhares wrote:> > Why don''t you use a full text search engine that doesn''t require a > database -> http://lucene.apache.org/solr/ > > Can''t understand why people still try to use Sphinx, when it doesn''t > get any near Solr''s features and doesn''t update the indexes on the > fly.Last time I looked (admittedly a while back) sphinx was noticeably faster at indexing (eg see http://blog.evanweaver.com/articles/2008/03/17/rails-search-benchmarks and http://www.mysqlperformanceblog.com/files/presentations/EuroOSCON2006-High-Performance-FullText-Search.pdf ). As far as the original question goes Sphinx doesn''t have to be able to talk to your database if you can provide a command line tool that will produce an appropriately formatted xml stream for sphinx. Fred> > > - > Maurício Linhares > http://alinhavado.wordpress.com/ (pt-br) | http:// > blog.codevader.com/ (en) > > > > On Wed, Feb 25, 2009 at 4:34 AM, Carsten Gehling > <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote: >> >> Can anyone recommend a search engine for Rails that works with MS SQL >> Server? >> >> I have good experience in using Sphinx and the Rails plugin >> UltraSphinx. >> Unfortunately, it supports only MySQL and PostgreSQL. The newest beta >> version does add support for MSSQLServer, but only if Sphinx is >> installed on a Windows machine - and I have to run it on Debian >> Linux. >> >> So if anyone knows of a similar search engine, that supports the >> above, >> I would be very grateful. Especially if it already has a plugin for >> Rails. :-) >> >> - Carsten >> -- >> 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
And it still is faster at indexing, as it isn''t capable of on-the-fly updates (if something changes, you´ll have to rebuild your index). I see Sphinx as an option if your full text search functionality isn''t that complicated (Sphinx can''t do partial matches or fuzzy search) or your indexed models don''t change much. Solr is a full blown full text search tool with most of the features you''ll see in "enterprise" tools like fuzzy searching (that enables things like Google''s "did you mean?" feature), stop words removal, faceting and a simple way to write your own customized filters (and loads of documentations if you need to tweak it). I tried Ferret and it had loads of problems, specially with concurrent access, tried Sphinx but the lack of on-the-fly updates, partial maches (there''s a hack to get this working, but it''s a hack) and fuzzy search lead me to try Solr and now I have no reason to look back :) - Maurício Linhares http://alinhavado.wordpress.com/ (pt-br) | http://blog.codevader.com/ (en) On Wed, Feb 25, 2009 at 12:55 PM, Frederick Cheung <frederick.cheung-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Last time I looked (admittedly a while back) sphinx was noticeably > faster at indexing (eg see http://blog.evanweaver.com/articles/2008/03/17/rails-search-benchmarks > and http://www.mysqlperformanceblog.com/files/presentations/EuroOSCON2006-High-Performance-FullText-Search.pdf > ). > > As far as the original question goes Sphinx doesn''t have to be able to > talk to your database if you can provide a command line tool that will > produce an appropriately formatted xml stream for sphinx. > > Fred--~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Maurício Linhares wrote:> Solr is a full blown full text search tool with most of the features > you''ll see in "enterprise" tools like fuzzy searching (that enables... I will give Solr a go, thanks. One of the things I like about ThinkingSphinx though is the ability to combine Sphinx''s free-text searching with other search criterias on other attributes in the model. But I can probably do that myself in another way. - Carsten -- 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---