Zero-downtime schema migrations in Postgres using views
I looked into this recently, and views cover like 98% of the functionality that the client app needs from Postgres. One issue I ran into was that Postgres forgets that the primary key is a primary key when pulling from a view, which breaks some queries that rely on grouping by the primary key.<p><a href="https://dba.stackexchange.com/questions/195104/postgres-group-by-id-works-on-table-directly-but-not-on-identical-view" rel="nofollow">https://dba.stackexchange.com/questions/195104/postgres-grou...</a> has some more info on this