what do other people use for dealing with database...

# server

[Nikky]

what do other people use for dealing with databases? it seems like exposed and squash is used widely,
but neither has builtin (and tested) migrations
i REALLY wish sqldelight supported postgres, but i guess it does not yet..
so what is the best (least painful) alternative ?

[poohbar]

I have a really good experience with jOOQ + Flyway

[Nikky]

i have just tried setting up jooq, their gradle integration is nonexistant .. at least using kotlin-dsl
how do you have it configured ?

[poohbar]

I use Spring autoconfiguration which supports jOOQ

[poohbar]

but really, it's just a matter of creating the DSLContext from database connection.

[poohbar]

or are you talking about the code generator?

[poohbar]

for generation i use the jooq-codegen-maven plugin

[poohbar]

I mean, it definitely took me more than 2 hours to set it all up. But I think it's worth it.

[Marc Knaup]

< plain old MongoDB ¯\_(ツ)_/¯

[Nikky]

@Marc Knaup do you use KMongo at all or any tools for helping with migrations ?

[Marc Knaup]

I don't use any tool for migration and I don't like KMongo. It messes too much with the data and queries.

What do you expect from a migration tool? Why not just trigger it manually?

[Nikky]

i have been experimenting around with it and thats what i will do
this should do as a stopgack measure until sqldelight supports postgres eventually