Strong views on PostgreSQL VIEWs

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

VIEWs should be the cleanest abstraction SQL, and therefore Postgres, has on offer. I love the concept. The promise of decoupling logical intent from physical storage is perfect on paper. In practice, few things in the database world trigger such a heated debate or carry as much historical baggage. VIEWs mix big promises with false hopes, and the promises rarely survive contact with production.…

Read on boringsql.com ↗