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/