plins: Which DB are you using?

atm mysql

if you’re really worried about the async bit, you can use https://github.com/alaisi/postgres.async with postgres. Don’t know of a good alternative with mysql

you can also work around this by adding some kind of intermediary function that runs the SQL query via a threadpool, which once the query completes puts it onto a core.async channel. However, when I’ve played with things like this in the past, I’ve found it to be way more of a headache then it was actually worth, based off of the performance changes

you’re generally better off spending the time to reduce the number of DB calls you’re making and the performance of those calls, and just let the JVM do it’s stuff with thread switching

obvious depends on your usecase and what’s causing you to want this

i was thinking about heading down the road of thread pool + core.async … im coming from nodejs development and now compojure supports async routes so i was wondering if it was possible/worth to wrap sync jdbc calls on a thread pool with an async interface, maybe using channels

im actually quite surprised that theres not a stable solution implemented