[Haskell-cafe] Typesafe multi-table PostgreSQL queries in Yesod with schema names?

[Tom Ellis]

On Wed, Nov 20, 2013 at 02:42:05AM +0000, Tom Ellis wrote:
> On Tue, Nov 19, 2013 at 09:51:20PM -0430, Manuel Gómez wrote:
> > I’m looking for a rather specific point in the design space for
> > database access libraries in Haskell and I’m having some trouble
> > figuring out whether any existing library covers my use cases.
> > 
> > Specifically, I need to
> > 
> > 1.  get a Yesod application to access a PostgreSQL database without
> > having to reinvent the universe to get them decently integrated,
> > 
> > 2.  write queries in an EDSL with a good approach to composability and
> > decent static verification against some declared form of the database
> > objects,
> > 
> > 3.  be able to perform joins
> > 
> > 4.  be able to specify the schema name for each database object used in queries
> 
> I'm working on a Haskell relational query EDSL similar in spirit to
> HaskellDB.  It certainly satisfies your requirements 2 and 3.  I'm not
> exactly sure what exactly your requirements 1 and 4 mean but feel free to
> contact me off list and we can discuss it further.

For the sake of the mailing list archives I am replying here to confirm that
my Haskell relational query language targeting Postgres has now indeed been
published:

    http://hackage.haskell.org/package/opaleye

Tom