<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Looks good! I liked relational algebra much much more than SQL, so I'll
certainly have to look into that.<br>
<br>
Thanks,<br>
Peter<br>
<br>
Justin Bailey wrote:
<blockquote
cite="mid:a45dff840801021522i3bdcbfc1q3546d84bed506b4d@mail.gmail.com"
type="cite">
<pre wrap="">I can speak to haskelldb a little, see below:
On Jan 2, 2008 3:50 AM, Peter Verswyvelen <a class="moz-txt-link-rfc2396E" href="mailto:bf3@telenet.be"><bf3@telenet.be></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">· regarding Haskell and databases, the page
<a class="moz-txt-link-freetext" href="http://haskell.org/haskellwiki/Libraries_and_tools/Database_interfaces">http://haskell.org/haskellwiki/Libraries_and_tools/Database_interfaces</a>
describes a few, but which are the ones that are stable and practical? Any
user experiences?
</pre>
</blockquote>
<pre wrap=""><!---->
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
Cabal.
Hope that helps!
Justin
</pre>
</blockquote>
<br>
</body>
</html>