
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.
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.
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?
PostgreSQL is widely praised for its reliability, scalability, and robust feature set, making it a top choice for developers and businesses alike. It is the backbone of many projects, including Supabase and Neon, where it is valued for its strong data integrity and advanced capabilities. Users appreciate its open-source nature, extensibility, and support for complex queries, making it suitable for both small and large-scale applications. Its integration with tools like pgvector further enhances its versatility.