Reviewing the underestimated benefit of using an external database client
In this section, I quickly want to highlight the potential benefits of using a third-party application for database access.
Some people in the Supabase space have asked how they can give some people access to Supabase Studio but only allow reading data, not changing it, or even how to just allow access to single tables (for reading, or reading and writing). That’s achievable with Supabase Studio on supabase.com but it comes with an additional price tag.
However, I’d like to highlight that rights management is built into any database and you can create as many additional database roles (hence users) as you want within the Postgres database of Supabase which will allow fine-grained data access. So, if you create a new user with your Postgres user and constrain the rights (I won’t go into the details of Postgres role/rights management), you can just give people access with that user (plus...
