Hacker GitHub

← All repos

fabianlindfors/reshape

View on GitHub ↗ ★ 1,858 Rust

An easy-to-use, zero-downtime schema migration tool for Postgres

20 mentions on Hacker News by 6 people: 3 stories, 17 comments · first 2022-01-07 · latest 2026-09-26

Mentions per year 20 mentions · busiest year 2022 (10)
20082026
AllStoriesComments NewestTopOldest
  1. …for several years now that tries to cover all the different ways one can shoot oneself in the foot: https://github.com/fabianlindfors/reshape It ensures migrations don't lock the database but maybe more importantly, it allows zero-downtime…
    comment by fabianlindfors · 2026-09-26 · in Is your Postgres migration safe or not safe?
  2. …I've got a bit of experience with schema changes from building Reshape: https://github.com/fabianlindfors/reshape . I'm hoping to transfer over some concepts from there into pgfdb eventually!
    comment by fabianlindfors · 2025-05-27
  3. My project Reshape ( https://github.com/fabianlindfors/reshape ) might be interesting to you, it's a bit like blue/green DB deployments in that it uses a two-step process where it can support both the old and the new schema at the same…
    comment by fabianlindfors · 2024-10-29 · in Building a better and scalable system for data migrations
  4. For people interested in this subject, you might also be interested in my project Reshape: https://github.com/fabianlindfors/reshape . It takes database migrations a step further than most tools, guaranteeing zero-downtime migration for…
    comment by fabianlindfors · 2024-10-29 · in Building a better and scalable system for data migrations
  5. …in this space (and Postgres specifically), I’d love to hear from you: fabian@reshapedb.com [0] https://github.com/fabianlindfors/reshape
    comment by fabianlindfors · 2024-04-29 · in Common DB schema change mistakes in Postgres
  6. …working on ReshapeDB [1], a full database designed from the ground up to tackle this problem. [0] https://github.com/fabianlindfors/reshape [1] https://reshapedb.com
    comment by fabianlindfors · 2023-11-14 · in Rivian software update bricks infotainment system, fix not obvious
  7. …tool which inspired pgroll, and seeing the concept taken even further is really exciting. [0] https://github.com/fabianlindfors/reshape
    comment by fabianlindfors · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres
  8. Cool stuff! Do you have any thoughts about how this compares to https://github.com/fabianlindfors/reshape ?
    comment by aschleck · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres
  9. best to use tools for this such as https://github.com/fabianlindfors/reshape or gh-ost for mysql
    comment by wahnfrieden · 2022-09-06 · in Ask HN: Do you use foreign keys in relational databases?
  10. This is precisely what I did for my automated zero-downtime migration tool and it works pretty well: https://github.com/fabianlindfors/reshape . At least for Postgres, simple views like these have almost no overhead as queries are simply…
    comment by fabianlindfors · 2022-05-17 · in The operational relational schema paradigm
  11. …in this subject might also be interested in a tool for Postgres I’ve been working on, Reshape: https://github.com/fabianlindfors/reshape . It aims to fully automate away all the pain and manual steps zero-downtime migrations normally…
    comment by fabianlindfors · 2022-05-05 · in Zero downtime migrations
  12. …statements but they also seem a bit wasteful to me. I'm working on a similar tool called Reshape ( http://github.com/fabianlindfors/reshape ) which instead uses temporary columns to reduce the time a migration takes and the extra storage…
    comment by fabianlindfors · 2022-03-06 · in Non blocking and zero downtime ALTER statements in PostgreSQL with pg-osc
  13. …and has been been my main reference for Reshape, an automated, zero-downtime schema migration tool: https://github.com/fabianlindfors/reshape
    comment by fabianlindfors · 2022-02-24 · in PostgreSQL Schema Change Guide
  14. …in Reshape, a tool I’ve been working on to automate zero-downtime deployments with Postgres: https://github.com/fabianlindfors/reshape
    comment by fabianlindfors · 2022-02-12 · in When Postgres blocks: tips for dealing with locks
  15. …version that may take hours/days/weeks to rewrite the whole table just to add a nullable column. https://github.com/fabianlindfors/reshape , on HN front page a couple weeks ago, has some nice tricks to help with the incompatible cases.
    comment by throwdbaaway · 2022-01-22 · in Atlas – Terraform but for Database Migrations
  16. …migration tool which automates zero-downtime migrations using many of the techniques mentioned: https://github.com/fabianlindfors/reshape . It also uses some other incredible Postgres features, like updatable views and schemas. It was…
    comment by fabianlindfors · 2022-01-17 · in Why I Enjoy PostgreSQL – Infrastructure Engineer's Perspective
  17. …how to change a column from TEXT to INTEGER, the technique would be the same the other way around: https://github.com/fabianlindfors/reshape#alter-column For the cases that require manual handling, that is a bit tricky. I'm not sure…
    comment by fabianlindfors · 2022-01-07 · in Zero-downtime schema migrations in Postgres using Reshape