2022

Dec 30, 2022
in Blog, SQL migrations

SQL migration files and goose annotations

In this post we'll explore SQL migration files and +goose annotation comments, which are used to parse SQL statements and optionally modify how migrations are executed.

As of this writing there are five annotations:

-- +goose Up
-- +goose Down
-- +goose StatementBegin
-- +goose StatementEnd
-- +goose NO TRANSACTION

Jun 19, 2022
in Blog, ClickHouse

Improving ClickHouse support

ClickHouse is a an open-source column-oriented database that is well-suited for analytical workloads. Over the past few years we've seen more and more demand for improved ClickHouse support in goose.

To summarize:

Upgraded to the latest /v2 driver: ClickHouse/clickhouse-go
Full end-end tests against the docker image: clickhouse/clickhouse-server
Bug fixes and improvements

The /v2 driver changed the DSN format, so be prepared for a breaking change. This is actually a good thing, because it brings the format in-line with other databases.