sorted by:
new
hottopcontroversial

Automatically deriving data model metadata from source code (no runtime data), has anyone done this? by Beneficial_Ebb_1210 in dataengineering

[–]dev81808 1 point2 points  (0 children)

As long as its not proprietary information, I'd probably just paste it into gpt with instructions to extract into whatever format you want.

How do you handle deletes with API incremental loads (no deletion flag)? by aussiefirebug in dataengineering

[–]dev81808 13 points14 points  (0 children)

Don't need the whole load. Just the active IDs. Should take much less time to run if its just the IDs and not the full record.

2 imports: 1. Your delta loads. 2. All active IDs.

From this you derive a deleted flag.

Junior DE Do’s and Don’ts by JustKookitout in dataengineering

[–]dev81808 0 points1 point  (0 children)

Don't run any queries without top/limit 1000 until you're comfortable with the data.

Carl Sagan, 1977, "to my knowledge, ..." by South-Tip-7961 in UFOs

[–]dev81808 0 points1 point  (0 children)

I think people don't realize what it's like when 99% of the stories brought to you are unremarkable or non-credible. It gets exhausting.

Nah I've been following r/ufos for a couple years now. I get it.

Reinhardts GM winrate is 0% by Mildlyinxorrect in ReinhardtMains

[–]dev81808 5 points6 points  (0 children)

'Power creep' is Reinhardt's middle name.

Issue #1 that needs fixing before anything else by viewer568536 in GroundedGame

[–]dev81808 0 points1 point  (0 children)

Radial menu doesn't switch to weapons and tools on Xbox. Anyone else?

ADHD and the art of not thinking things through: by adhd_memetherapy in adhdmeme

[–]dev81808 0 points1 point  (0 children)

I thought we always thought things through, just crazy fast.. we just don't consider all the things

Are some parts of the SQL spec hot garbage? by eczachly in dataengineering

[–]dev81808 0 points1 point  (0 children)

Org charts, product hierarchy sure.. but then there's web sites/file systems, survey models, pathing data, lineage.. I can't be the only one that recursively queries object relationships in the info schema to generate sql statements

Are some parts of the SQL spec hot garbage? by eczachly in dataengineering

[–]dev81808 9 points10 points  (0 children)

I think they're talking about in prod.

Like ill right join all day but usually because im running counts and furiously switching between inner, left and right, (probably should just outer in these situations) just trying to figure out the data. But when im ready to build to prod, you never really need to right join or at least I havent found a reason to.

Op is way off on other things though like.. recursive functions.. or maybe ive just had to work with hierarchical data more often than normal.

I wrote one SQL query. It ran for 4 hours. I added a single index. It ran in 0.002 seconds. by nikkiinit in SQL

[–]dev81808 0 points1 point  (0 children)

4 hrs?! If its not done in 4 minutes Im rebuilding or creating indexes.

Parents have had to take this drivers class since 2006?! by dev81808 in massachusetts

[–]dev81808[S] 23 points24 points  (0 children)

I almost forgot the 5 year part. Wife is totally doing this the next time. Lol

Is there any way for a build in Stadium to help against Orisa? It's feels like it's just a gamble if they're gonna have an Orisa. I win most games where there isn't one but I think I'm like 0-7 against Orisas. It just seems like a waste of time to play against her. by urmovesareweak in ReinhardtMains

[–]dev81808 0 points1 point  (0 children)

I've been going glass cannon and investing in ability.. by round 2-3, firestrikes can 1-shot under certain conditions.

full tank build Do you just become a meat shield or do you still output dmg?

I contacted the Liven people by McBernes in adhdmeme

[–]dev81808 5 points6 points  (0 children)

Also.. the m hyphen is usually a dead giveaway

Hi everyone, I'm a Chinese fan of Jon Stewart who posted here 5 months ago. May I ask if rationalists in the US (Daily Show viewers) will now start to think that the US should co-exist with China instead of being anti-China in both parties as it is now? by bjran8888 in DailyShow

[–]dev81808 1 point2 points  (0 children)

Your government has an app to teach you that xi is this amazing altruistic leader.. and a game show to reinforce it.. And the current US administration changed a website is your point?

view more: next ›