Adam S
07/11/2023, 8:28 AM.sq
syntax closer to Kotlin and allow for trailing commas in table definitions? Or is the syntax not under SQLDelight’s control?
CREATE TABLE Players(
player_number INTEGER PRIMARY KEY NOT NULL,
full_name TEXT NOT NULL,
); -- ERROR <column def real> or <table constraint real> expected, got ')'
Adam S
07/11/2023, 8:30 AMmbonnin
07/11/2023, 8:48 AMmbonnin
07/11/2023, 8:48 AMAdam S
07/11/2023, 9:07 AM.sq
files, right? That’s how it can support MySQL and Postgres too, and also custom column types https://cashapp.github.io/sqldelight/2.0.0-rc02/jvm_postgresql/types/#custom-column-types
I presume that SQLDelight is parsing the .sq
files and then converting it to valid SQLite sytanx.mbonnin
07/11/2023, 9:11 AMmbonnin
07/11/2023, 9:12 AMAdam S
07/11/2023, 9:12 AMmbonnin
07/11/2023, 9:13 AMmbonnin
07/11/2023, 9:13 AMAdam S
07/11/2023, 9:14 AMmbonnin
07/11/2023, 9:14 AMAdam S
07/11/2023, 9:14 AMmbonnin
07/11/2023, 9:20 AMpragma
or what not. By making SQL a requirement, SQLDelight has a steeper learning curve but also removes the surprises down the road when the app is deployed on multiple devices. If your DB supports it, SQLDelight should support it.hfhbd
07/11/2023, 9:32 AMhfhbd
07/11/2023, 9:33 AMAdam S
07/11/2023, 9:35 AMregarding trailing comma, we could support it in dialects which also support it, but ideally you should be able to copy pasta the sql files to you db/get them from your db engineers.That makes sense, thanks. So if trailing commas are optional, like in Kotlin, then that would still work. Or does the reverse have to be true, so the requirement is that I can copy+paste SQL from
.sq
files to DB engineers and it should just work?Adam S
07/11/2023, 9:36 AMExposed also supports coroutinesafaik Exposed doesn’t support async, or subscribing with a flow https://github.com/JetBrains/Exposed/issues/1560 (unlike SQDelight https://cashapp.github.io/sqldelight/2.0.0-rc02/jvm_sqlite/coroutines/)
hfhbd
07/11/2023, 9:39 AMAdam S
07/11/2023, 9:40 AMhfhbd
07/11/2023, 10:04 AM