Comments

This profile is from a federated server and may be incomplete. Browse more on the original instance.

koreth, to pcgaming in Steam’s top-rated game is getting a free, eight-hour prequel campaign [community MOD for Portal 2]

I was impressed by an earlier mod along similar lines, Portal Stories: Mel. Hope this one is as well-done.

koreth, (edited ) to startrek in ‘Star Trek: Prodigy’ Finds New Home At Netflix After Paramount+ Cancellation

I don’t think Netflix actually cancels shows after two seasons any more often than other networks do.

Somehow people got it into their heads that Netflix is far more cancel-happy than its competitors, but if you look at the numbers, traditional TV networks have had like a 50% cancellation rate for decades.

Even TOS was cancelled after two seasons!

If Netflix is more prone to cancelling shows at all, which I’m not convinced is even true, it can’t be by an enormous margin.

koreth, to science in Pythagorean Theorem Found On Clay Tablet 1,000 Years Older Than Pythagoras

The paper (linked from the article) has a photo of the actual tablet in question, which was apparently discovered circa 1900.

koreth, to programming in Is there something better than SQL?

SQL, where injection is still in the top 10 security risks

This is absolutely true, but it’s not what it looks like on the surface, and if you dig into the OWASP entry for this, you’ll see they talk about mitigation.

You can completely eliminate the possibility of injection attacks using well-understood technologies such as bind variables, which an ORM will usually use under the covers but which you can also use with your own queries. There are many, many database applications that have never once had a SQL injection vulnerability and never will.

The reason SQL injection is a widespread security risk, to be blunt, is that there are astonishingly large numbers of inexperienced and/or low-skill developers out there who haven’t learned how to use the tools at their disposal. The techniques for avoiding injection vulnerability are simple and have been well-documented for literally decades but they can’t help if a lousy dev decides to ignore them.

Now, a case could be made that it’d be better if instead, we were using a query language (maybe even a variant of SQL) that made injection attacks impossible. I agree in principle, but (a) I think this ends up being a lot harder than it looks if you want to maintain the same expressive power and flexibility SQL has, (b) given that SQL exists, “get bad devs to stop using SQL” doesn’t seem any more likely to succeed than “get bad devs to use bind variables,” and © I have too much faith in the ability of devs to introduce security vulnerabilities against all odds.

koreth, to programming in Is there something better than SQL?

it would be great to “just” have a DB with a binary protocol that makes it unnecessary to write an ORM.

Other people have talked about other parts of the post so I want to focus on this one.

The problem an ORM solves is not a problem of SQL being textual. Just switching to a binary representation will have little or no impact on the need for an ORM. The ORM is solving the problem that’s in its name: bridging the conceptual gap between an object-oriented data model and a relational data model. “A relational data model” isn’t about how queries are represented in a wire protocol; instead, it is about how data, and relationships between pieces of data, are organized.

So, okay, what if you get rid of the relational data model and make your database store objects directly? You can! NoSQL databases had a surge in popularity not too long ago, and before that, there have been lots of object databases.

What you’re likely to discover in an application of any real complexity, though, and the reason the industry has cooled somewhat on NoSQL databases after the initial hype cycle, is that the relational model turns out to be popular for a reason: it is extremely useful, and some of its useful properties are awkward to express in terms of operations on objects. True, you can ditch the ORM, but often you end up introducing complex queries to do things that are simple in SQL and the net result is more complex and harder to maintain than when you started. (Note “often” here; sometimes non-relational databases are the best tool for the job.)

And even in an object database, you still have to know what you’re doing! Storing objects instead of relational tuples won’t magically cause all your previously-slow queries to become lightning-fast. You will still need to think about data access patterns and indexes and caching and the rest. If the problem you’re trying to solve is “my queries are inefficient,” fixing the queries is a much better first step than ditching the entire database and starting over.

koreth, to programming in Is there something better than SQL?

