Heyy, can I use JPA in Ktor? I tried many orms lik...

# ktor

[Okan Yıldırım]

Heyy, can I use JPA in Ktor? I tried many orms like Exposed or Ktorm, I didn't like any of them like Spring Data JPA. I was just simply creating a class with annotations and a repository, thats all. I am looking for something similar for Ktor

[FunkyMuse]

https://hashnode.com/post/how-i-built-my-first-kotlin-vertx-hibernate-stack-cixhsnv1b002au6539uu6iw7r

Hope this helps you

[Okan Yıldırım]

will check it, thank you!

[FunkyMuse]

However using JPA outside spring is just simply put, suicide, jooq works the best and i can see exposed is getting traction, I'm using jooq + postgresql and it's a breeze

[Okan Yıldırım]

Well, my point is using a simple thing like JPA, using it is not necessary

[Okan Yıldırım]

I mean, I tried Exposed, it was like writing the same classes three times

[Okan Yıldırım]

I will check jooq, too. Thank you for suggestion

[S.]

https://github.com/komapper/komapper
if you want something with R2DBC

[kenkyee]

Quarkus supports JPA FYI...

[Hamza GATTAL]

In kotlin premier event Hadi said "the team have a plan for databases" , maybe in the future will see a library like jpa working exclusively with ktor

[hfhbd]

Alternative you could use sqldelight

[Okan Yıldırım]

@Hamza GATTAL it would be awesome if they just do something special for Ktor

[Okan Yıldırım]

I mean Ktor is very fun to use but the Database part makes me hate what I code

[Okan Yıldırım]

Thanks for other suggestions, I never heard some of them, let me check these

[Okan Yıldırım]

@S. Komapper looks inetersting let me give it a try

[Junior Zytkowski]

Some people are working on a project to reduce boilerplate on Ktorm.

You can check it out at https://github.com/kotlin-orm/ktorm-ksp

We've tried implementing Hibernate on Ktor projects and I have to agree with @FunkyMuse, it's pretty suicidal to implement it.

I personally don't enjoy exposed, on Ktorm you have to map an Entity and a Table (they are similar, but useful for typed queries).

Can you further explain why you think you're writing too much code with Ktorm?

Edit 1: Removed blank line