When grouping statements in SQLDelight, is there any way to get the result of running the last SQL statement?

This feature was added in 2.0. Try out the alphas!

sqldelight: anybody else not able to build the latest master on macOS with ARM processor (if related)?

PTHREAD_MUTEX_RECURSIVE

of native driver is always

platform.posix.wint_t

but I guess it should be Int or UInt

snapshot build?

ah yea latest master

oh you mean building from source

yes, building master from source

yea i was also seeing that and just stopped running build for that module

😄

@kpgalligan idk if you know whats going on, your native driver changes were what started it

Looks like a compiler/commonizer error: https://youtrack.jetbrains.com/issue/KT-48997 I created a workaround by using expect/actual: https://github.com/cashapp/sqldelight/pull/3223

Ah, damn. Just seeing this. That change (adding recursive to the lock) was pretty late in the cycle, so I didn’t run into the issue. I’m (mostly) on Intel, but surprised that wouldn’t surface. The commonizer stuff for posix has been brutal, but seemed to have been mostly fixed.

Anyway…

I’m trying to add a foreign key through migration for my SqlDelight table as follows,

0.sqm

CREATE TABLE IF NOT EXISTS entry(
    ...
);

1.sqm

PRAGMA foreign_keys=off;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS entry_temp(
    ...
    key INTEGER,
    FOREIGN KEY(key) REFERENCES ...
);
INSERT INTO entry_temp (...) SELECT * FROM entry;

DROP TABLE entry;
ALTER TABLE entry_temp RENAME TO entry;
COMMIT;
PRAGMA foreign_keys=on;

But upon running

generateCommonMainDBInterface

task I get an error for with the following stacktrace.

> A failure occurred while executing com.squareup.sqldelight.gradle.SqlDelightTask$GenerateInterfaces
   > Failed to compile SqlInsertStmtImpl(INSERT_STMT): [] :
     INSERT INTO entry(...)
     VALUES (?, ?, ?, ...)

java.lang.IllegalStateException: Cannot get reference table for psi type class sqldelight.com.alecstrong.sql.psi.core.psi.impl.SqlNewTableNameImpl

This

INSERT

statement is written in the

.sq

file and is syntactically correct. However if I don’t rename the table and use

entry_temp

as it is (with necessary changes in

.sq

file as well), the task runs successfully. Am I missing something here? blob thinking fast

Are there any shareable updates on the state of redwood being open sourced?

No timeline. Between now and EOY

But no sooner than 3 months

It's been functional for a year, but it's nowhere near ready for anyone but us to consume

Is "what is redwood" public knowledge?

It's a Compose-based build-your-own-UI-toolkit for cross platform apps. You write cross-platform UI code using Compose (NOT Compose UI) that binds to native UI

Is Android backed by the traditional view system?

You choose

You can back it with views, Compose UI, OpenGL, raw Canvas, whatever you want

We don't ship the bindings

It's not a turnkey framework like a react native or a flutter, but it also doesn't have the downsides of using such a system. Instead there's a massive up front cost as you define the cross platform UI toolkit API and build the bindings, but then you can spin up new cross platform UI within your design system trivially

There's a CSV format for kotlinx.serialization that you may be able to use

You could also consider using ResponseBody and then processing it yourself afterwards

I’m curious if anyone uses sqldelight with mysql or postgres json indexing and querying. If so, have you run into any issues with sqldelight / things that weren’t supported?

We're using it on our servers and it works great

@jessewilson I’m specifically talking about the json portion. I haven’t seen anything in the docs about json support beyond it being in the type list. But you guys use the json features of mysql, and it’s good?