I don't know of any examples. Your function would change to take a Path and a FileSystem and then it would perform whatever reading and parsing it needed. In the Android code you'd pass the asset file and the asset FileSystem was just merged into Okio this week and will be in a release soon

Hi 👋 I’m trying to do something on SQLDelight (using latest version on KMM project) but it’s not working, I’m not sure if this isn’t supported or I’m doing something wrong. I have something like this, just 2 tables to store

userId <-> groupId

relationship and one to store members, which has a

groupId

column. I’m trying to

flatMap

one query into the other, but if I insert a new group under that

userId

it doesn’t trigger the chain. small example:

suspend fun getGroups(userId: String): Flow<List<Groups>> =
    userGroupQueries.getGroups(userId)
        .asFlow()
        .mapToList(coroutineContext)
        .flatMapLatest { groupIds: List<String> -> 
            memberQueries.getAllGroupsMembers(groupIds)
                .asFlow()
                .mapToList(coroutineContext)
                .mapLatest { members -> members.groupBy { it.groupId }}
        }

UserGroup.sq
CREATE TABLE UserGroup(
    userid TEXT NOT NULL,
    groupid TEXT NOT NULL,
    FOREIGN KEY (groupid) REFERENCES EGroup(id),
    FOREIGN KEY (userid) REFERENCES User(id)
);

getGroups:
SELECT groupid FROM UserGroup WHERE userid = ?;

Member.sq
getAllFromGroupIds:
SELECT * FROM Member WHERE groupid IN ?;

I can try to provide a minimum reproducible example if necessary. Didn’t find anything like this on SO or on github so I wonder if I’m trying to do something silly

Is this familiar to anyone:

Compiled with problems:


ERROR in ../../node_modules/sql.js/dist/sql-wasm.js 93:11-34

Module not found: Error: Can't resolve 'path' in '<project_path>/build/js/node_modules/sql.js/dist'

BREAKING CHANGE: webpack < 5 used to include polyfills for node.js core modules by default.
This is no longer the case. Verify if you need this module and configure a polyfill for it.

If you want to include a polyfill, you need to:
	- add a fallback 'resolve.fallback: { "path": require.resolve("path-browserify") }'
	- install 'path-browserify'
If you don't want to include a polyfill, you can use an empty module like this:
	resolve.fallback: { "path": false }


ERROR in ../../node_modules/sql.js/dist/sql-wasm.js 93:81-94

Module not found: Error: Can't resolve 'fs' in '<project_path>/build/js/node_modules/sql.js/dist'

Did some research online but all I got was a thread in the sqdelight github project, that didn’t help much. Thanks in advance

Did you set up the additional webpack config?

// project/webpack.config.d/fs.js
config.resolve = {
    fallback: {
        fs: false,
        path: false,
        crypto: false,
    }
};

Hi everyone, do SQLDelght queries execute on main thread then I need wrap them with Dispatchers.IO？

Working with an old backend api that for some reason is advertised as taking json as input, but it doesn't use

"

, it uses

'

Is there an easy way to write an interceptor or something that just replace all double quotes with single quotes? I'm using okhttp + retrofit.

I would like to ensure that my DB queries run with SQLDelight aren't run on the main thread. Is the best way to copy the driver and add a check in

execute

?

You could implement a new driver with the checks that delegates to an existing implementation. Similar to this logging driver: https://github.com/cashapp/sqldelight/blob/master/runtime/src/commonMain/kotlin/app/cash/sqldelight/logs/LogSqliteDriver.kt

Ah thanks. That's a better idea.

Maybe a dumb question, but are SQLDelight IDE plugin snapshot versions expected to be backward compatible with the gradle plugin? That is, can I use a snapshot IDE plugin with the alpha-05 gradle plugin, or do the versions always need to be in sync? I'm guessing it's the latter, so my follow-up question is, can we have a new alpha soon?

They are not backward compatible, but you can also use the IDE plugin snapshots.

I've implemented a generate UI for select/insert/update/delete for the SQLDelight IDEA plugin (https://github.com/cashapp/sqldelight/issues/489): https://github.com/neilgmiller/sqldelight/tree/features/489-generate-actions I've got some polishing I'd like to do, but I'd love a little early feedback. Happy to post the built plug-in if that's easier for everyone.

Hi, I'm developing a note app, in the homepage I want to show the notes token today, so I use the SQLDelight flow extension. The problem is when the date changes, I need cancel the previous flow and create a new flow.

val tempJob:Job? = null

