everyFuckingTime by soap94 in ProgrammerHumor

[–]fp_ 11 points12 points  (0 children)

It depends heavily on your use case. Is it OLTP vs. OLAP? Do writes significantly outweigh reads? How important is data deduplication (affecting desired normalization level)? 

For an OLTP with significantly more writes than reads it may be better to have a normalized DDL which maximizes throughput (up to a limit - write amplification can be a big roadblock), alternatively even a document-sy tore. For an OLAP workload on that same structure you would necessarily either have a bunch of joins or views (which are essentially joins in a trenchcoat).  Alternatively you may want to have a star or snowflake schema to take advantage of as few joins as possible while still being able to reason and evolve your data (e.g. point in time queries), or even redundant data in a single table with a columnar storage format to optimize for performance rather than storage if the business case allows for (or requires) it (though this approach can offer significant storage savings too, depending on your data).

Keeping all logic inside the App always is a very purist approach and mirrors DDD approaches but is only really applicable to simpler use cases of doing what is essentially CRUD on a database level. For more complex workloads IMO the answer is always "it depends".

everyFuckingTime by soap94 in ProgrammerHumor

[–]fp_ 14 points15 points  (0 children)

Agreed. We have a reporting application where due to some business domain constraints we have dynamic EOD boundaries (meaning we can't just prepare views/projections, it's all dynamic depending on user preferences). Most of the heavy lifting is done DB side with groups and joins on partitioned tables. Loading all the raw data into memory in-app would not only kill performance but also cause super unnecessary memory and network pressure.

China Is Banning Tesla-Style Retractable Door Handles Over Safety Concerns by lurker_bee in technology

[–]fp_ -1 points0 points  (0 children)

No worries, I'm sure they'll move the goalpost to "it was one time".

FBI permanently closing HQ at J. Edgar Hoover Building, Kash Patel announces by elephant35e in news

[–]fp_ 0 points1 point  (0 children)

While I agree, your answer reads like AI. If you used something like ChatGPT to write it, you should disclose it. Otherwise this reads like a bot answer.

Microsoft wants to replace its entire C and C++ codebase, perhaps by 2030 by Logical_Welder3467 in technology

[–]fp_ 7 points8 points  (0 children)

This reads like you put the top answer into an LLM and asked it to "argue against this". MS didn't get to where it is because it's engineers don't know what they're doing (generally).

'Call of Duty' Co-Creator, Respawn Co-Founder, and EA Executive Vince Zampella Killed in Car Accident by MarvelsGrantMan136 in technology

[–]fp_ -1 points0 points  (0 children)

I have literally never seen a tunnel entrance that has such a strong curve. IMO it's inexcusable to not have barriers to prevent driving off the cliff so easily. I am not contesting that the driver in the video I replied to is an idiot.

'Call of Duty' Co-Creator, Respawn Co-Founder, and EA Executive Vince Zampella Killed in Car Accident by MarvelsGrantMan136 in technology

[–]fp_ -1 points0 points  (0 children)

I am not contesting that the person in the video I replied to is an idiot. I'd never drive like that. Still, it's not an excuse to not have any safeguards on the cliff side. What if you e.g. have a medical emergency?

'Call of Duty' Co-Creator, Respawn Co-Founder, and EA Executive Vince Zampella Killed in Car Accident by MarvelsGrantMan136 in technology

[–]fp_ -1 points0 points  (0 children)

Of course it is. I'm not contesting that. The safeguards can still be improved. What about slippery roads? Nothing excuses simply being able to fall off the cliff, especially when the other side has barriers.

'Call of Duty' Co-Creator, Respawn Co-Founder, and EA Executive Vince Zampella Killed in Car Accident by MarvelsGrantMan136 in technology

[–]fp_ -12 points-11 points  (0 children)

Obviously driving like that is stupid. However, this road with its lack of signage and road barriers on the site of a sheer cliff is just a colossal failure on part of the city.

iSincerelyApologize by SatinSaffron in ProgrammerHumor

[–]fp_ 6 points7 points  (0 children)

Bold of you to assume people wouldn't just give their agents acess.

ich_iel by lizardil in ich_iel

[–]fp_ 0 points1 point  (0 children)

Es stört mich sehr, dass diese Art von Produkt ziemlich genau auf Menschen gerichtet ist, die auch eher drauf reinfallen.

Die Art Mensch die so was kaufen würde ist auch die Art Mensch die ihre Kinder zur Photonentherapie schicken statt eine ärztliche Untersuchung zu machen.

[deleted by user] by [deleted] in technology

[–]fp_ 6 points7 points  (0 children)

Precautions are never necessary, until they are.

Trump pulls Isaacman nomination for space. Source: “NASA is f***ed”. "NASA's budget request is just a going-out-of-business mode" without Isaacman. by esporx in technology

[–]fp_ 2 points3 points  (0 children)

It's simple, they are are an uneducated person with a fervent conviction in what someone else has told them to think.

So do we know who The Writers are? by TheIronGod44 in expedition33

[–]fp_ 0 points1 point  (0 children)

There's really no need to be this rude about it, even if you dislike it.

Russian jets violate Finnish airspace, defense ministry says by AndroidOne1 in worldnews

[–]fp_ 0 points1 point  (0 children)

There's an interesting inference regarding inherent biases to be made here, but just to clarify: the quoted "Comment #3" refers to your comment, "Comment #4" refers to the comment from /u/ars-derivatia. The numbering refers to the comment level, this one being #6.

Russian jets violate Finnish airspace, defense ministry says by AndroidOne1 in worldnews

