...

http://www.haskell.org/haskellwiki/Applications_and_libraries/Database_inter...

If you want to talk to MySQL, you have a few choices.

HDBC has an ODBC interface that lets you use any ODBC provider, so you'll be able to talk to both MySQL and Oracle with it.

HaskellDB can bridge to HDBC, I believe, so that will let you do type-safe SQL.

There's also Takusen, which can talk to Oracle, but not MySQL.

Yes, thanks. But the emphasis was on Solaris. I don't quite understand what is the common way to access databases on Solaris. Is it odbc? And how Haskell libraries connect to that? I mean, Takusen is designed to use odbc and nothing else (afaik), for example.

Takusen uses OCI to talk to Oracle, so it should work on any Oracle (& GHC) platform. However, no ODBC or MySQL backend yet (I'm working on ODBC right now, but it's slow going...). I imagine that the common way to access databases on Solaris is the same as on other Unix platforms, which is probably to use the vendor's API directly. There is also http://www.unixodbc.org/, which appears to support Solaris, but I can't vouch for it from a usability perspective i.e. how hard is it to get working, and to get working with HDBC or HSQL. I'd recommend giving unixodbc + hsql/hdbc a go, and let us know of any problems. Alistair

Thanks, all. I forgot, that Takusen uses OCI, not ODBC, sorry. I'm getting it now. |'ve looked more closely at HSQL, also. Indeed, it uses native interfaces, as Alistair pointed out. And since it supports both Oracle and MySql, I think it will be my first try. Typeful queries are not important to me. But having one library instead of 2 distinct ones is appealing. And avoiding depending on a separate unixODBC is also good. 2007/7/12, Bryan O'Sullivan :

Daniil Elovkov wrote:

...

Yes, thanks. But the emphasis was on Solaris. I don't quite understand what is the common way to access databases on Solaris. Is it odbc?

ODBC is a standard, fairly portable database interface. Since HDBC has ODBC bindings, it can in principle talk to any database that provides an ODBC interface.