If you're in a suspending context you can call

withContext(IO) { query.execute() }

this is all the flow is doing, except it also attaches to a callback and re-runs it when something changes

stumbled over this on SO: https://stackoverflow.com/questions/67695633/turbain-and-coroutinetest-with-delay-throws-timeoutcancellationexception and after trying it out and seeing https://github.com/cashapp/turbine/blob/trunk/src/jvmTest/kotlin/app/cash/turbine/jvmTestUtil.kt#L30 i think this just does not work.. but is there a way to get this to work or why not ?

Is there a way to check collection is empty for variable arguments? I have a filter query with default empty values, and for each param I check if it’s empty, like: AND (:nameFilter = ‘’ OR LOCATE(:nameFilter, fullName) > 0) And for a collection I’d like to use something like AND (:field = () OR field in :field) Which seems not valid SQL. I know that I can join this collection to string and use REGEXP, but maybe there’s an easier way? Also if I try to compare with NULL, it generates some strange

Collection<Int?>

type.

For sqldelight, the models are generated alongside the database code. I like to put my database code in an edge / leaf module so that it can’t be accessed everywhere in my application, but the modules typically need to be accessed in more layers of my application. Are there any sqldelight features that would help me with this, like generating the models in a separate module? Or is the only way that I can do this to create duplicate data classes and transform the classes into the new classes?

There’s an open GitHub issue for that but nothing currently implemented

Another pain point I’m seeing that is probably more common - I have a create statement:

CREATE TABLE DeviceRecording (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    json TEXT NOT NULL
);

The generated model has a non-nullable

id

, which makes it difficult to insert a

DeviceRecording

because in order to create one, I have to provide an ID. What’s the work-around? Am I thinking about this wrong?

If you add an insert statement it will take individual arguments, not an object instance

Objects are only used for rows that come from the database

I see - thanks. If that’s t he case, it seems like maintaining my own set of models is necessary. Is that the way most other people are using the library?

☝️ & I normally just write extension functions for my network layer data classes that make the process of conversion easier 🙂

okio is developing multiplatform file support. Are there any plans of supporting a

iosArm32?

target?

Send a PR. But, what still needs it?

ok. we deliver a cocoapod to our ios app, includes arm32, arm64 and x86. The app supports ios 9. I think such deep backwards compatibility is pretty rare, I'll make another attempt to remove old targets from our app before making a PR

Does there happen to be a rough ETA for the cut of SQLDelight 1.6.0 with kotlin 1.5 support? We're looking to upgrade to ktor 1.6.0 for official Bearer auth support but it appears we can't due to SQLDelight versioning. I've tested with SQLDelight 1.6.0-SNAPSHOT and it's working

Can I use okio to read a

socketFd: Int

? I've found

UnixFileHandle

but it takes a

FILE

as input

Don't think so, at least not without going through FileInputStream first on JVM/Android

What platform are you trying to do this on?

iOS + macOS

It would probably make a good addition to the native variant

Not sure if a bug or not. The following in a SQLDelight

.sq

file:

DELETE FROM records WHERE key LIKE ? ESCAPE '\';

generates a query like

"""DELETE FROM records WHERE key LIKE ? ESCAPE '\\'""" <== backslash is escaped here

which throws at runtime with:

ESCAPE expression must be a single character

Am I escaping wrong?

Probably a bug

It's easily workaroundable by using an argument instead of hardcoding the

\

but that got me puzzled for a while

Filed there: https://github.com/cashapp/sqldelight/issues/2439

Do you have any working example of using SqlDelight/JS in a Compose for Web app?

Compose for Web doesn't mean anything special other than the use of the IR compiler

I am interested in some examples, to see how the SqlDriver is loaded, w.r.t the ComposeForWeb’s main() function

i would probably hide that all behind a

Flow

which is exposed to the composables

Eventually, I am aiming to a structure like this:

fun main() {
	myComposeApp { myModel ->
		renderComposable(rootElementId = "root") {
			MainComposable(myModel)
		}
	}
}

where

MyModel

is returned after the SqlDriver is ready

but then you recreate the entire composition on model changes rather than allowing it to recompose and granularly update