https://kotlinlang.org logo
#getting-started
Title
# getting-started
v

Vishnu Shrikar

10/17/2023, 5:29 PM
Anyone know a good sql library for sqlite? I am using sqldelight and the library is not well made. I remember using a c# library that would basically generate all the database stuff for me (and was LINQ compatible) without writing queries. sqldelight is a advanced abstraction layer which is workable but fairly annoying to deal with. Another library that is a good example is sequelize and represents what I am looking for
r

Ruckus

10/17/2023, 5:40 PM
Does #exposed cover what you are looking for? (There's both a DSL API and a DAO API) If not, my apologies. I'm not familiar with either LINQ or sequlize, so I'm not sure what it is you are looking for.
s

Stephan Schröder

10/17/2023, 6:40 PM
my former colleague is a fan of JOOQ for DB-access. It's originally a Java program, but it supports Kotlin.
v

Vishnu Shrikar

10/17/2023, 7:38 PM
both those look viable thanks
j

Johann Pardanaud

10/17/2023, 10:17 PM
jOOQ is way more mature, if that’s what you’re searching for Exposed is the cool kid, but it lacks official support at the moment (it will come, it has been announced)
v

Vishnu Shrikar

10/17/2023, 11:06 PM
with jOOQ i am wondering what parts of it are proprietary as I would only be using free version
j

Johann Pardanaud

10/18/2023, 6:29 AM
If you use the classic databases you don’t have to pay, jOOQ is free for MySQL, PostgreSQL, SQLite, etc. https://www.jooq.org/download/