hey guys. i just jumped into developing a backend with kotlin yesterday (based on ktor); looking for...

# server

[damian]

hey guys. i just jumped into developing a backend with kotlin yesterday (based on ktor); looking for a good solution for database access at the moment. so far i think i’ll go with exposed, but i cant really find samples/tutorials for the set-up, best-practices or something. in theory i’d want to deploy to heroku at some point (so postgresql i guess). maybe someone has some insights/hints for me?

[dave08]

You might also look into #squash, which is more light weight... or the vert.x clients, if you need async...

[bdawg.io]

Async is really nice if rxjava or coroutines interest you

[damian]

thanks. i’ve already switched over from exposed to squash, trying it atm. first impression is that mapping a database table to objects is tedious (MyTable.select(…fields…).execute().map { MyObject(it.get<String>(0), it.get<String>(1), …)}) - is there a better way to do this?

[dave08]

I've personally been wanting to switch to it, but haven't gotten there yet... I suggest you ask in #squash channel, good luck!

[aglassman]

I’ve been converting data classes to JSONB for postgres. It’s really slick.

[aglassman]

I’ve been using GSON, but now that kotlin has better JSON support, I may try that out.