fun getNotesToday(today:LocalDate){

viewModelScope.launch{

tempJob?.cancel()

tempJob=launch{

database.noteQuery

.getNotesBetween(today.start,today.end)

.asFlow()

.collectLatest{...}

}

}

It seems a bit troublesome to do the same for every situation like this, is there a better way?

Hello guys, I recently started using Molecule and, while updating to Kotlin 1.8.20, I noticed that my project was using the Compose Compiler version from Molecule instead of the one locally defined. I noticed this PR from Jake (I left a comment, I hope that is ok) and I did something similar into my project and I wanna take the chance to solve what mentioned above as well. Should I include molecule in the group as well, or can I (should I?) force my project to use the locally defined version of Compose Compiler instead?

Hi. With okio multiplatform, i’m running into a

okio.IOException

.

Uncaught Kotlin exception: okio.IOException: Operation not permitted
    at 0   PSCore                              0x10548be63        kfun:okio#errnoToIOException(<http://kotlin.Int|kotlin.Int>){}okio.IOException + 419

Looks like this is thrown from the encoder, which is here and looks like this

override suspend fun encode(value: T?) {
  val parentFolder: Path? = path.parent
  if (parentFolder != null && !FILE_SYSTEM.exists(parentFolder))
    FILE_SYSTEM.createDirectories(parentFolder, mustCreate = false)
  if (value != null) FILE_SYSTEM.sink(path).buffer().use { json.encodeToBufferedSink(serializer, value, it) }
  else FILE_SYSTEM.delete(path)
}

Unable to reproduce this consistently. But seems to be more prevalent on physical devices compared to the simulator. Raised an issue here. Any idea whats wrong? 🤔

Is there a preferred way to automate constructing the adapter classes for SQLDelight when one has lots of custom column types?

I have been playing with SQDelight in the browser and all seems good as long as the page is open. Once I close the page I notice I lose the data. Is this the standard behavior based on browser sessions? Anyway to persist based on url? - so that I can close the page and open it later and the data remains

The sqljs-driver (which will be removed in 2.0) runs entirely in-memory so that's why it's wiped every time you reload the page. To have it save data between page loads you need to run SQLite in a Web Worker and use some SQLite driver that supports some kind of local storage, like absurd-sql (which has some flaws), or sqlite wasm (which is what I would recommend in the future when browser support is better). It's not very well documented yet, but you would use SQLDelight's web-worker-driver instead and I have a sample project that uses it here: https://github.com/dellisd/sqldelight-sqlite-wasm

Thanks 🙏🏻, to be honest it is not a common thing seeing local persistence between page loads. Usually, the web saves data remotely. But just experimenting a little bit.

What is the best way to put Paparazzi to always run in "record" mode? Basically I comparing/saving the images to the cloud and I want Paparazzi to run in record mode (always) when I run my unit tests? This needs to work in CI too

If I'm using Paparazzi solely for Compose, is there any benefit to keep using it once AGP screenshot testing is available ()

I guess we'll see!

It doesn't have the accessibility support, but otherwise looks like a great option to check out in the fall when it's further along

Yeah, ive been using paparazzi a bit, and id probably say that paparazzi was probably a big reason why this new agp thing is even available. i think its great that layoutlib will have more eyes on it now as i think thats what drives paparazzi anyway

It hasn't landed in public repos yet so seems hard to react to the news at the moment.

Hello, I find that SQLDelight generates classes after successful building, how can I make it automatically generate everytime .sq files change without building manually？

have you already installed the IDE plugin?

Alternativ: use Gradle continuous build feature:

—continuous

Hi guys, I'm using SQLDelight for my KMM app to add offline support and I'm stuck at a problem. I'm describing the same briefly below: The response I get from api is

Movie(

val genreIds: List<Int?>?

)

To store the above in database I'm creating a db table like this

CREATE TABLE Movie (
   genreIds TEXT AS List<Int>,
);

While instantiating my database I'll need to give a ColumnAdapter to let the SQLDelight know how to store and retrieve

genreIds

to and from database. Here is the ColumnAdapter Implementation

val listOfIntsAdapter = object : ColumnAdapter<List<Int>, String> {
    override fun decode(databaseValue: String): List<Int> {
        return if (databaseValue.isEmpty()) {
            emptyList<Int>()
        } else {
            databaseValue.split(",").map { it.toInt() }
        }
    }

    override fun encode(value: List<Int>) = value.joinToString(separator = ",")
}

But As I'm building the project I'm getting this error

Type mismatch: inferred type is ColumnAdapter<kotlin.collections.List<Int>, String> but ColumnAdapter<java.util.List<Int>, String> was expected

The name of my database is

AppDatabase

In the generated

AppDatabaseQueries

class in the imports section, Android Studio is not able to resolve this import. I don't know but this could be the reason for this issue. Thanks in advance

have you already tried importing

kotlin.collections.List

in your

.sq

file?