PostgreSQL

PostgreSQL

A powerful, open source object-relational database system
9 reviews25 shoutouts
171 followers

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