3 ms·
This post is absolutely terrific and has been been my main reference for Reshape, an automated, zero-downtime schema migration tool: https://github.com/fabianli
by fabianlindfors 5y ago
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 https://github.com/fabianlindfors/reshape
- robertlagrant 5y agoI was thinking about that. Nice to know there was a link!
- jfbaro 5y agoReshape is super promising! Great work!!
- fabianlindfors 5y agoThank you! :)
- jfbaro 5y agoCould reshape help with temporal table schema migration? https://stackoverflow.com/questions/71131800/how-to-avoid-breaking-queries-in-temporal-tables-after-schema-changes https://stackoverflow.com/questions/71131800/how-to-avoid-br...
- fabianlindfors 5y agoI 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 5y agoSo all applications only interact with views and don't use the actual tables themselves?
- fabianlindfors 5y agoThat'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.