4 ms·
I love PG. PostgreSQL already had most of its great features 15 years ago. Anything new that you particularly enjoy?
by andruby 2y ago
I love PG. PostgreSQL already had most of its great features 15 years ago.
Anything new that you particularly enjoy?
- edoceo 2y agojsonb
- happymellon 2y agoAt 10 years, it is newer than 15 but its not a new feature by a long shot.
- edoceo 2y agoIt's been available for less than half the time I've been using PostgreSQL. I stil consider it new.
- tmountain 2y agoRLS (row level security) came out in 9.5, January 2016. It's a game changer when used in combination with JWT tokens for identity and something like PostgREST. Specifically because a client can talk directly to PostgREST and run queries directly against the DB while letting the RLS policies dictate access. Example, a mobile client is allowed to insert data on the auth'd user's behalf, but the same user can only access rows that are associated with their own identity. Supabase rolls this up into an out of the box solution, which basically eliminates a lot of work writing "middleware APIs".
- hoppp 2y agoIts a good feature but I spent many days debugging problems caused with it. It might have been the fault of supabase.js apis , but still not a lot of fun memories.
- tmountain 2y agoIt's like a lot of things... process orientation and discipline early on go a long way to keeping things sane. There are nice techniques for debugging policies as well (login_as_user functions, etc). We write pgTap tests for everything, and that REALLY helps.
- jasoncartwright 2y agoI guess it's the zero-hassle managed service that's the improvement rather than the DBMS itself