I notice, on Android, sqldelight grabs a writeable database when passed in a

SupportSQLiteOpenHelper

but what if the database is read-only (as in, you never want to modify it)? Are there any best practices/optimizations for opening such a database? I know there are some cases where

readableDatabase

returns a non-null value when

writeableDatabase

returns null, so there could be cases where it makes more sense to call

readableDatabase

. A nasty workaround is to override the helper so that the result of

readableDatabase

is returned when

writeableDatabase

is called. https://github.com/cashapp/sqldelight/blob/51e0621abe103761717d3d9078dcde3734ad8c0[…]ain/java/com/squareup/sqldelight/android/AndroidSqliteDriver.kt

In Workflow, I'd like my ViewFactory to inject some dependencies (not included in the Rendering) into the View it creates. And so I need to be able to pass arbitrary parameters into the ViewFactory. What's the best way to achieve this?

Kotlin/Native 1.4.30 is working fine for me with the current SQLDelight version. I am not running into any issues with any of the kotlinx libraries I am using so the Kotlin versions seem to be compatible.

Has someone already tried using anvil in a multi platform project? I think about creating an

expect class Inject

and using the javax.inject in jvmMain and use anvil to generate the factories

Hopefully a super quick question. Is there an easy way to ignore SQLDelight generated kotlin files in JaCoCo test reports?

does jacoco let you filter out your /build folders?

With SQLDelight is there any way for a bulk insert beyond a for loop in a transaction? I'm doing this

messageDao.transaction {
    newMessages
        .map { it.toDbMessage(groupId) }
        .forEach(messageDao::insertOrIgnore)
}

and with about 1000 messages its taking 200-300 ms (on an emulator). i imagine a real device might be slightly faster but not an order of magnitude faster. Is there anything else I can do to speed this up? table details in thread

We don't want full URLs in exceptions by default because URLs may contain secrets!

Hello all, I’m currently playing with KotlinPoet on a jvm desktop app and I’m wondering if its possible to actually edit a existent class with it. usecase: I’m attempting to build an app to bootstrap code for one of our features and it involves editing some classes

Is there any way I can get • Dns lookup time • TCP Handshake time • SSL Handshake time while making a network request using Okhttp3 ?

Hey! Has anyone tried enabling Anvil and Jetpack Compose in the same module? Currently we are having issues with it. Stacktrace in thread.

Not sure if anyone here has helped work on Curtains (https://github.com/square/curtains) I have this interesting scenario I've gotten myself into because I'm using the U2020 pattern of having a debug drawer in my app. BUT my app supports Android TV and I've encountered some issues where the debug drawer actually gains focus and throws off everything. At this point, now I want a debug drawer but I don't want it to be in my view hierarchy. Currently contemplating if there's anyway that moving a debug drawer into another window would resolve this, but not sure if that's even possible. Appreciate anyones experience here as I don't really know where to even start. 😄

1. Does

anvil

support DFM? 2. Also, is there’s any guidance/reference to interop

anvil

with

hilt

?

But those will set the

readTimeout

and

writeTimeout

and not the entire call timeout which is what I actually want. I think I can just read the headers from the

CallAdapter.Factory

, if that works we will be fine.

Any ideas why I am getting

java.lang.ClassNotFoundException: Didn't find class "java.time.Instant"

on serialization using desugaring https://github.com/square/moshi/issues/1169

mapper = ::CountryData

?

Module B’s MyDatabase type implements Module A’s, so you only need that one created

Any news on how soon we’ll have the JS/Web version of SqlDelight, and which are the main issues there at the moment?

Hi! Nobody answers at #sqldelight channel. I'll try to ask here.

Hello 👋 I'm using kotlinpoet to generate some data classes with some default values for enums. In order to reference the default value I'm using

MemberName

and it generally works great

public data class Result(
  public val myEnum: MyEnum = MyEnum.VALUE
)

Problem arise when I have multiple enums having same value as

MemberName

adds explicit import to that value, i.e.

import com.expediagroup.graphql.generated.enums.MyEnum
import com.expediagroup.graphql.generated.enums.MyEnum.VALUE

Any suggestions how to fix that? Should I just reference the

VALUE

from the code without using

MemberName

?

Hello 👋 I’m using KotlinPoet, and can’t find one feature. In the IDE I can “Reformat file”, which will use all my code styles from settings, like indents, braces, ets. Is there a way to do the same with

FileSpec

?

Maybe a silly question, but the api I'm working with has a set of apis that you can call when logged in, and another when logged out. We originally had this broken out into two retrofit instances essentially ending up with LoggedInApiService and LoggedOutApiService. Is that weird or does anyone follow that same pattern?

It's kinda mind blowing how many different ways I can try to have this "mock mode". lol 1. I just learned about this mock retrofit thing which is cool 2. Since retrofit is just an interface, I can just override it and return my own constructed things 3. I just found this inside of okhttp https://github.com/square/okhttp/tree/master/mockwebserver Decisions decisions... I do really like that mockwebserver can literally mock my entire web server. error codes. error bodies. certain weird headers. Sending html instead of json. I know Jake mentioned that he liked the type safety of mock-retrofit, but... mock webserver looks like everything you'd ever want. I do wonder if mockwebserver to implement a fully running mock mode is against the spirit of mockwebserver as it seems to really want to be used inside of tests (from the docs)?

you could delete the entire database each time if you don't care about the data

whats the best way to migrate a room db to sqldelight. Replicate schema, attach database, and insert select. Would this work?

Hey all! Having a tough time with my migrations seeing multiple errors where it doesn't see the table. When I run gradle build I get:

.../shared/src/commonMain/sqldelight/1.sqm line 1:12 - Attempting to alter something that is not a table.
1    ALTER TABLE character ADD COLUMN strength INTEGER
                 ^^^^^^^^^

.../shared/src/commonMain/sqldelight/1.sqm line 1:12 - No table found with name character
1    ALTER TABLE character ADD COLUMN strength INTEGER
                 ^^^^^^^^^

So when are we having this in SqlDelight? 🤔 https://medium.com/androiddevelopers/room-auto-migrations-d5370b0ca6eb

It’s strange - Room tries to do too much and it actually makes it harder to use. You opt-in to something like this auto migration because it sounds easy, and then you try to do something slightly off the beaten path, and you have to jump through hoops, or it’s simply not supported. I feel like Room is targeted at people who don’t know relational databases, but it’s not doing them any favours. I prefer to write my sql in sql.

If you enable migration verification SQLDelight will validate your migrations always produce the current schema: https://cashapp.github.io/sqldelight/android_sqlite/migrations/#verifying-migrations