Is there anything like <https://github.com/tpoleca...

# getting-started

[reactormonk]

Is there anything like https://github.com/tpolecat/doobie in Kotlin?

[Sam]

Maybe https://github.com/JetBrains/Exposed?

[reactormonk]

What makes doobie so nice is that it isn't really an ORM, more of a typecheck layer over raw SQL. It works with prepared statements instead of DAO

[AdamW]

You can use Exposed for its DSL exclusively and avoid the DAO altogether.

[reactormonk]

Ah, still Kotlin though. In doobie you'd basically write raw SQL. I guess it'll do.

[AdamW]

There’s also SQLDelight which is worth checking out: https://github.com/cashapp/sqldelight

[reactormonk]

That looks interesting. Still going away from raw SQL though 😞

[reactormonk]

A bit different workflow. Lemme give it a spin. 🤔

[Ulrich Schuster]

We use https://www.jooq.org/

[Goetz Markgraf]

I would also suggest to use Exposed. The nice thing about it being a type safe functional SQL client is, that each IDE can add code completions. I prefer that to write SQL statements in a string.

We don’t use the DTO layer, just the DSL. Reads a lot like read SQL statements, but in a functional kotlin DSL way.

[Alexander Ioffe]

I built exactly this kind of product. Have a look at terpal-sql. It uses a compiler-plugin to allow safe Sql("$dollar_sign_interpolation") in strings that are automatically passed into JDBC prepared-statement parameters. Also it supports Kotlin Multiplatform Android IOS, and Native targets:
(there's a channel for it here: #C07CVTQ6WBG)
https://github.com/ExoQuery/terpal-sql