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.https://dba.stackexchange.com/questions/195104/postgres-grou... has some more info on this