I'm getting

java.lang.NullPointerException: null cannot be cast to non-null type androidx.room.compiler.processing.XAnnotation

when building iOS project after upgrading room to 2.7.0-beta01, but the Android project builds fine, full stack trace in thread.

Hi all! I'm having issues getting SwiftUI previews to work in Xcode since adding Room to my project. It's little diagnostic tool shows a bunch of missing (not found) sqlite3 symbols. Has anyone else had this problem?

Apple could not verify “androidx_sqliteJni10441516714404854592.tmp” is free of malware that may harm your Mac or compromise your privacy

how to get relation ordered ? for this relation:

data class ExamWithDates(
    @Embedded val exam: Exam,
    @Relation(
        parentColumn = "id",
        entityColumn = "id",
        associateBy = Junction(
            value = ExamDate::class,
            parentColumn = "examId",
            entityColumn = "dateId",
        )
    )
    val dates: List<Date>
)

I need dates ordered by date

Hi, is there any way to add Entities to our Database that come from a different module? I am currently building a kmp app and my setup is that I have a

:database

module where most Entities, Daos, etc. live. However i now have a different module, say

:test

where I want to add another Entity that I can add to my

@Database

Declaration in the

:database

module. Whenever I try, i get an error saying I need to add a migration. When I add a migration however, I get the following error (see 🧵 )

I'm using Room in Android with a room .db file with preload data in assets. When I compile and install the app in Android Studio emulator with new data (same schema but more or different data on the tables) in the .db preloaded database of assets floder... the app doesn't display it. It seems that room sees that the database has been already loaded from the .db file previously and doesn't update it. Is there any function or configuration in room necessary to always preload the .db file when it has new data? for example, after an update of the app etc... I don't want to preserve data, I just want that when an update of the app has come, or the .db file has more or different data, the .db file must be loaded, removing/ovewritting the previous cached database. Is there any built in feature in room to help with this? For example, specifying that the DB version has been changed, and telling Room that it must remove the cached version and reload the assets .db file. But is that possible?

Is there a way to write queries with window functions?

About preloading .db files, what means this sentence in the room documentation?

Note: Automated Room migrations rely on the generated database schema for both the old and the new versions of the database. If exportSchema is set to false, or if you have not yet compiled the database with the new version number, then automated migrations fail.

Specifically the part on if you have not yet compiled the database with the new version number. What is refering to? maybe google is telling that we need to open the sqlite file with an external tool and edit the pragma user_version value? Is that mandatory to make room migrations work?

Hello, I have an issue with Room and KSP (KMP context) and I don't seem to find a workaround. I am using Room 2.7.0-rc02, KSP 2.1.10-1.0.31 and Kotlin 2.1.10. I have a multi-module project with a module for the database and another one for the DAO. I always encounter the following issue:

[ksp] [MissingType]: Element 'com.msoula.hobbymatchmaker.core.database.dao.converters.Converters' references a type that is not present

My build.gradle (dao module - database is pretty similar)

import org.jetbrains.kotlin.gradle.dsl.JvmTarget

plugins {
    `kotlin-multiplatform`
    `android-library`
    alias(libs.plugins.compose.compiler)
    alias(libs.plugins.compose.multiplatform)
    alias(libs.plugins.serialization)
    alias(libs.plugins.room.multiplatform)
    alias(libs.plugins.ksp)
}

kotlin {
    applyDefaultHierarchyTemplate()

    androidTarget {
        compilerOptions {
            jvmTarget.set(JvmTarget.JVM_21)
        }
    }

    iosX64()
    iosArm64()
    iosSimulatorArm64()

    sourceSets {
        commonMain.dependencies {
            implementation(compose.runtime)
            implementation(libs.kotlinx.coroutines.kmp)
            implementation(libs.kotlinx.serialization)

            //
            implementation(libs.room.common)
            implementation(libs.room.runtime)
        }

        androidMain.dependencies {
            // Room
            implementation(libs.room.runtime.android)
        }
    }
}

room { schemaDirectory("$projectDir/schemas") }

android {
    namespace = "com.msoula.hobbymatchmaker.core.database.dao"
    compileSdk = AndroidConfig.COMPILE_SDK

    compileOptions {
        sourceCompatibility = JavaVersion.VERSION_21
        targetCompatibility = JavaVersion.VERSION_21
    }

    defaultConfig {
        minSdk = AndroidConfig.MIN_SDK
    }
}

dependencies {
    add("kspCommonMainMetadata", libs.room.compiler)
    add("kspAndroid", libs.room.compiler)
    add("kspIosX64", libs.room.compiler)
    add("kspIosArm64", libs.room.compiler)
    add("kspIosSimulatorArm64", libs.room.compiler)
}

And the converter class

class Converters {

    val jsonParser = Json { encodeDefaults = true; ignoreUnknownKeys = true }

    @TypeConverter
    fun fromGenreStringList(genres: List<String>?): String? {
        return genres?.joinToString(",")
    }

