PostgreSQL

PostgreSQL

A powerful, open source object-relational database system

5.0
76 reviews

348 followers

An open source, object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

PostgreSQL forums

How do you isolate customer specific data?

I've been working on an app where I store financial data for my users. I've gone through a few iterations but have landed on RLS for partitioning the users data.
I considered using a schema per user, a database per user (probably would have used @SQLite ), or a layer in the ORM does some form of "roll your own rls" -- maybe appending a filter anytime the table has a user_id column.
It seems like @Supabase has popularized RLS and i'm wondering if thats what most people are doing these days?

View all