PostgreSQL
A powerful, open source object-relational database system
•10 reviews•52 shoutouts•242 followers
Subscribe
Sign in
242 followers
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?
My passion for Postgres stems from its versatility and robustness; it’s my go-to for data analytics projects, streamlining data engineering tasks through Supabase, and enhancing SQL workflows in VS Code with the SQLTools extension. Its seamless integration with Excel only solidifies its position as an indispensable tool in my data toolkit.
It has to be the best open source relational DBMS software out there with a ton of amazing features including few rarely seen in others but extremely useful ones like partial indexes, lateral joins and even support for no-sql like data structures like JSON and now even vector data.
PostgreSQL is an open-source relational database management system (RDBMS) known for its reliability, flexibility, and adherence to the SQL standard. With support for advanced features such as ACID transactions, advanced indexing, and high extensibility, PostgreSQL is a top choice for small to enterprise applications.
PostgreSQL is a very robust and performant SQL Database that exists currently. I've studied its internal architecture and I find it's very well thought through and every component of the architecture has a defined role to make it battle-tested production-grade DB.
PostgreSQL is an amazing database! It’s reliable and full of advanced features. Whether you have small tasks or big data, Postgres handles it all smoothly. It’s fast and flexible. If you need a database you can trust, go with PostgreSQL
