[HN Gopher] pgroll: PostgreSQL zero-downtime migrations made easy
       ___________________________________________________________________
        
       pgroll: PostgreSQL zero-downtime migrations made easy
        
       Author : tosh
       Score  : 81 points
       Date   : 2024-09-22 12:09 UTC (1 days ago)
        
 (HTM) web link (github.com)
 (TXT) w3m dump (github.com)
        
       | throwaway2016a wrote:
       | This is really great. Managing migrations without locking the
       | table can be a real huge pain-point. And having a dedicated
       | project likely covers more edge cases than an internal tool would
       | (as is evident looking at the issues list).
       | 
       | With that said, it looks like it could be used not just as a
       | stand alone tool but also embedded within a Go application since
       | it does export its API. In my case I'd love to use it from my
       | existing tooling. I couldn't find any documentation on how to do
       | that, though.
       | 
       | I'll probably dig more into that later.
        
       | n2d4 wrote:
       | This starts becoming really powerful when ORMs support it
       | natively. Imagine if Prisma generated reversible pgroll
       | migrations instead of SQL files!
        
       ___________________________________________________________________
       (page generated 2024-09-23 23:02 UTC)