4 ms·
Yeah, a good database is pretty damn handy. Have you had the pleasure of blowing young minds by revealing that production-grade databases come with fully fledg
by ibejoeb 2y ago
Yeah, a good database is pretty damn handy.
Have you had the pleasure of blowing young minds by revealing that production-grade databases come with fully fledged authnz systems that you can just...use right out of the box?
- scythmic_waves 2y agoCan you say more? I’m interested.
- stavros 2y agoI guess they mean something like Postgres' row-level security: https://www.postgresql.org/docs/current/ddl-rowsecurity.html https://www.postgresql.org/docs/current/ddl-rowsecurity.html
- Merad 2y agoDatabases have pretty robust access controls to limit (a sql user's) access to tables, schemas, etc. Basic controls like being able to read but not write, and more advanced situations like being able to access data through a view or stored procedure without having direct access to the underlying tables. Those features aren't used often in modern app development where one app owns the database and any external access is routed through an API. They were much more commonly used in old school apps enterprise apps where many different teams and apps would all directly access a single db.
- klysm 2y agoI think supabase leans quite heavily into this, although I haven’t used it myself. Row level security has been wonderful for multi tenancy in my experience though. I would highly recommend it.
- jaggederest 2y agoHere's a vendor, but the underlying functionality is shipped with Postgresql server https://supabase.com/docs/guides/database/postgres/row-level-security https://supabase.com/docs/guides/database/postgres/row-level...