postgresql/

sqlc.dev

sqlc generates fully type-safe idiomatic Go code from SQL

Install

• macOS

brew install sqlc

• go install

go install github.com/kyleconroy/sqlc/cmd/sqlc@latest

Generate Go code

• local executable

sqlc generate

• docker run

docker run --rm -v $(pwd):/src -w /src kjconroy/sqlc generate

Migrate

• Migration is done using goose
• File prefix should be in order - 0001, 0002, etc
• Example: https://github.com/pressly/goose/tree/master/examples/sql-migrations