You’re not missing much power with jOOQ, in my opinion as someone who has used it for years. Its built-in coverage of the SQL syntax of all the major database engines is quite good, and it has easy type-safe escape hatches if you need to express something it doesn’t support natively.

koreth, (edited ) to patientgamers in Games with absolute banger OSTs (and perhaps good stories / gameplay)

Totally fair! They did a good job of making the main storyline playable as a solo player, but the core gameplay loop is still unmistakably MMO-style and not to everyone’s taste.

I love that song in particular because (very minor spoiler) it works both as background music and as diegetic music. In the story, that boss is trying to entice you into going permanently to sleep and living in a dream world where you’ll achieve all your goals and desires, while becoming her meat puppet in the real world. When you’re playing the game rather than watching it with onscreen lyrics on YouTube, you are only sort of half-listening to the song while you focus on the battle, so you don’t realize right away that the battle music is the boss singing to you to seduce you into her flock even while you’re fighting her.

koreth, to patientgamers in Games with absolute banger OSTs (and perhaps good stories / gameplay)

Final Fantasy XIV has a diverse soundtrack and a terrific story, but it is a huge time commitment. The story starts off pretty slow and takes a long time to build up.

A few boss fight themes as examples:

koreth, to games in Marvel's Avengers receives hulking discount ahead of delisting

As a fan of Ms. Marvel, I enjoyed the main campaign well enough, but all the MMO stuff is obnoxious. Luckily you can mostly ignore it and go through the campaign missions single-player. I uninstalled it after getting to the end of the story.

koreth, to programming in I wish writing SQL queries was more popular than ORMs

jOOQ is really the best of both worlds. Just enough of an ORM to make trivial CRUD operations trivial, but for anything beyond that, the full expressive power of SQL with added compile-time type safety.

And it’s maintained by a super helpful project lead, too.

koreth, to asklemmy in What bugs the heck out of you at work but doesn't seem to bother your coworkers?

Especially infuriating when the other person is in a very different time zone. I once worked on a project with a partner company in a time zone 10 hours ahead of mine and it was common for trivial things to take days purely because the other person insisted on typing “Hi,” waiting for my “Hi, what’s up?” response (which they didn’t see until the next day since our hours didn’t overlap), and then replying with their question, which I didn’t see until my next day. Answering the actual question often took like 30 seconds, but in the meantime two or three days had gone by.

I came to believe they were doing it on purpose so they could constantly slack off and tell their boss they were blocked waiting for my answer.

koreth, to asklemmy in What bugs the heck out of you at work but doesn't seem to bother your coworkers?

My frustration is less with the people who are late and more with the meeting host making the rest of the attendees sit around twiddling their thumbs waiting for the late person. Unless the late person’s presence is the point of the meeting, just get started and let them catch up.

koreth, to asklemmy in What bugs the heck out of you at work but doesn't seem to bother your coworkers?

“We’ll wait a few more minutes for person X to join, then get the meeting started,” like the other ten people who made the effort to show up on time deserve to be punished with extra meeting time for being responsible. Bonus points if this causes the meeting to run a few minutes long.

koreth, to moviesandtv in Study: Streamers Now Wasting Record Amounts of Time Finding Something to Watch

Using it to describe streaming services isn’t new. For example, here’s a Variety article from 2019 that uses it that way.

koreth, to moviesandtv in Study: Streamers Now Wasting Record Amounts of Time Finding Something to Watch

“Streamer” has been a widely-used entertainment-industry term for streaming companies for years. It’s not a new thing people are making up to be cute.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • random
  • uselessserver093
  • Food
  • aaaaaaacccccccce
  • test
  • CafeMeta
  • testmag
  • MUD
  • RhythmGameZone
  • RSS
  • dabs
  • KamenRider
  • TheResearchGuardian
  • KbinCafe
  • Socialism
  • oklahoma
  • SuperSentai
  • feritale
  • All magazines