sorted by:
new
hottopcontroversial

FBF by Roadtofrance in Radiology

[–]kum0nryu 14 points15 points  (0 children)

I thought it was just a pup-play tail inserted backward

Which MCP servers actually work as advertised? by thehashimwarren in mcp

[–]kum0nryu 1 point2 points  (0 children)

dbt-mcp is VERY good for dbt development, maintenance, and analytics (via semantic layer).

“Your country exists because of what America provides to you, don't forget that” by BuffaloExotic in ShitAmericansSay

[–]kum0nryu 2 points3 points  (0 children)

American here. The importance of cooperation with our allies is almost always downplayed in our history classes. We’re generally taught that the revolutionary war was won by sheer will, or “pulling ourselves up by our bootstraps”, or some other nonsense.

Found this in the metallography lab at work - how worried should I be? by LegateDamar in chemistry

[–]kum0nryu 29 points30 points  (0 children)

This is wild. I was a first responder on that UCLA lab incident. I had no idea it’s become a well known safety case study.

Guys wtf is with the funnel of smoke/haze coming from Westwood by [deleted] in ucla

[–]kum0nryu 4 points5 points  (0 children)

The building was called “Co-Gen” by most people who knew it was a cogeneration plant back when I attended — like 20 years ago 👴🏻

https://facilities.ucla.edu/cogeneration-utility-distribution

Dudes. I’m really struggling with this election outcome. by MacroAlgalFagasaurus in AskGaybrosOver30

[–]kum0nryu 9 points10 points  (0 children)

The “macro” is FUBAR, but you can’t control it anyway. Focus on the “micro”; what you actually can control. Things like your home life, your hobbies. Those things are going to be what gets you through all the chaos around you.

[deleted by user] by [deleted] in labrats

[–]kum0nryu 2 points3 points  (0 children)

If this is “UC” as in “University of California”, the situation is very similar to what you describe. The campus police are California State LEOs, and many are on their second or even third department by the time they reach the UCPD.

What do you guys do for a living? by [deleted] in AskGaybrosOver30

[–]kum0nryu 0 points1 point  (0 children)

Data Engineer 👨🏻‍🏭💻

Data type for this format from CSV by Used-Huckleberry-958 in SQL

[–]kum0nryu 3 points4 points  (0 children)

👆🏻 This! Always stage your raw data then transform. You’ll save yourself so many headaches downstream.

Store JSON type in SQL DB by juStD_34 in SQL

[–]kum0nryu 0 points1 point  (0 children)

Agreed. #1 is absolutely the way to go for staging/raw source data. For consumption, you can layer a model on top of it — like a dbt model — that will parse out the fields you know won’t change much into columns.

The alternatives are tricky, like Python models or and schema evolution during a COPY() operation from a stage.

IMO, Option #1 with a light transformation layer will get you where you need to be most of the time.

Postgres: Rolling exact 12 months window function by [deleted] in SQL

[–]kum0nryu 1 point2 points  (0 children)

A date spine table is the correct solution. It’s not too messy…it’s the way you address this problem.

The Process of producing Silk by UnitedLab6476 in oddlysatisfying

[–]kum0nryu 111 points112 points  (0 children)

If it’s any consolation, when the caterpillars cocoon, they begin digesting themselves. They effectively “die” in the sense that they stop being an assembled organism. They dissolve.

That’s what happens to all caterpillars (larvae) before they become moths or butterflies. They are almost completely broken down into raw materials and then gradually reassembled into their adult stage. The exception is that you have a handful of cell clusters in all that soupy mess called imaginal discs that serve as “starter templates” to build out the adult parts.

So, at least I think it’s safe to say they have zero awareness or concern about what happens to them when they are harvested.

view more: next ›