Hi I am looking in the docs for advice or examples on using a database library with http4k but haven...

# http4k

[Nicola]

Hi I am looking in the docs for advice or examples on using a database library with http4k but haven't found any..
Is there a recommended approach or library?
I basically look for the usual things: connection to a relational database, a (thread safe) connection pool, orm is not mandatory (I prefer writing my sql by hand but I do not regret it if present ).

[Nicola]

Running migrations automatically, would be another feature I am looking for.

[dave]

We don't have anything specific in the http4k docs because we deliberately stay away from general advice. However, @dmcg has been covering this exact type of thing on his excellent youtube channel series: https://www.youtube.com/channel/UCWZnyGwHUjIcP2mdz2B5qzQ

[Nicola]

I will check it out, thanks a lot 👍

[dmcg]

@Nicola I have a playlist that might help - https://www.youtube.com/playlist?list=PL1ssMPpyqoci7HFHOmNbzkT_OAVqr9JBu
I started using Exposed, but switched to jOOQ because it felt nicer for complex queries to me. I cover FlyWay for migrations, including running the migrations against production from the Gradle build.

[Nicola]

thanks @dmcg