I would like to ship a multiplatform app with an existing read-only sqlite database file. I guess SqlDelight cannot help with that. Any suggestion of which KMP library could I use?

Why not? Just don't write any write sql statements

I mean, I want to ship an already populated sqlite database file. Is it possible to do that with SqlDelight? Where should the file be placed?

It should be, in the case of android you can just include it on the assets folder. I think you could even be able to read the db file from the there too

SqlDelight requires you to write the database table schema on a .sq text file. In this case, the database schema is already defined in the sqlite file. Unless SqlDelight is able to extract the schema from the sqlite database file, I wouldn't think it's the best tool for this job.

You just need to define the scheme, it doesn't require writing it to the database if you don't need to

Where do you specify the location of the sqlite file you are shipping?

As long as you know the schema of your database ahead of time, you can still define the schema in .sq files for SQLDelight to understand it. From there, you just need to put the database file in a place where you can load it, and then configure your driver correctly to point to that file

Any idea which is the exact location where the file should be placed and/or where such location can be defined via the SqlDelight gradle config?

There's no special SQLDelight config needed for this on Android, database files generally go into the app's private

databases/

directory, i.e.

Context.getDatabasePath()

I'm not sure where databases go on iOS

Sqldelight can extract the schema from a local (dev, accessible from Gradle) SQLite database!

Is there any documentation/sample for this?

Just put a .db file in the sqldelight source folders, without a password of course

Sounds exactly like what I was hoping for ❤️ I hope it's true 🙏

@Daniele B I had to do something similar a couple of days ago and documented the experience here. The main focus was on iOS as Android was pretty straightforward(I link to a StackOverflow post that solves it for Android). Please let me know if you have any questions

@Isaac great many thanks! I wish it was properly documented in the SqlDelight website

This was my wish too. It’s why I wrote it 😅