Hello everyone. I think about using ktor for the n...

# ktor

[Goetz Markgraf]

Hello everyone. I think about using ktor for the next backend instead of spring. Can anyone recommend a DB access Library?
On my shortlist, I have
• exposed
• KTORM
• Hibernate
Personally, I don’t want to use Hibernate, since it relies on mutable fields for an entity.
exposed is not (yet) supported by someone and not even 1.0
I cannot find the people behind KTORM – is there is an organization behind it.

What would you suggest? And why?

[CLOVIS]

KMongo is great, but it doesn't seem like you're open to MongoDB. Exposed is good too.

Note that whatever selection you decide, it is completely different from Ktor so you can decide what you want

[hfhbd]

Another (more mobile) framework: sqldelight
https://cashapp.github.io/sqldelight/2.0.0-alpha05/

[Maksim Sadovnikov]

jooq
https://www.jooq.org/doc/latest/manual/getting-started/jooq-and-kotlin/

[Goetz Markgraf]

@CLOVIS, thanx for your input

KMongo is great, but it doesn’t seem like you’re open to MongoDB

I am personally open to it, but we have to connect to an MySQL.

Exposed is good too.

Yes, I think so, too. But can you rely a customer project on it? Do you have any experience?

it is completely different from Ktor

yes, I know.

[CLOVIS]

You should probably ask in #exposed if you want testimonies

[Goetz Markgraf]

THX. I didn’t know this channel. I’ll do

[Austin Pederson]

We setup a really small CRUD API using SQLDelight and it was pretty nifty to work with so I can say that it is 100% doable (at least in a POC kind of way)

[Roland]

I would recommend (K)GraphQL + sqldelight/kmongo etc., than you can use an Apollo Client in frontend. That's also pretty multiplattform friendly.

[Ryan Brink]

I've been very happy with Komapper https://www.komapper.org

[helpermethod]

Wow, komapper looks awesome!