[Haskell-cafe] haskell -> db, on Solaris

[Alistair Bayley]

> > http://www.haskell.org/haskellwiki/Applications_and_libraries/Database_interfaces
> >
> > 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