Is it possible to use sqldelight with Turso’s <lib...
# squarelibrariesm
Mark
11/19/2024, 2:49 PMIs it possible to use sqldelight with Turso’s libsql? The libsql Android API doesn’t seem they provide any implementation of
SupportSQLiteDatabasej
jw
11/19/2024, 3:19 PMYou'll have to write your own driver then
m
Mark
11/21/2024, 5:43 AMAnd so it’s not necessary to provide an implementation of SupportSQLiteDatabase, right? I’d just need to handle the create/upgrade etc (as well as provide driver implementation)?
j
jw
11/21/2024, 5:44 AMYep
m
Mark
11/21/2024, 5:58 AMlibsql uses the same db file as the Android framework (just a standard local sqlite db file), so I’m thinking a lot of the create/upgrade logic, I already have, can be reused. Would it make sense to open the database using existing logic (SQLiteOpenHelper etc) just so the create/migrations can run, then closing it, then opening with libsql API and proceeding using custom libsql driver?
j
jw
11/21/2024, 5:59 AMThe migration API is very basic
jw
11/21/2024, 5:59 AMProbably 15-20 LOC
👍 1
jw
11/21/2024, 5:59 AMI would do it yourself
m
Mark
11/21/2024, 5:59 AMyeah definitely cleaner
j
jw
11/21/2024, 6:00 AMIt's basically this: https://github.com/JakeWharton/dodo/blob/trunk/src/main/kotlin/com/jakewharton/dodo/db.kt
🙏 1
6 Views