Vik Fearing

@vik.thegresqlpost.org

Member of the ISO/IEC working group for SQL. Performance is an implementation detail. Major Contributor to PostgreSQL. he/him by default but will happily answer to anything. 🏳️‍🌈 https://thegresqlpost.org/

What are the best online resources for newly self-discovered trans women? Regarding basically everything (I am out of date on where to go for good info)

People (including myself) are out here talking about optimizing your #SQL queries. Isn't that the DBMS's job? Why do I have to hand-optimize this stuff? "Use GROUP BY instead of DISTINCT!" "Use DISTINCT instead of GROUP BY when possible!" Both wrong. 1/2

To DBAs: Have you ever granted INSERT/UPDATE but not DELETE? I would like to hear your reasoning behind that decision. I am wondering if the granularity is ever used or even needed. Would a readonly/readwrite pair be just as good in your production? #DBA #SQL