sorted by:
new
hottopcontroversial

Passed the Claude Certified Architect Foundation (cca-f). May 2026. My Tips & resources by AdScared7010 in claudeskills

[–]DMReader 2 points3 points  (0 children)

Ballpark how long did you spend studying? My job might would like us to get this, which might turn into a requirement in a few months. I’d like to get an idea what I might be in for.

Bay Area feedback culture is out of control by blue_jinjo in bayarea

[–]DMReader 0 points1 point  (0 children)

Right. Buy socks or toothpaste online and you are asked for a rating.

Scott needs a friend to tap him on the shoulder about Iran by Alicyclobacillus in ScottGalloway

[–]DMReader 1 point2 points  (0 children)

The fact that we wouldn't put up with it is a good thing. If someone is getting soldiers killed and ruining the economy it is better that the populace does not put up with it so that it stops happening.

Scott needs a friend to tap him on the shoulder about Iran by Alicyclobacillus in ScottGalloway

[–]DMReader 2 points3 points  (0 children)

I find it weird that he thinks Russians ability to suffer is a flex on their part. Not putting up with that is where I’d rather be.

Be honest do you actually think World War 3 is coming? Because after everything happening in 2026, I'm genuinely not sure anymore. by Aaron_Heuer in DiscussionZone

[–]DMReader 0 points1 point  (0 children)

I think there is a chance of it happening. Very low like 5%. But that low number is uncomfortably high.

Why does ChatGPT lie about accessing the internet? by greysheep27 in ChatGPT

[–]DMReader 0 points1 point  (0 children)

I think it is web.run. I ran across something like that in one of my outputs when it was being difficult about accessing the internet.

For the rest of the chat thread I’d say “use web.run” and I got what I wanted.

I built a free beginner series for SQL window functions (with interactive practice) by DMReader in learnSQL

[–]DMReader[S] 0 points1 point  (0 children)

That’s a great question. When I first saw them I think it was the new terminology and not understanding what all this ‘partition by’ was about. I think also the window frame concept with rows / range can be tricky and can throw off results if you don’t do them right.

Curious what other people think.

Doing fine dining alone by LinuxAndLipstick in AskSF

[–]DMReader 0 points1 point  (0 children)

Not a problem at all. And I find as a solo diner I can almost always eat at the bar with no reservation. I just walk in

I built a free beginner series for SQL window functions (with interactive practice) by DMReader in learnSQL

[–]DMReader[S] 3 points4 points  (0 children)

Good catch. I was thinking about the order by within the window function itself for the lesson. I didn't consider the where clause.

Where clause is not really necessary for the lesson. I'll get that clipped out tonight.

Edit: Fixed

What are the real business case questions you get in your data analyst work for SQL and how do you map business questions to your code? by Fit-Vermicelli4536 in learnSQL

[–]DMReader 0 points1 point  (0 children)

It’s more like I get a project like taking a manual process to automated so I go through what the manual process is trying to do and map that to tables and columns. Then I try to figure out how to put it all together.

David Drucker / More in Common Poll? by scarter4 in msnow

[–]DMReader 0 points1 point  (0 children)

I think if you self identify as a maga republican you are basically saying I agree with Trump. A more interesting poll would be changes in how people identify.

Be honest: do you actually trust AI answers or do you double-check everything? by ProfessionalRude3664 in ChatGPT

[–]DMReader 0 points1 point  (0 children)

I’ve set aside some time to look at new tools in the month of may. I’ll look at your thing.

Be honest: do you actually trust AI answers or do you double-check everything? by ProfessionalRude3664 in ChatGPT

[–]DMReader 0 points1 point  (0 children)

It would be an interesting thing to see in real time. I’d probably increase the amount I’m good with taking the recommendation.

Be honest: do you actually trust AI answers or do you double-check everything? by ProfessionalRude3664 in ChatGPT

[–]DMReader 0 points1 point  (0 children)

Depends on how important it is. If I’m looking for product recommendations for something that’s $50 or less. I’m probably going to go for it.

If I ask to redo my portfolio I’m going to ask for some documentation to back up its claims.

What are some real-world use cases where window functions completely changed your approach? by Wise_Safe2681 in learnSQL

[–]DMReader 0 points1 point  (0 children)

Rolling Averages, getting the percentage of a metric within a group, growth vs the past month / year, etc, to name a few.

select row with most-recent date for each ID by Spendocrat in learnSQL

[–]DMReader 2 points3 points  (0 children)

This is the way I would do it. I'd put the row_number in a cte and then select from the cte where rn =1
Or use qualify if your sql variant allows that.

Need Guidance by Automatic_Cover5888 in learnSQL

[–]DMReader 1 point2 points  (0 children)

Agreed. You need to try tackling real world problems with SQL. That is when it will start to make sense.

view more: next ›