|
|
|
|
|
by hardwaresofton
1888 days ago
|
|
One of postgres's most underrated features. RLS is amazing, can be unseen/basically work silently if your programming language-side tools are good enough, and is documented well (like everything else): https://www.postgresql.org/docs/current/ddl-rowsecurity.html But the power of PG is that it doesn't stop there, if you combine this with a plugin like temporal_tables and you can segment by user and time: https://github.com/arkhipov/temporal_tables All of this mostly unknown to the thing that's accessing the DB. If that's not enough for you, why not add some auditing with pgaudit: https://www.pgaudit.org/#section_three All this value is just out there. There's even more if you can stomach browsing "ugly" sites like PGXN. Most of it works out of the box, though you may need to tinker for performance and some edge cases but it's there. I think it might not actually be hyperbole to say that Postgres is the greatest RDBMS database that has ever existed. |
|