Any queries that write to any tables used by a que...

# squarelibraries

[jw]

Any queries that write to any tables used by a query will get a callback to rerun. It's a really basic system, and it means you have to issue writes using SQLDelight

[hfhbd]

Actually, it depends on the driver and the database system. If the system supports notifications, you could write a driver reacting on the notifications. I did this for PostgreSQL: https://github.com/hfhbd/postgres-native-sqldelight/blob/54518baeffb6d3c12dafdc0c143c93ed1132f619/postgres-native-sqldelight-driver/src/commonMain/kotlin/app/softwork/sqldelight/postgresdriver/PostgresNativeDriver.kt#L47

https://github.com/hfhbd/postgres-native-sqldelight/blob/54518baeffb6d3c12dafdc0c143c93ed1132f619/testing-sqldelight/src/commonTest/kotlin/app/softwork/sqldelight/postgresdriver/PostgresNativeSqldelightDriverTest.kt#L96