    @TypeConverter
    fun toGenreStringList(data: String?): List<String>? {
        return data?.split(",")?.map { it.trim() }
    }

    @TypeConverter
    fun fromGenreList(genres: List<Genre>?): String? {
        return genres?.let { jsonParser.encodeToString(it) }
    }

    @TypeConverter
    fun toGenreList(genreString: String?): List<Genre> {
        return genreString?.let { jsonParser.decodeFromString<List<Genre>>(it) } ?: emptyList()
    }

    @TypeConverter
    fun fromActorList(actors: List<Actor>?): String? {
        return actors?.let { jsonParser.encodeToString(it) }
    }

    @TypeConverter
    fun toActorList(actorString: String?): List<Actor> {
        return actorString?.let { jsonParser.decodeFromString<List<Actor>>(it) } ?: emptyList()
    }
}

I'm trying to encrypt the KMP's room DB for android and iOS using SQLCipher. For android, I can get it done by the openHelperFactory

internal fun getDatabaseBuilder(app: Application): RoomDatabase.Builder<MyDatabase> {
    val passphrase: ByteArray = SQLiteDatabase.getBytes("temp_passphrase".toCharArray())
    val factory = SupportFactory(passphrase)
    val dbFile = app.getDatabasePath(KMPConstants.DB_FILE_NAME)
    return Room.databaseBuilder<MyDatabase>(
        context = app,
        name = dbFile.absolutePath,
    )
        .openHelperFactory(factory)
}

How do I do it for iOS?

Dear all, any of you face massive build slowdown after adding room and KSP? My build takes longer than 30 minutes now. It is especially painful on Bitrise that I want to use for deployment. My gradle properties:

kotlin.code.style=official

kotlin.daemon.jvmargs=-Xmx6g

#Gradle
org.gradle.jvmargs=-Xmx6g -Dfile.encoding=UTF-8 -XX:+UseG1GC

#Android
android.nonTransitiveRClass=true
android.useAndroidX=true

# Enable Gradle Daemon
org.gradle.daemon=true
# Enable Configure on demand
org.gradle.configureondemand=true
# Enable parallel builds
org.gradle.parallel=true
# Enable Build Cache
#android.enableBuildCache=true
# Enable simple gradle caching
org.gradle.caching=true
# Increase memory allotted to JVM

ksp.incremental=true

#
## Enable Kotlin Incremental Compilation
kotlin.incremental=true
kotlin.incremental.multiplatform=true
#
## Enable Configuration Cache
#org.gradle.configuration-cache=true

Did any of you encountered the following issue on iOS? Uncaught Kotlin exception: kotlin.native.internal.IrLinkageError: Function ‘use’ can not be called: No function found for symbol

Is it ok having multiple room databases in an Android App. Like 10 or so? Or is better to have only 1 with a lot of tables? There are not many join queries in the existing codebase, in case this info helps.

Hi everyone! I'm trying to insert row or update it on existing id into my table, and I see 2 options for doing this in Room:

@Upsert

and

@Insert(onConflict = OnConflictStrategy.REPLACE)

. It seems to me that

@Upsert

should be more efficient (it was introduced more recently and has semantics of

INSERT ... ON CONFLICT DO UPDATE

within single query), while

OnConflictStrategy.REPLACE

looks like it will try to insert row in first query, and if it fails, run another query with update. But looking at the generated dao implementation, I see that

OnConflictStrategy.REPLACE

uses

INSERT OR REPLACE INTO

, while

@Upsert

has 2 separate

INSERT

and

UPDATE

queries. Does it mean that

OnConflictStrategy.REPLACE

should be more efficient when updating rows?

Hi everyone, a data modeling question: I am using Paging3 / RemoteMediator to store paged

Foos

(from network) in Room. There can be some ‘local only’ state (like DownloadManager ID and favorite status) that also needs to be associated with each

Foo

. Would you put those ‘local state’ columns in the same Room table storing the Paged

Foos

, or do a 1:1 relationship with the paged

Foo

table and another table, like

LocalFooState

?

What is the expectations regarding nullable parameters in Room DAO? I have the following function not working

@Query(
    """
        SELECT * FROM task
        WHERE parent_list_local_id = :taskListLocalId
          AND parent_local_id = :parentTaskLocalId
          AND position <= :position
          AND is_completed = false
        ORDER BY position ASC
    """
)
suspend fun getTasksUpToPosition(taskListLocalId: Long, parentTaskLocalId: Long?, position: String): List<TaskEntity>

If I force

parent_local_id IS NULL

, it's ok If I force

parent_local_id = 0L

, it's ok But can't have both at the same time using (equivalent of

= NULL

) I went for

COALESCE(parent_local_id, -1) = COALESCE(:parentTaskLocalId, -1)

for concision (knowing my ID is always positive) I also made it work with an

OR

parent_local_id = :parentTaskLocalId OR (:parentTaskLocalId IS NULL AND parent_local_id IS NULL)

I was expecting the generator to deal with nullable parameter itself. In the generated code, it deals with it, and use

bindNull

