A modern programming language that makes developers happier.

kotlinlang

Hey I was wondering if anyone could suggest a good database driver that supports MySQL and SQLite.
I originally wanted to use jasync-sql but it doesn't seem to support SQLite

Exposed is more like an ORM rather than Driver

er I may be mistaken in my definitions but I'd much rather just write out my SQL statements

I would say just use SQLDelight if you want to use raw SQL with Kotlin, but you could also just use JDBC directly

I was looking into SQLDelight but it doesn't seem to support connecting to MySQL.

I want to support both so I could do my testing in SQLite and do beta testing in SQLite without caring about a DB then when needed just easily switch to MySQL.

I originally wanted to use jasync-sql since it also seems to have decent support for coroutines

<https://cashapp.github.io/sqldelight/2.0.0/jvm_mysql/> ?

Oh it supports MySQL? I read somewhere it apparently didn't but I guess that was old

Ya, I use it with MySQL in a project, it works pretty well