Hey folks! Quick question. Added SQLDelight 2.0.1 to my project and my schema isn't recognizing TIME...

# squarelibraries

[Sivan]

Hey folks! Quick question. Added SQLDelight 2.0.1 to my project and my schema isn't recognizing TIMESTAMP as a field. Same with v2.0.0 as well. Any idea if I should be importing anything extra?

Error :

<type name real> expected, got 'TIMESTAMP'

P.S - This is the first time I am trying to use SQLDelight

[Sivan]

Okay. I had to add the dialect to the sqldelight block to fix it.

sqldelight {
        databases {
            create("MainDB") {
                packageName.set(namespace)
                dialect("app.cash.sqldelight:postgresql-dialect:2.0.1")
            }
        }
    }

I dont think this was given in the docs. Can we add this to it? 👀

[hfhbd]

Can you please say what do you miss? https://cashapp.github.io/sqldelight shows the overview of the platforms and dialects, and the MySQL page contains the information

[Sivan]

In the sense, it wasnt mentioned in the android section. Maybe it was an obvious thing that I missed.

[Sivan]

Also, the queries dont get generated and the build fails with the following error :

Unresolved reference: jdbc

Any idea why this is happening?

[hfhbd]

You want to use mysql with android?

[hfhbd]

You need to add the jdbc driver as dependency: app.cash.sqldelight: jdbc-driver:2.0.1

[Sivan]

You want to use mysql with android?

Using postgresql with android my bad.

Thanks for this though 🙏