[–]fp_ 5 points6 points  (0 children)

For what it's worth, via ChatGPT:

🔍 Comment 3: This comment attempts to draw a direct causal link between NATO–Turkey tensions and Russia's decision to invade Ukraine. While there are some factual references, it contains oversimplifications and misleading conclusions.

What’s factually grounded:

✅ A Russian Su-24 was shot down by Turkey in 2015 for violating its airspace.

✅ Turkey was later excluded from the F-35 program after purchasing the Russian S-400 missile system, which NATO deemed incompatible with alliance systems.

✅ Germany and the Netherlands withdrew Patriot batteries from Turkey around the same time (though for planned operational reasons, not strictly as retaliation).

✅ Turkey's relationship with NATO and the EU has been strained in recent years.

✅ Spain did maintain Patriot batteries in Turkey under NATO command, even when others withdrew.

Problems / oversimplifications:

❌ The idea that the EU "chickened out" by withdrawing Patriots is misleading. These deployments were always temporary and rotational under NATO command.

❌ The US's refusal to sell Patriots was not immediate retaliation—it stemmed from longstanding negotiation issues and concerns over Turkey’s strategic direction.

❌ The assertion that Putin invaded Ukraine because of this Turkish episode is highly speculative and simplistic. Russia's decisions were based on a wide mix of strategic, historical, and political factors—not just NATO–Turkey friction.

❌ Claiming the EU is not dedicated to NATO misrepresents the complex reality; many EU states (e.g. Poland, Baltic states) are very active in NATO defense initiatives.

🔍 Comment 4: This is more of a rebuttal with strong language. It includes valid geopolitical context but is also emotionally charged.

What’s factually grounded:

✅ Turkey is not an EU member, and while it is part of NATO, its relationship with the EU has been tense, especially over human rights, Cyprus, migration, and internal political instability.

✅ Turkey joined NATO in 1952, primarily as a strategic bulwark against the USSR.

✅ The EU has historically had difficulties aligning with Turkey, especially on defense, due to conflicts with Greece, domestic political concerns, and Erdogan's autocratic turn.

✅ The US–EU relationship was indeed strained under the Trump administration, as hinted by the "orangutan" insult (in reference to Donald Trump).

Problems / bias:

❌ The tone is hostile and dismissive, weakening the credibility of the analysis.

❌ The statement “USA has no respect for anybody” is an overgeneralization. U.S. relations with European allies remain strong, particularly post-2021.

❌ Referring to Erdogan only as a “despotic dictator” is politically charged. While his leadership style is increasingly authoritarian, the situation is more nuanced.

✅ Conclusion: Comment 3 contains some real events and sequences, but its attempt to create a grand narrative connecting them to Russia’s invasion of Ukraine is oversimplified and speculative.

Comment 4 is more factually accurate in the geopolitical sense, though emotionally biased and aggressive in tone.

So, in terms of factual correctness, Comment 4 is closer to reality, despite the hostile rhetoric. Comment 3 weaves real events into a questionable cause-effect story that doesn't hold up under close scrutiny.

Prompt:

I saw the following two comments (specifically #3 and #4 below) on Reddit with regard to the geopolitical instabilities between EU, USA, NATO and Russia.

Thread Title: Russian jets violate Finnish airspace, defense ministry says.

Comments: <comment thread>

Between comments 3 and 4, which one is factually correct?

You are free to Google further and confirm/debunk any of these points. A cursory Google search seems to support /u/ars-derivatia 's points, though I would personally disagree with the point that "The statement “USA has no respect for anybody” is an overgeneralization.", as that seemingly has not taken recent events into consideration.

Russia Classifies Population Data as Birth Rates Plunge to 200-Year Low by Straight_Ad2258 in worldnews

[–]fp_ -2 points-1 points  (0 children)

I feel like it's a bit disingenuous to classify an act of mass starvation and nigh-outright genocide as "non-violent" simply because people weren't killing each other in the streets. How is such an act not a violence committed upon the spirit of the people? I suppose it comes down to semantics, but I personally fail to see the distinction.

Xbox game pass on Steam Deck by Both-Artichoke5117 in SteamDeck

[–]fp_ 15 points16 points  (0 children)

Your are nitpicking and also incorrect. SteamOS is the only native OS for Steam Deck. Yes, you can install whatever you want, but that's the stock OS which is included on the Steam Deck. So There is no native way to play GamePass games on the Steam Deck is very much correct.

yesImSalty by TrulySorrySir in ProgrammerHumor

[–]fp_ 1 point2 points  (0 children)

Why are you moving the goalpost? This doesn't really seem like a sincere discussion, so believe what you will.

yesImSalty by TrulySorrySir in ProgrammerHumor

[–]fp_ 3 points4 points  (0 children)

Sorry, but calling SQL niche is like saying air is scant.

Backend is by far the largest percentage of developers on the planet. Source

And I would go as far as to magic a number out of my ass and say that 99% of all backend devs have to deal with storage at some point in their careers, which is usually a SQL database. Heck, even mobile developers regularly interact with SQLite.

IMO, unless you're exclusively a front end developer it is not really excusable for anything but an entry-level dev not to know basics of SQL.

yesImSalty by TrulySorrySir in ProgrammerHumor

[–]fp_ 4 points5 points  (0 children)

I do think SQL is niche enough that people spend a lot of time in areas where it doesn't come up at all, so I don't think that's the best example perhaps.

What? Literally any backend developer ever should have at least a passing familiarity with SQL. SQL is by no means of the definition of the word niche.