any idea about database affairs in kotlin? exposed...

# announcements

[Ray Eldath]

any idea about database affairs in kotlin? exposed is gonna kill me... 😣

i think i will turn for dbutils eventually... though i do really like exposed... 😞

[Amirul Zin]

Have you tried MyBatis? The kotlin support looks pretty nice.

https://mybatis.org/mybatis-dynamic-sql/docs/kotlinMyBatis3.html

[Ray Eldath]

thanks! it looks pretty elegant 😉

i'll look at krotm as well.

[Mike]

And depending on what you want your DB support to do, https://spring.io/projects/spring-data-jdbc is clean, and supports Kotlin data classes for easy DDD focused interactions.

No reflection used here. All class generation for Java and Kotlin.

[Ray Eldath]

thanks for the link! i've heard that spring have fantastic Kotlin supprt, ll turn for it when i want to build my application with spring.

currently i'm using jOOQ to handling all database stuff, and it works incredibly well!!! 😄 😁

the fluent api and auto-generated mapper is very helpful, the pojo is generated with componentN makes them seamlessly integrated with deconstruction pattern in kotlin, and it's inmutable.

there's a related issue on github, saying they're working to let data class generated IIRC. anyway, i like jOOQ, at least lately 😉

[Mike]

I've heard great things about JOOQ but haven't been able to use it on a project yet.