Oracle and thinking_sphinx

[Gustavo de Sá Carvalho Honorato]

Hello,

how can I get Thinking Sphinx working with Oracle? Any special configuration is required?

Thanks,

Gustavo

[Pat Allan]

Hi Gustavo

Sphinx itself does not support Oracle, so Thinking Sphinx doesn't. Sphinx 0.9.9 and (I assume) 1.10 supports ODBC as a work-around - and there may be a fork of TS somewhere that does support ODBC, but the main release does not. To be honest, not entirely sure that would be possible (partial support, yes, but all features, unlikely).

So the short answer is: you can't use Thinking Sphinx and Oracle together.

I'm kinda happy to accept patches for ODBC/Oracle, except I don't have Oracle, so I can't test against it (and given it's commercial, not rushing to purchase a copy for just that purpose).

--
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.

[Gustavo de Sá Carvalho Honorato]

On Sun, Dec 19, 2010 at 5:29 AM, Pat Allan <p...@freelancing-gods.com> wrote:
> Hi Gustavo
>
> Sphinx itself does not support Oracle, so Thinking Sphinx doesn't. Sphinx 0.9.9 and (I assume) 1.10 supports ODBC as a work-around - and there may be a fork of TS somewhere that does support ODBC, but the main release does not. To be honest, not entirely sure that would be possible (partial support, yes, but all features, unlikely).

I've found this two forks which is said to support Oracle. Which one
you recommend me?

https://github.com/cjk/thinking-sphinx
https://github.com/ebeigarts/ts-xml

>
> So the short answer is: you can't use Thinking Sphinx and Oracle together.
>
> I'm kinda happy to accept patches for ODBC/Oracle, except I don't have Oracle, so I can't test against it (and given it's commercial, not rushing to purchase a copy for just that purpose).

Oracle has a free version called Oracle Express Edition. Anyone can
download this version from their website at no charge. I'd like to
contribute to TS but I suspect that I didn't have the necessary
experience with RoR to do that right know.

[Pat Allan]

I'm not sure which fork is better - but both are several months old. Still, it's worth giving both a spin.

Maybe start with Edgars', as he has at least a little documentation? I think for Claus', you'll need to look through for his commits.

--
Pat

[Pat Allan]

Hi Mohith

At this point in time, there's nothing in any version of Thinking Sphinx that adapts the SQL commands to Oracle. I'm open to pull requests to change this, but I don't have the knowledge/time to add it in myself.

Kind regards,

--
Pat

On 19/04/2013, at 12:53 PM, Mohith Thimmaiah wrote:

> Folks - sorry to bring this up again but any chance of TS working with Oracle either via ODBC or via the ruby/oci/oracle-enhanced-adapter. Most banks are still using Oracle and my client wont switch to MYSQL.
>
> Cheers

> --
> You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group.

> To unsubscribe from this group and stop receiving emails from it, send an email to thinking-sphi...@googlegroups.com.

> To post to this group, send email to thinkin...@googlegroups.com.

> Visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>