Free ODBC driver for Couchbase?


#1

HI there. I’m trying to get couchbase working with a Codeigniter application.
According to Codeigniter’s documentation, they will support ODBC abstraction layers.
http://www.codeigniter.com/user_guide/general/requirements.html

I did some initial googling and it seems that the ODBC driver for Couchbase is a paid solution vs. open source.
Is this understanding correct?
If so, what alternatives do I have? Many thanks!


#2

Yes Wooj, your understanding is correct.
Currently certified ODBC/JDBC drivers for Couchbase are provided by Simba.
http://www.simba.com/drivers/couchbase-odbc-jdbc/

I also see ODBC/JDBC drivers available from cdata (we haven’t tested that yet).

Only available open-source driver is JDBC-JSON (github.com/jdbc-json), which provides API to Couchbase over N1QL (query language from Couchbase, for querying JSON).

hth,
-Prasad


#3

Hi Wooj,

As Prasad pointed out, Simba has worked closely with Couchbase to ensure our drivers work well with any and all tools that have ODBC or JDBC connectivity. I would suggest you try out the drivers at http://www.simba.com/drivers/couchbase-odbc-jdbc/ to make sure they work for Codeigniter. If you have any problems, you can also contact us and we’ll work with you to ensure any issues are resolved.

Cheers,
Kyle


#4

Since it’s a paid product, I probably won’t be able to use it. Our shop only uses opensource.
Thanks for the response though


#5

Did you try the open source driver mentioned above? I’m interested to know whether it was any good.