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

[Tom Ellis]

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.

Tom