A modern programming language that makes developers happier.

kotlinlang

Made this channel to discuss the JDBI library <https://jdbi.org/>

<@U01363CQGGJ> :wave: hey! I didn’t know ios used jdbi :stuck_out_tongue:

Yup you are right Actually i am learning Android so thats the reason

Android uses jdbi? I would have assumed it would be all based on room

Hi! Can anyone point me toward docs / examples for Kotlin JDBI in micronaut? I can't seem to get started with (by possibly injecting?) the JDBI handle from my hikari/jdbc connected database to get a basic query running. I feel like once I know how I can access the handle, the rest should pretty easy

<@U01QMEUBWTW> <https://github.com/tipsy/javalinstagram/tree/master/src/main/kotlin/javalinstagram> here is an example of using jdbi with kotlin

<https://gitlab.com/asad-awadia/kotlin-server-app/-/blob/master/src/main/kotlin/org/example/Hello.kt#L23> this is from my repo

```
val props = Properties()
props.setProperty("dataSourceClassName", "com.impossibl.postgres.jdbc.PGDataSource") // <https://github.com/impossibl/pgjdbc-ng>
props.setProperty("dataSource.user", "postgres")
props.setProperty("dataSource.password", "password")
props.setProperty("dataSource.databaseName", "postgres")

val config = HikariConfig(props)
config.jdbcUrl = "jdbc:<postgresql://localhost:5432/postgres>"

val ds = HikariDataSource(config)
val connectionPooledJdbi = Jdbi.create(ds)

connectionPooledJdbi.useHandle&lt;Exception&gt; {
   println(it.createQuery("SELECT * from users").mapToMap().first())
}```