dventimi

32 ms·

421.
by dventimi 3y ago
They can't still do anything in that account with more generous allowances on statement timeouts. They can only do what permissions and policies allow, which could be "nothing." That's not a very large surface area.
422.
by dventimi 3y ago
Valid operations that take longer can be performed with another role with more generous allowances on statement timeout, but more stringent limitations on the allowable operations (e.g. substituting procedures for a general query interface)
423.
by dventimi 3y ago
That's fair. You do "you", I'll do "me", and we'll both have a very merry [seasonal holiday of togetherness of your choice]. So long as we're saying what we want in the way of gifts, here's what
424.
by dventimi 3y ago
No, they can't write some pretty rough queries that threaten QoS. They get a budget of 100ms to run whatever query they like, no matter how bad it is.
425.
by dventimi 3y ago
But row access policies do
426.
by dventimi 3y ago
I'm not persuaded any of this is true.
427.
by dventimi 3y ago
"cumbersome" is a matter of judgement. As for table scans, again as I've written elsewhere here, statement timeouts will put an end to those [concerns].
428.
by dventimi 3y ago
> you are abusing SQL to hack around overhead issues. > Logically, users and posts are distinct relations as it pertains to that example. They have no business being joined here. > There is a place for joins, but that's not it
429.
by dventimi 3y ago
You mean the very first paragraph in which the author invites us to reevaluate those reasons? You mean those reasons which include the following? - Exposing an API that accepts SQL is crazy. - It's a terrible idea. - Especially if the
430.
by dventimi 3y ago
The statement timeout will put an end to that.
431.
by dventimi 3y ago
> We surely don't want to have the webshop-frontend send database queries to the backend to get the results. We don't? Why not?
432.
by dventimi 3y ago
> using SQL has been despised by people for the longest time, probably for good reasons at the time. Don't be too quick to assign rationality where its absence will do. If SQL has been despised it's quite possible the reasons h
433.
by dventimi 3y ago
https://web.archive.org/web/20181105214850/https://www.alter...
434.
by dventimi 3y ago
"Do you really need [foreign key constraints]?" FTFY. Foreign keys != Foreign key constraints
435.
by dventimi 3y ago
I don't blame her for anything. I just don't think she's worthy of the praise that's heaped on her.
436.
by dventimi 3y ago
That's obviously a typo and one that I already addressed elsewhere. If you'd like to offer a serious response with actual substance, by all means go right ahead.
437.
by dventimi 3y ago
Thanks! I'll check it out.
438.
by dventimi 3y ago
Could be. "Anything is possible," as they say. Personally, I'd apply Occam's Razor and say it's more likely it's not intentional and these are bona-fide mistakes on her part.
439.
by dventimi 3y ago
No, it isn't unfair. It's just not accurate. A more accurate portrait would be: - People make educated guesses about the internal states-of-mind and emotional states of other people all the time. We do it with friends, lovers,
440.
by dventimi 3y ago
I haven't removed their agency. I've only exercised my own. You're free to do the same however you like.
441.
by dventimi 3y ago
Personally, I would credit the guests themselves for generating interest within the audience.
442.
by dventimi 3y ago
I suspect that Terry Gross, like NPR, is a brand that people wear to advertise "I'm smart." That's what's really going on with what her audience feels about her. That in turn explains what's really going on wit
443.
by dventimi 3y ago
Typo: "I'm [unimpressed]"
444.
by dventimi 3y ago
Pet peeves: - interviewers who ramble on when asking a question - interviewers who rely on declarative sentences (i.e. they don't even ask a question) - interviewers who rely on imperative sentences (e.g. "Talk about the time that
445.
by dventimi 3y ago
Still sounds like resonance to me
446.
by dventimi 3y ago
You may expect that as an amenity but nobody else is obliged to share your expectation. The fact is that AirBnB provides hosts the ability to try to SET expectations about amenities, even ones as mundane as a coffee maker. Given that, I&#x2
447.
by dventimi 3y ago
And yet coffee isn't so expected that there isn't a setting for it in a listing's amenities. It's quite the contrary. In fact, there are settings for both "coffee maker" and "coffee", there for anyone
448.
by dventimi 3y ago
Thank you for this. I would add: XSLT
449.
by dventimi 3y ago
I would not recommend Hasura if you're on PostgreSQL.
450.
by dventimi 3y ago
My understanding, perhaps flawed, is that row security policies add predicates to the SQL, which then encounters the query planner like any other. Is this not the case?

More ›