[Haskell-cafe] Consensus about databases / serialization
bf3 at telenet.be
Thu Jan 3 08:58:47 EST 2008
Looks good! I liked relational algebra much much more than SQL, so I'll
certainly have to look into that.
Justin Bailey wrote:
> I can speak to haskelldb a little, see below:
> On Jan 2, 2008 3:50 AM, Peter Verswyvelen <bf3 at telenet.be> wrote:
>> · regarding Haskell and databases, the page
>> describes a few, but which are the ones that are stable and practical? Any
>> user experiences?
> I started looking at haskell database libraries to generate SQL for
> me. Haskelldb does this well - it uses a higher-level representation
> of queries based on "relational algebra" (also the basis of SQL) which
> is pretty easy to understand if you know SQL. It takes care of a lof
> the details of generating SQL strings, and does it in a mostly
> type-safe way.
> It is a bit complicated to install the library and all its
> dependencies, because it can work with 3+ (mysql, postgres, odbc)
> databases using two different backends (hdbc and hsql). I chose to go
> with HDBC because it compiled on Windows and postgres because thats
> what we have at my workplace. Once I got it built and installed its
> worked well for me.
> Until the most recent versions though, it added a "distinct" operator
> to all select statements. I submitted a patch which was accepted and
> now that behavior is no longer the default. It is semi-actively
> maintained by the original authors and Bjorn, at least, has been very
> responsive to my queries on the haskelldb-users mailing list. He also
> has made minor updates to keep it compiling with the latest GHC and
> Hope that helps!
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Haskell-Cafe