Comment

Comment by ThrustVectoring

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

Discussion

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton