sql 2020-03-24 | Slack Archive

41ph4_Ph4un11:03:50

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

41ph4_Ph4un12:03:36

ah I see I see. Yes yes yees

41ph4_Ph4un12:03:53

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

41ph4_Ph4un12:03:50

luckily configuring dependencies in Clojure is a breeze

Ahmed Hassan12:03:54

Use Migratus

41ph4_Ph4un12:03:09

ah, does that work with next.jdbc?

41ph4_Ph4un12:03:25

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

41ph4_Ph4un12:03:24

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

jussi14:03:25

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

seancorfield16:03:42

#Also sent to the channel

You probably want the :timeout option for statement execution (it's in the docs).

seancorfield16:03:14

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

seancorfield16:03:29

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).

dharrigan15:03:59

@theamazingekko I use Flyway for migrations

dharrigan15:03:06

Works wonderfully well

seancorfield16:03:42

replied to a thread: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

You probably want the :timeout option for statement execution (it's in the docs).

2020-03-24

Channels