Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
1–10 of 55 posts
Re: Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
#2Are migrations still specified in json?
Re: Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
#3The website generally looks good, but the font in the headings is weird. What is up with the "d" in it?!
Re: Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
#4Are migrations still specified in json?
Yes, but we're working on a converter from DDL sql to pgroll json.
The reason for JSON is because the pgroll migrations are "higher level". For example, let's say that you are adding a new unique column that should infer its data from an existing column (e.g. split `name` into `first_name` and `last_name`). The pgroll migration contains not only the info that new columns are added, but also about how to backfill the data.
The sql2pgroll converter is creating the higher level migration files, but leaves placeholder for the "up" / "down" data migrations.
The issue where sql2pgroll is tracked is this one: https://github.com/xataio/pgroll/issues/504
Re: Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
#5This seems like a great tool! I like how it "simply" works by putting a view on top of the actual table. This concept is widely used in the data engineering world (in dbt).
There must be an easier way to write migrations for pgroll though. I mean, JSON, really?
Re: Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
#6Here's a few other migration tooling options for Postgres: https://gist.github.com/cpursley/c8fb81fe8a7e5df038158bdfe0f...
Re: Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
#7Cool new site! I got 'invalid invite' on the discord link from the front page, I only mention as I'd like to join it.
Re: Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
#8Cool new site! I got 'invalid invite' on the discord link from the front page, I only mention as I'd like to join it.
Oops, fixing it now. This link should work: https://discord.com/invite/kvAcQKh7vm
Re: Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
#9The website generally looks good, but the font in the headings is weird. What is up with the "d" in it?!
This is the font, we wanted something a bit different :) https://unbounded.polkadot.network/
Re: Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
#10Is this related to supabase? There seems to be a link?