QuestDB Dialect

[cedws]

I would like to use goose to migrate a QuestDB database, but it does not support this SQL dialect. I tried with the Postgres dialect but it doesn't have the integer type.

ERROR: unsupported column type: integer (SQLSTATE 00000)

I may get around to opening a PR for this.

As a sidenote, maybe it would be nice if the API exposed a way to register dialects externally.

[mfridman]

If using goose as a library, you can implement the Store interface to extend the supported dialects.

There's a bit of documentation here: https://pressly.github.io/goose/documentation/custom-store/

Does this help?

[cedws]

Ah this is exactly what I was looking for, thanks. Didn't see it in the API.