Safer SQL queries - Githubissues

elldritch / hipsterfy

Find out which Spotify hipsters you and your friends both like.

https://hipsterfy.com

Apache License 2.0

7 stars 0 forks source link

Safer SQL queries #7

Closed elldritch closed 4 years ago

elldritch commented 4 years ago

We do some PRETTY CRAZY things with SQL. postgresql-simple is clearly at its stretching point - making schema changes requires some involved ctrl+f and click testing. Also, there's quite a few redundant-ish queries.

I've heard good things about opaleye - maybe it's time to migrate to that as a DSL?

For examples of crazy things, see:

Raw SQL substitution in https://github.com/liftM/hipsterfy/blob/master/src/Hipsterfy/Jobs.hs

elldritch commented 4 years ago

Done, after migrating to Opaleye.