Re:PostgreSQL, pg_shard, and what we learned from our failures
by qaqy on Friday September 11, 2015 @05:15PM
(#10206227)
There is thins annoying thing called security with such things as trust boundaries etc. So if you are creating a mildly secure web app the only permission your web apps db user has is to execute a subset of stored procedures and that is it.
[ Parent
| on HN ]
Re:PostgreSQL, pg_shard, and what we learned from our failures
by threeseed on Friday September 11, 2015 @05:39PM
(#10206315)
I guess you better let everyone know that their web platform isn't secure unless they are using a SQL database with stored procedures. Which would make PSN, Steam, iCloud, Office365, Gmail, Facebook, Twitter all insecure right ?
Generally if you have exposed your db credentials it's because something has gone very wrong i.e. your entire host has been compromised in which case stored procedures aren't going to save you.