Thinking Sphinx and MongoDB

[JeffLuckett]

Greetings,

We're beginning to phase MongoDB usage into our rails app. We're
approaching the point where we may want to start having fulltext
indexing on some of our Mongo documents.

Is there or will there be support for Mongo-based models in
ThinkingSphinx?

We've been using MongoMapper for some of our early Mongo work (which
isn't public-facing), but we've been seriously looking at Mongoid for
future development ... if that makes any difference.

Any insights you can offer on using Sphinx with MongoDB would be
useful.

Thanks,
-Jeff

[Pat Allan]

Hi Jeff

I've not investigated this, but I can tell you right now that it's unlikely.

Sphinx expects unsigned integers as document ids, and pulls data directly from the database (or an XML source - though TS doesn't support the latter). While I think the first may be possible with Mongo (I've not used it, so not sure), the second almost certainly isn't.

That said, if you want to investigate further, that'd be fantastic - but my guess at this point is that it's just not feasible. Given my lack of MongoDB experience, though, I may be completely wrong.

Cheers

--
Pat

> --
> You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group.
> To post to this group, send email to thinkin...@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphi...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
>

[bogn]

Sphinx can be used with MongoDB through xmlpipe2 as marked out here:
http://www.scribd.com/doc/33308510/MongoDB-Full-Text-Search-With-Sphinx