Anyone know a good sql library for sqlite? I am us...

# getting-started

[Vishnu Shrikar]

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

[Ruckus]

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.

[Stephan Schröder]

my former colleague is a fan of JOOQ for DB-access. It's originally a Java program, but it supports Kotlin.

[Vishnu Shrikar]

both those look viable thanks

[Johann Pardanaud]

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)

[Vishnu Shrikar]

with jOOQ i am wondering what parts of it are proprietary as I would only be using free version

[Johann Pardanaud]

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/