Does SqlDelight also work with pre-populated datab...

# multiplatform

[Daniele B]

Does SqlDelight also work with pre-populated databases?

[Kris Wong]

all databases are populated, outside of the short window before data is inserted into them

[Seyed Jafari]

it does not support currently
but the database can be moved to the correct location before opening database
so when sqldelight starts it reads from your copied file

[Daniele B]

do you have any reference I can read to understand what are the platform-specific mechanisms for including the database file in the final packaging?

[Kris Wong]

well, that depends on the your target platforms

[Daniele B]

Android and iOS

[Daniele B]

I mean, do you I need to include the database file in CommonMain, or both in CommonAndroid and CommonIos ?

[Kris Wong]

on Android you'll be using the resource system, specifically assets, and on iOS, bundle resources

[Daniele B]

doesn’t SqlDelight automate any these things?

[Kris Wong]

this really isn't in scope for SqlDelight

[Daniele B]

so, I guess the location where I place the file is outside Common

[Kris Wong]

it would be odd for a database library to be concerned with adding files into your target packaging

[Daniele B]

I would expect a MultiPlatform library to be provided with the database file only once, and then it would do the rest

[Kris Wong]

that's exactly how it works

[Kris Wong]

but you need the file to be there, in the right place, within the app sandbox

[Kris Wong]

SqlDelight doesn't care how it gets there

[Daniele B]

mmm, I think I am missing something

[Daniele B]

I am not really following what you are saying

[Kris Wong]

are you familiar with mobile app packaging and sandboxes?

[Daniele B]

I don’t exactly understand what you mean with app sandboxing

[Kris Wong]

alright. that's a fundamental concept for mobile apps. you will need to understand that.

[Daniele B]

maybe I know it by another name?

[Kris Wong]

i am not familiar with another term for the same concept

[Kris Wong]

app packaging is installed on the device. it can include any kind of files you want. but in this case you need those files to be in the runtime area (sandbox) for the app.

[Daniele B]

what I know is that at the moment in standard Android (not multiplatform), I am shipping the sqlite file in the asset directory, and at runtime when I call the database, there is some code that checks if the database exists in the right location, and if not it moves the database from the assets directory to the proper location

[Daniele B]

I was expecting that SqlDelight had some inbuilt mechanism to do this under the hood

[Daniele B]

as long as you provide the database file in a specific commonMain directory

[Kris Wong]

sqldelight does not have a mechanism for that

[Kris Wong]

even if it did, that's only half of the equation. you would still need to get the database file onto the device, which KMP does not provide a mechanism for.

[Daniele B]

I thought that through the commonAndroid (and commonIos) sourcesets it was straightforward to manage that

[Kris Wong]

i am not sure why you thought that, but if you have a source i'd be delighted to see it 🙂

[Daniele B]

I haven’t actually written any code using SqlDelight yet. All examples I have seen so far are with creating a database from scratch.

[Daniele B]

But my use case is different than that

[Daniele B]

So I was looking for a way to get started on my use case

[Daniele B]

If I manage to do find a way, I guess it would be useful if I wrote a small tutorial

[Daniele B]

as I haven’t found any yet

[Daniele B]

Actually, now that I think about it, instead of shipping an sqlite file, I can provide SqlDelight the structure and content of the database and create it then. It doesn’t actually change much for me.

[Daniele B]

Actually, thinking further! I don’t even need a sqlite database! they are just 250 records, with 2 fields each, I can just store it on a Kotlin Map, why not!? 🙂

[Daniele B]

The Kotlin language already has great sorting/higher-order functions. I can just use those 🙂

[Kris Wong]

yeah, that makes much more sense for that small amount of data