3 ms·
Some corrections/comments/questions: > Opaleye ... no join support (simulated via sub selects) This is true for exactly one reason: despite being raised frequ
by tome 11y ago
Some corrections/comments/questions:
> Opaleye ... no join support (simulated via sub selects)
This is true for exactly one reason: despite being raised frequently, nobody has ever been able to demonstrate any performance difference between subselects and joins (in Postgres)! As soon as someone does, they should file an issue (https://github.com/tomjaguarpaw/haskell-opaleye/issues/ https://github.com/tomjaguarpaw/haskell-opaleye/issues/) and I'll add joins forthwith.
> Opaleye ... tough syntax to parse
What do you mean by this? The Haskell syntax of Opaleye, or the generated SQL?
> Esqueleto ... Postgres only
You're incorrect about this. From your Esqueleto link:
"It has many kinds of backends, such as SQL backends (persistent-mysql, persistent-postgresql, persistent-sqlite) and NoSQL backends (persistent-mongoDB)."
> Esqueleto ... can't/doesn't prevent invalid sql
But you're right about this.