Show HN: Pistachio – A declarative schema migration tool for PostgreSQL

Category: devtools

Tags: postgresql, schema-migration, cli-tool

Score: 5.5/10 (Innovation: 4, Technical: 6, Documentation: 7, Utility: 5)

Pistachio is a declarative schema migration tool for PostgreSQL that generates DDL diffs from a desired schema defined in SQL. It's interesting because it offers fine-grained control over index concurrency, bulk ALTER statements, and conditional execution of non-managed SQL, filling a niche for teams wanting a lightweight, Go-based migration tool.

Target audience: backend devs, devops, data engineers

Repository: https://github.com/winebarrel/pistachio · Go · MIT · 14 stars

View on Hacker News