I have problem with saving data to sqldelight 1.4 in Android app. I created table: CREATE TABLE myTable( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT ); In repo class I have insert f...

I'm trying to use sqldelight to insert an item, but to also return the id of the item after it's inserted. There doesn't seem to be a way to do this in sqldelight. I can call something like SELECT...

I am trying to create a small app using Kotlin Multiplatform where i can save book titles and their authors but i'm struggling with the data classes and how to map them together so that i get the a...

I have a KMM project and want to use SqlDelight library, but when I build the project database schema not generated and table entities also. actual class DatabaseDriverFactory(private val context: ...

I have a relatively large db that may take 1 to 2 minutes to initialise, is it possible to load a pre-populated db when using sqldelight (kotlin multiplatform) instead of initialising the db on app...

I am trying to add more columns in table in SQLDelight. I have made a migration file 1.sqm. In migration file it gives error that no table found. My build.gradle.kts: sqldelight { database("...

After modifying the sq file by renaming one of the tables and adding one more table I didn't find any place to specify that database schema or version has been changed and I want no migration - jus...

Android Studio gives me the following error code after I copied my project. Duplicate content roots detected: Path [/home/addi/AndroidStudioProjects/appfolder/appname/app/build/generated/sqld...

This is my table structure CREATE TABLE Missions( MissionID INTEGER NOT NULL UNIQUE, MilestoneID INTEGER NOT NULL, MissionExpiry TEXT, MissionStatus TEXT, Count INTEGER DEFAULT 0, MilestoneLi...

I'm currently looking at having a KMM application backed by SQLdelight for all domain-related operations. SQLdelight seems to provide really nice interfaces, however it seems like all the write cal...

I want to model relationships with SQLDelight, especially a one to many relationship. I have 2 tables: recipe and ingredient. For simplicity they look like this: CREATE TABLE recipe ( id INTEGER N...

I'm wondering how to write unit tests for SQLDelight on KMM. First of all, I can't even add the SQLDelight dependency correctly. val commonTest by getting { dependencies { implementation(kotlin(...

Ignoring multiplatform advantages, is there any advantage of using room over sqldelight?

There are apparently Kotlin coroutines extension functions for SqlDelight, but I don't know how to implement them since I can't find documentation. I have a normal query that looks like this: val...

We want to migrate our App from Room to SQLDelight to reuse it on iOS (it is a Multiplatform project). I noticed however that SQLDelight is much slower than Room. For some queries it is around 10 t...

In some of the stack overflow answers say 1.create new table and drop old tables. how to do that? 2.what is the use of sqm file and when we need to use? 3.what's is the use of deriveSchemaFromMigra...

I am working on kotlin multiplatform project. I successfully added several libs to my build.gradle (ktor, coroutines, ...). I also added sqldelight to common, android and ios sourcesets. My ios dep...

I am implementing repository pattern in RxJava using SqlBrite/SqlDelight for offline data storage and retrofit for Http requests Here's a sample of that: protected Observable<List<Item>&...