Home / Companies / Incident.io / Blog / Post Details
Content Deep Dive

Migrating JSONB columns in Go

Blog post from Incident.io

Post Details
Company
Date Published
Author
Louis Heath
Word Count
784
Company Posts That Month
14
Language
English
Hacker News Points
-
Post removed?
No
Summary

At incident.io, the company has adopted database migrations as a key aspect of their product growth strategy. They have developed a runbook for safely handling migrations, including a recent focus on migrating JSONB columns in Postgres databases. To achieve this migration, they used interfaces `sql.Scanner` and `driver.Valuer` to provide custom marshaling logic for reading and writing data in both the old and new formats. The company has also implemented an async backfill process using this custom scanner to unify the state of the existing data, resulting in a consistent and up-to-date database schema.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.