Hi, I just started backend with Ktor framework, I ...

# server

[Ahsan Raza]

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?

[Timur Atakishiev]

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

[Ahsan Raza]

Thanks @Timur Atakishiev It's very helpful for me

[Ahsan Raza]

I think Jooq library is better than Exposed because it generate all schema related to database automatically...... @Timur Atakishiev what's your opinion?

[Timur Atakishiev]

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

[Timur Atakishiev]

@Ahsan Raza ^^

[Ahsan Raza]

Thanks @Timur Atakishiev Yes Jooq generate entity related to Database............Is there any gradle plugin for auto generating objects for exposed from sql schema?

[Timur Atakishiev]

I sent the plugin in previous message, but still it is jot good. I suggest you to use maven