On: PostgreSQL Schema Change Guide

[fabianlindfors]

This post is absolutely terrific and has been been my main reference for Reshape, an automated, zero-downtime schema migration tool: https://github.com/fabianlindfors/reshape

[jfbaro → fabianlindfors]

Could reshape help with temporal table schema migration? https://stackoverflow.com/questions/71131800/how-to-avoid-br...

[fabianlindfors → jfbaro]

I don't believe Postgres supports temporal tables and as Reshape is Postgres-only, it won't help.

The principle behind Reshape might be applicable to temporal tables though but I don't have enough experience with them to say.

[ansible → fabianlindfors]

So all applications only interact with views and don't use the actual tables themselves?

[fabianlindfors → ansible]

That's right! "Simple" views (ones mapping directly to a table) are quite powerful in Postgres and an application interacting with them won't know the difference.

[robertlagrant → fabianlindfors]

I was thinking about that. Nice to know there was a link!

[jfbaro → fabianlindfors]

Reshape is super promising! Great work!!

[fabianlindfors → jfbaro]

Thank you! :)