My application uses SQLDelight to save chat histor...

# squarelibraries

[Yassine Abou]

My application uses SQLDelight to save chat history and generated images. This functionality has suddenly stopped working (Everthing works before) . To ensure this wasn't a local issue, I completely deleted my local repository and cloned it again. The problem persists.
The app fails with the following errors:

text
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: chats)
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: generated_images)

To reproduce the error:
1. Clone the repository: https://github.com/yassineAbou/LLMS.git
2. Run the composeApp desktop target
3. The errors appear immediately during the build

[jw]

Where is your code that creates the tables / performs migrations?

[Yassine Abou]

here is the link: https://github.com/yassineAbou/LLMS/blob/master/composeApp/src/commonMain/sqldelight/org/yassineabou/llms/LlmsDatabase.sq

[jw]

Yeah but when you create the database driver you need to conditionally create or migrate the schema for all platforms other than Android

[jw]

Do you have code for that?

[Yassine Abou]

This is where I created the database. I didn’t add anything for migrations: https://github.com/yassineAbou/LLMS/blob/master/composeApp/src/desktopMain/kotlin/[…]yassineabou/llms/app/core/data/local/DatabaseFactory.desktop.kt

[Yassine Abou]

Is migration necessary even though I haven’t added anything new to the database?

[jw]

Yes. It's empty otherwise

[jw]

https://kotlinlang.slack.com/archives/C5HT9AL7Q/p1760560104283769?thread_ts=1760559923.758939&cid=C5HT9AL7Q

[Yassine Abou]

I added the migrateIfNeeded function. But I'm still getting the same errors. Here's the new code link: https://github.com/yassineAbou/LLMS/blob/master/composeApp/src/desktopMain/kotlin/[…]yassineabou/llms/app/core/data/local/DatabaseFactory.desktop.kt

[Yassine Abou]

If anyone would like to help or contribute, it would be greatly appreciated! 🙏

[jw]

What do you see logged on startup?

[jw]

When you inspect the database file do you see the tables?

[Yassine Abou]

I ran the debugger, but no table was created. Here's what the log shows:
Info: DB version 1 is up to date.

[jw]

If it read a version of 1, that means your code ran at some point and should have created the tables

[Yassine Abou]

The database works fine on Android as it is jvm based but fails on desktop. I doubt it's a migration problem.

[jw]

Android is not JVM based, and as I said above, migrations are only automatic on Android and nowhere else.