sql

All things SQL and JDBC...
41ph4_Ph4un 2020-03-24T11:55:50.282500Z

Jesus I'm having a pain trying to add ragtime for database migrations xD

41ph4_Ph4un 2020-03-24T12:12:36.283100Z

ah I see I see. Yes yes yees

41ph4_Ph4un 2020-03-24T12:18:53.283800Z

uhuh uhuh! riiight.. so i just need to use older jdbc for migration scripts

41ph4_Ph4un 2020-03-24T12:26:50.284900Z

luckily configuring dependencies in Clojure is a breeze

Ahmed Hassan 2020-03-24T12:26:54.285Z

Use Migratus

41ph4_Ph4un 2020-03-24T12:27:09.285300Z

ah, does that work with next.jdbc?

41ph4_Ph4un 2020-03-24T12:27:25.286Z

might take a look at it since it's nicer if I need less dependencies

41ph4_Ph4un 2020-03-24T12:44:24.288800Z

@ahmed1hsn, thx, got that working and it's pretty nice

jussi 2020-03-24T14:13:25.290400Z

Hey, how can I set a timeout for all SQL operations? Using hugsql & adapter for next.jdbc. Could use setNetworkTimeout, but not sure where to get executor for it

dharrigan 2020-03-24T15:22:59.290800Z

@theamazingekko I use Flyway for migrations

dharrigan 2020-03-24T15:23:06.291Z

Works wonderfully well

seancorfield 2020-03-24T16:31:14.291800Z

That will provide a "query timeout" so that operations will timeout if they don't complete in time.

seancorfield 2020-03-24T16:33:29.292Z

For connections, you probably want login timeout, which is available on master but not yet in a release (`.setLoginTimeout` is a method on DataSource but was not available on the reified version you get from get-datasource on a hash map or JDBC string -- it is available on a pooled connection datasource).