4 ms·
> MySQL is a perfect match for most SaaS applications that deal with compliance. Postgres is simply not. I find this statement amazingly weird. In my experie
by abernard1 6y ago
> MySQL is a perfect match for most SaaS applications that deal with compliance. Postgres is simply not.
I find this statement amazingly weird. In my experience, MySQL's access grants are extremely impoverished compared to Postgres (even in 8). It doesn't have row level security either.
> The main issues with managing Postgres today are grant inheritance
roles + `INHERIT` (which has been available since at least 8.1, 15 years ago)
> I shouldn't have to update grants for non-admin or readonly users after adding new objects
You don't. There are default grants that apply on object creation within a schema: `ALTER DEFAULT PRIVILEGES`.
- redis_mlc 6y agoThe reality is that I commonly see MySQL production applications use non-admin accounts, and have never seen that for Postgres. So there is a problem. Can you see if there is a grant similar to MySQL's FILE for COPY FROM/TO in Postgres? The last time I checked in early 2019, there wasn't.