Re:Mastery with SQL: Learn Modern SQL with Postgres
by nsainsbury on Monday June 24, 2019 @10:31PM
(#20270673)
I think that's a reasonable recommendation if you're deploying Postgres in production. Not something I'd want to cover in any of my current chapters, where the focus is on teaching people SQL, but definitely something I'll mention down the road when adding a chapter around production deployment and security recommendations.
Re:Mastery with SQL: Learn Modern SQL with Postgres
by molsson on Saturday June 29, 2019 @03:21PM
(#20314257)
I agree. Some more info here for those interested:
https://wiki.postgresql.org/wiki/A_Guide_to_CVE-2018-1058:_P...
Re:Mastery with SQL: Learn Modern SQL with Postgres
by just_myles on Monday June 24, 2019 @04:39PM
(#20268215)
I had that same problem when I switched from postgres to mysql and big query with their "projects"..
Re:Mastery with SQL: Learn Modern SQL with Postgres
by paulddraper on Monday June 24, 2019 @04:42PM
(#20268244)
Wow, OWASP recommends keeping your database schema secret.
I've never been big on security through obfuscation.
...whereas this course seems to use the public schema and just query for "SELECT * IN public.foobar" etc.
I remember being a bit confused about "schemas" when I switched from mysql to postgres. I think it would be good to have a special section that explains what schemas are typically used for, and in particular when/how to use the public schema correctly.