but nothing more fancy. Do I miss something? Is it a requirement of Room somehow? Why? Would it be desirable to have it working? (FTR, I'm using Room on desktop with SQLite Bundled)

Hi all, i'm getting this error building ios app after upgrading from 2.7.0-alpha13 to 2.7.0-beta01 e: [ksp] Cannot create auto migrations when exportSchema is false. what could be the issue?

even though room already increase libary version but still not include encrypted in kotlin multiplatform

Hello, I want to use

room

android, ios and desktop but

app.cash.sqldelight

for JS and Wasm . Need help with gradle how to handle NonJs and Js with ksp and room for nonJs and sqldelight {databases {}} for Js and Wasm

Is there any official guide to add room in a compose multiplatform project? this is the only official doc I found, but it's not complete, it doesn't help you too much. A step by step guide is necessary.

Can a compose multiplatform room database be populated with a .db sqlite file? In the documentation they say this:

Pre-package Database
The following APIs to create a RoomDatabase using an existing database (i.e. a pre-packaged database) are not available in common and are thus not available in other platforms other than Android. These APIs are:
RoomDatabase.Builder.createFromAsset
RoomDatabase.Builder.createFromFile
RoomDatabase.Builder.createFromInputStream
RoomDatabase.PrepackagedDatabaseCallback
We intend to add support for pre-packaged databases in a future version of Room.

Does this mean that if I have a .db file with content can't use it for populate the room database in Desktop etc... using Room multiplatform?

Given that Room supports Jvm thanks to KMP support. In the context of a pure Android project, not using KMP. Would it be possible to use Room Jvm runtime on Jvm unit tests? I tried the following in an Android library Gradle module

implementation(libs.androidx.room.common)
    testImplementation(libs.androidx.room.runtime.jvm)
    testImplementation(libs.androidx.sqlite.jvm)
    testImplementation(libs.androidx.room.testing)

But the

inMemoryDatabaseBuilder

function references the Android

Context

, it comes from the Android runtime dependency despite not being referenced. How could I manage to run Unit tests using Dao with in-memory DB on Jvm unit test with an Android library module?

can't get room to work on kmp desktop target i keep getting Unresolved reference errors (logs in thread) when i try to run on desktop but android works fine anyone else encountered this before?

After i updated my KSP and Kotlin versions

// Old
kotlin = "2.0.0"
devToolsKsp = "2.0.0-1.0.23"

// New
kotlin = "2.2.0"
devToolsKsp = "2.2.0-2.0.2"

Room's schema generator goes a bit bezerk and decides to remove some of my embedded objects and changes schema hash as well, which fails the integrity check. And that too not on all embedded objects across my projects, only some of them?! If i revert back, all seems to be A Okay!!! Any clue what might be happening here?

Has anyone had issues with race conditions when inserting a bunch of entities with FKs in a large transaction? Let's say I have the following structure: • Entity A • Entity B, has FK -> A • Entity C, has FK -> B, and FK Then I have a method were I insert a bunch of data in a

@Transaction

in the right order to satisfy the FKs. That is: 1.

insertA()

2.

allB.foreach { insertB() }

3.

allC.foreach { insertC() }

Now, after months of debugging what is going on, I noticed when adding query logging that sometimes a C will be inserted before all Bs have been inserted and cause a foreign key violation. I found out about deffered foreign keys and I was extremely happy, until I realized that it's broken and Google is not fixing it. Any ideas or experiences? I'm quite lost, it shouldn't be a rare scenario...

Hey all, Just wanted to share a solution we put together at Desquared that might be useful to others here. We needed a fully encrypted Room database in a Kotlin Multiplatform (KMP) app with shared persistence across Android and iOS. To make this work, we combined Room + SQLCipher and set up a custom driver for iOS to enable encryption, while keeping the database logic in shared code. We open-sourced the project and documented the approach here: https://desquared.notion.site/Encrypted-Room-Database-in-Kotlin-Multiplatform-KMP-for-Android-iOS-25b9aac7b816801b9067c627602335c6 Hope it’s helpful for others working on similar challenges.

Hi everyone, What's the status of

ON CONFLICT

statement in room?

INSERT INTO X (a,b,c) VALUES (:x, :y, :z)
ON CONFLICT(X) DO UPDATE SET
a=excluded.a
WHERE excluded.b > X.b

works, but using multiple

ON CONFLICT

results in error. The "spec" suggests you can have multiple

ON CONFLICT

in the statement and it works in sqlite3 command line

Hello! I wanted to ask if there is anything about Room support for Kotlin/JS. We use it on Android/iOS/Desktop but are stuck because it does not provide runtime and sqlite artifacts for js. Is there any solution? Or should we migrate to SQLDelight?

What are the main differences in Room3? thx

Is there any API, library or known pattern to detect when room DB got corrupted? And in such a case what is the best approach: 1- Show the user a message to uninstall, reinstall the App, sending to clear storage settings and so on. 2- Login the user out and trying to programatically recreate the same DB or a new DB.