GitHub - golang-migrate/migrate: Database migrations. CLI and Golang library.

Spent a bit debugging a `bad connection` error with golang-migrate and ClickHouse. This is my note to self, always check for `secure=true` with cloud DBs.

Welcome to my personal blog 👋

Software development and deployment is very much like an adventure game. Where you're faced with puzzles that might take you a day to solve, by picking up …

Most developers will have to interact with SQL at some point in their career, and often nowadays that means working with Postgres. I’ve been using Postgres with Go for a few years now and have found a couple of libraries that work really well together to make the Go Postgres experience productive, safe and fun. TL:DR; I have created an example repo that puts all of the below into practice: github.

This is the first in a series of posts about the stria side project I am working on.

I think I’ve settled on a goto set of tools and libraries for building web-apps in Go. It used to be that I would turn to Buffalo for these sorts of …

A practical guide to implementing database schema migrations using golang-migrate, with MongoDB examples and production deployment strategies using Kubernetes init containers.

I was working on a project that uses PostgreSQL and as part of my task I needed to write a migration. The migrations are written as plain SQL and applied using the migrate library. The migration itself was not that complex, some rows needed to be updated where a column matched one of the values in a list. In my rush, I’ve opted for a rather simple query that went something like this: