Way to create untyped column?

[schveiguy]

SQLite supports columns without a type:

CREATE TABLE example (column1 INT, column2)

However, with GRDB, the table.column function only allows creating columns with a given type:

            db.create(table: "example") { t in
                t.column("column1", .integer)
                t.column("column2") // error
            }

is there a way to do this?

[groue]

Hello @schveiguy, glad to see you again!

According to SQLite documentation, an untyped column has the exact same behavior as a numeric column:

db.create(table: "example") { t in
    t.column("column1", .integer)
    t.column("column2", .numeric)
}

This will make your code compile, and your database 100% equivalent (but for the syntax of the table declaration).

[schveiguy]

Thanks, that looks correct! I will go ahead with this (was just using a create statement, but was sure there was a better way)

[groue]

Support for untyped columns has landed: 5f2d6f8 in development branch.

[groue]

Shipped in v1.2