Pgmigrate, modern Postgres migrations CLI

Hacker News

Hi HN, pgmigrate is a postgres schema migrations tool that is designed for modern deployment and operations. You can use the CLI or Docker container to manage migrations for projects in any language but if you use Golang it's also available as a library. The github readme has the full explanation, but basically pgmigrate is "migrations done correctly" or "migrations without all the pain in the ass bullshit": * pgmigrate uses postgres advisory locks to make it parallelizable * It doesn't make you think about down migrations — they're not useful and unnecessary and a waste of time * It runs out-of-order migrations * It doesn't error if you and a coworker both commit migrations with the same sequence number * It has ops commands for the rare occasions you need to manually mess with the migrations table state * And it lets you turn schema conflicts into git conflicts by making it easy to dump your schema in a consistent format * Oh, and you can squash migrations, too I'd love to know what you think, and I hope that I can convince you to try it out. The plan is to charge businesses money for it while keeping it free for personal and open source use, sort of like Orb stack, but keeping the source open. Are there any features you'd like to see added? The main one I've heard people ask for is automatic migration generation via diffing, like migra or skeema, but I'm not convinced it's useful enough to be worth the implementation hassle.

Visit product View on Hacker NewsJul 11, 2023

Share card

Actual performance

2points

Did not reach leaderboard

Launch Intel predictions

Analyze your own launch →

Product HuntOn track for Day 1 leaderboard · Strong signals: dock, open · Missing: mac, agents, macos

87%87% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

best fitHighest predicted score across all platforms for this description.

Indie HackersFits the IH revenue-focused audience · Strong signals: para · Missing: supports, reddit linkedin, podcasting

80%80% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

TrustMRRLess likely to generate early MRR · Strong signals: personal, para · Missing: mobile apps, ios, entrepreneurs

43%43% predicted probability of success on TrustMRR, based on ML models trained on real launch data.

Hacker NewsMay not resonate with HN audience · Strong signals: open source, io · Missing: https docs, excited, just released

37%37% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

AppSumoMay struggle as an AppSumo deal · Missing: plus, platform, intuitive

37%37% predicted probability of success on AppSumo, based on ML models trained on real launch data.

Acquire.comPre-revenue stage for this audience · Missing: arr, mrr, revenue

11%11% predicted probability of success on Acquire.com, based on ML models trained on real launch data.

BetaListMay not resonate with beta-testers · Missing: web3, chat, crypto

0%0% predicted probability of success on BetaList, based on ML models trained on real launch data.

Correct prediction on native model

Similar products

Pgcli – A CLI for Postgres with auto-completion and syntax highlighting67%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Pgcli – A CLI for Postgres with auto-completion and syntax highlighting

Hacker News227

Pg_dbml – A dependency-free CLI to export Postgres to DBML50%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Pg_dbml – A dependency-free CLI to export Postgres to DBML

Hacker News1

PgModeler – EER Diagramming for postgres73%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

PgModeler – EER Diagramming for postgres

Hacker News9

Merging RethinkDB and Postgres with GraphQL79%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Merging RethinkDB and Postgres with GraphQL

Hacker News6

First experiment wih Vertx,Vue,Postgres48%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

First experiment wih Vertx,Vue,Postgres

Hacker News1

Logchain – ClickHouse/Postgres gRPC hook for logrus81%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Logchain – ClickHouse/Postgres gRPC hook for logrus

Hacker News3

pglockanalyze - See the locks your Postgres migrations will acquire59%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

pglockanalyze - See the locks your Postgres migrations will acquire

Hacker News8

Apache Iceberg FDW for Postgres72%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Apache Iceberg FDW for Postgres

Hacker News1

Now supporting MySQL, Postgres, Redis, Mongo60%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Now supporting MySQL, Postgres, Redis, Mongo

Hacker News3

GraphQL for Postgres83%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

GraphQL for Postgres

Hacker News195

Browse all products Analyze your launch