I had to do some database related stuff, so after reading the nice paste app for happstack tutorial by John MacFarlane, I dug into HDBC.

HDBC's interface is pretty simple, since it's a low level API.

You write queries like

1
2
3

select * from awesome_table where id = ?

update awesome_table set name = ?, desc = ? where id = ?

then you pass in a list of values, which get interpolated into the query.

Skipping some useless rant ...

In conclusion, it's just too painful to get any thing more then CRUD done.