https://kotlinlang.org logo
Title
a

Ahsan Raza

12/21/2019, 10:47 AM
Hi, I just started backend with Ktor framework, I see documentation about ktor but there is no help about Database Connectivity and Staf like that So any Guide about Database Connection?
t

Timur Atakishiev

12/22/2019, 11:41 AM
Hi, I think these one is pretty clear https://ryanharrison.co.uk/2018/04/14/kotlin-ktor-exposed-starter.html These example for using exposed with ktor
a

Ahsan Raza

12/22/2019, 5:04 PM
Thanks @Timur Atakishiev It's very helpful for me
I think Jooq library is better than Exposed because it generate all schema related to database automatically...... @Timur Atakishiev what's your opinion?
t

Timur Atakishiev

12/23/2019, 10:12 AM
I tried jooq a bit, main problem that I faced was the lack of gradle plugins. https://github.com/etiennestuder/gradle-jooq-plugin I tried to use these one, but again, lack of documentation for gradle.kts. If there will be a official gradle.kts plugin it is going to be better. By the way, the jooq is generating your "entity" according to your database,what means you will not have a physical representation of your table in your code, for me, in the beginning it was confusing
@Ahsan Raza ^^
a

Ahsan Raza

12/23/2019, 2:16 PM
Thanks @Timur Atakishiev Yes Jooq generate entity related to Database............Is there any gradle plugin for auto generating objects for exposed from sql schema?
t

Timur Atakishiev

12/23/2019, 3:12 PM
I sent the plugin in previous message, but still it is jot good. I suggest you to use maven