
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