3 ms·

> For databases, there are a myriad of options and tutorials for those Where? The only half appealing type safe query DSL that I've found for Haskell is Esquel

> For databases, there are a myriad of options and tutorials for those Where? The only half appealing type safe query DSL that I've found for Haskell is Esqueleto, and that features a blank github readme[1] o_O [1] https://github.com/meteficha/esqueleto https://github.com/meteficha/esqueleto

wraithm112 12y ago
Groundhog is pretty awesome[1]. Persistent also works, but it does some wonky stuff on SQL databases. Acid-state is really neat! Of course, there's stuff like postgresql-simple, but that's not very type safe. [1]https://www.fpcomplete.com/school/to-infinity-and-beyond/pick-of-the-week/groundhog https://www.fpcomplete.com/school/to-infinity-and-beyond/pic... Edit: Also, esqueleto has a pretty okay looking hackage page[2], but I've never used esqueleto, so I don't really know. [2]http://hackage.haskell.org/package/esqueleto http://hackage.haskell.org/package/esqueleto
- carabolic 12y ago
  Do you have any experience with Database Supported Haskell (DSH) [1]? I've just recently found it and it seems very nice. I didn't have the time to test it though. [1] https://hackage.haskell.org/package/DSH https://hackage.haskell.org/package/DSH
  - wraithm112 12y ago
    No, I don't. That seems really cool though! Thanks for pointing that out.
- virtualwhys 12y ago
  Did not know about Groundhog, thanks. Looking into the docs Groundhog does not support joins (same deal with Persistent), which I'd say is a deal breaker for most (non-trivial) applications. Acid-state is a different beast entirely, seems to be similar to Clojure's Datomic. That leaves us with Esqueleto for real world type safe database access (with no SQL Server or Oracle support). I want to jump ship from Scala to Haskell but there are some gaps to be filled yet before leaving the batteries included Java ecosystem.
  - cgag 12y ago
    Does esqueleto not do it for you? Can you be explitit about whats missing for you? Is it just oracle or sql server support?

wraithm112 12y ago

Groundhog is pretty awesome[1]. Persistent also works, but it does some wonky stuff on SQL databases. Acid-state is really neat! Of course, there's stuff like postgresql-simple, but that's not very type safe. [1]https://www.fpcomplete.com/school/to-infinity-and-beyond/pick-of-the-week/groundhog https://www.fpcomplete.com/school/to-infinity-and-beyond/pic... Edit: Also, esqueleto has a pretty okay looking hackage page[2], but I've never used esqueleto, so I don't really know. [2]http://hackage.haskell.org/package/esqueleto http://hackage.haskell.org/package/esqueleto

carabolic 12y ago
Do you have any experience with Database Supported Haskell (DSH) [1]? I've just recently found it and it seems very nice. I didn't have the time to test it though. [1] https://hackage.haskell.org/package/DSH https://hackage.haskell.org/package/DSH
- wraithm112 12y ago
  No, I don't. That seems really cool though! Thanks for pointing that out.
virtualwhys 12y ago
Did not know about Groundhog, thanks. Looking into the docs Groundhog does not support joins (same deal with Persistent), which I'd say is a deal breaker for most (non-trivial) applications. Acid-state is a different beast entirely, seems to be similar to Clojure's Datomic. That leaves us with Esqueleto for real world type safe database access (with no SQL Server or Oracle support). I want to jump ship from Scala to Haskell but there are some gaps to be filled yet before leaving the batteries included Java ecosystem.
- cgag 12y ago
  Does esqueleto not do it for you? Can you be explitit about whats missing for you? Is it just oracle or sql server support?