[Haskell-cafe] Re: programmatic DB interface?

[Günther Schmidt]

Hello Johannes,

I think you are looking for HaskellDB, you can find it on hackage. I've 
been working with it myself and can absolutely recommend it.

It is actively maintained by Justin Bailey.

It's a EDSL for relational algebra which gets translated into SQL. It 
can use HDBC for instance as its *driver* to databases supported by HDBC.

As with LINQ you need to put an initial effort into describing the 
tables and their columns of the database first, once that is done you 
can go ahead and express your queries in the EDSL, *typesafe* and 
higher-orderish too.

HaskellDB was originally developed by Daan Leijen and Erik Meijer, two 
of the great old ones, both very well known here in the Haskell community.

There are 2 papers describing the foundations of HaskellDB, google for

	Domain specific embedded compilers
		and
	The lambda calculus abroad (Chapter 5 of a rather large paper).

both authored by Daan Leijen and Erik Meijer.


HTH

Günther






Am 04.02.10 08:01, schrieb Johannes Waldmann:
> Hello.
>
> What is currently the recommended
> higher level data base interface for Haskell?
>
> I want to construct queries in a programmatic/algebraic way,
> and I want typed queries and results. - I guess I want LINQ.
>
> The examples in
> http://book.realworldhaskell.org/read/using-databases.html
> seem to construct queries as strings.
> That's horrible! Looks exactly like PHP!
>
> Well, no, but it's a lower abstraction level
> than that I want to work at.
> I'm sure I'm just missing some package/framework here.
>
> Would takusen help? Where's its home page?
> this does not work: http://darcs.haskell.org/takusen/
>
> Best, Johannes.
>
>
>
>
>
>
> _______________________________________________
> Haskell-Cafe mailing list
> Haskell-Cafe at haskell.org
> http://www.haskell.org/mailman/listinfo/haskell-cafe