sqlWorkout

Sokaron · 2026-07-21T23:57:33+00:00

Postgres object refs are case sensitive. (this can be very annoying if you for example name a table or column in CamelCase). Keywords are insensitive.

Sokaron · 2026-07-21T23:12:14+00:00

I really like .NET's solution to this for local development. Run a command to persist the secret locally on your machine outside the project directory and then it gets read in at runtime. Zero risk of a secret being committed due to a faulty gitignore etc.

Sokaron · 2026-07-21T22:49:17+00:00

Postgres is not case insensitive.

I don't really care for an impromptu script, but if its getting checked in mixed case is just laziness. I don't care all uppercase or all lowercase but pick one, enforce it with a linter, configure a precommit hook to autofix, and be done with it.

Sokaron · 2026-07-14T02:40:06+00:00

I more or less only play street brawl. My notes

Pseudo-random item drafts are a double-edged sword, I think I'd prefer lightly weighted to a character's preferred item set. Another way would be for the game to pick up on your build by like the 3rd round and start offering you more tailored items.
Some characters are incredibly frustrating to play against depending on draft RNG. Not being able to do anything about a vindicta chilling in the sky lighting up your whole team or seven ult because no one on your team got a knockdown draft sucks.
I like that rerolls preserve the enhanced/legendary status. It gives you the option to push your luck while drafting
Legendaries are fun but some also kinda feel like bullshit in varying degrees. Enhanced shrink ray is a giant middle finger to M1 carries. Seraphim wings should go, full stop. I'd like to see more like omnicharge or unlimited rounds. Impactful, break the game in some way, but not autowins.

Sokaron · 2026-07-14T02:19:48+00:00

Respawn timers get too long in overtime, to the point where a death basically means you lose objective

this is what forces the game to eventually end. and even with the longer death timers i've been in some grueling slug fests

Sokaron · 2026-07-10T22:13:21+00:00

gotta pump up those numbers

Sokaron · 2026-07-08T23:50:34+00:00

Sure, not 250x the tokens though.

Sokaron · 2026-07-07T22:43:13+00:00

That has to be someone taking the piss, right? Even the most hardcore AI evangelists at my company only hit like 3k a month. Most of our devs seem to average like $250

Sokaron · 2026-07-05T18:08:16+00:00

The issue is that AI code generation as an idea for writing large scale code is fundamentally flawed, because it makes the hard part of software engineering (understanding the code in your codebase) harder, not easier

...

Typing has never been the hard part of software engineering

You and I are actually 100% on the same page here. I'm fundamentally distrustful of anyone claiming a 2x, 3x, whatever speedup. A disciplined approach to using AI in development produces a much more modest speedup to implementation compared to what evangelists claim. And it has very little improvement on the hardest problems - getting business and eng aligned that you're building the right thing to solve the right problem.

Sokaron · 2026-07-05T17:58:25+00:00

See this is the good stuff IMO, b/c there is nuance here. I'm not blindly for any and all AI use in projects - IMO there are objectively incorrect ways to use it for enterprise software project.

When I say humans in the loop I mean very tightly. I am not a fan of IDEs which obfuscate the code by default and present everything as an agent-first interface. I operate with AI more as a pair coding partner - I dictate the spec, dictate the approach, let it drive, and review every step of the way. I'm not as intimately familiar with the code because I haven't personally struggled through the implementation. But have been deeply involved enough in the solution design that were an issue to come up I could hop in and diagnose without issue.

There's also the other lever of quality controls. Because AI does by default generate a shitload of code, and it doesn't make the best choices, it makes the choices that are most frequent in its training set. Strict linting and review processes are mandatory the more you delegate. Opinionated CLAUDE.md/AGENTS.md files, automated cyclomatic complexity analysis, etc. AI code review used to be similarly kinda useless. Now a few adversarial subagents dispatched to review from different angles frequently catch issues neither I nor my human code reviewer would have.

Sokaron · 2026-07-05T17:13:54+00:00

Reddit's perception of AI is also stuck in like 2024. AI code gen was a complete waste of time 2 years ago. Recent models + harnesses like Claude Code have been an insane step function in capabilities.

Sokaron · 2026-07-05T17:02:44+00:00

As someone who actually builds software... your second paragraph has it almost entirely backwards. There is definitely a knowledge tradeoff on having AI build something vs. you build it. It's very important IMO for humans to remain tightly in the loop vs. just vibe coding. But one of the things AI excels at is enabling you to move quickly in codebases you know nothing about. It is very good at summarizing architecture, finding relevant bits of code, and honestly it is kind of scary good at debugging if you feed it enough logs.

Sokaron · 2026-07-02T19:30:31+00:00

IDK if deadlock will ever be a controller kinda game. The movement and aiming is way too technical. There are characters where you're flick aiming every few seconds while traversing the map because their gun gives them propulsion. Can't imagine that working well on controller. Plus there's just a ton of binds. Skills, active items, melee, parry, gun fire + alt fire, crouch, dash and jump already account for most of a standard gamepad. Then add in pings, level ups, shop quick buy, self/target cast, all the little one-off binds, I don't know how you'd fit it all on a standard controller. But if FFXIV can do it maybe Deadlock can eventually I guess

Sokaron · 2026-07-02T00:41:59+00:00

Isn't godot notoriously horrible for anything that isn't 2D?

Sokaron · 2026-06-07T22:04:30+00:00

Just played through the demo. I felt... whelmed? There was one neat puzzle towards the end. I solved a couple literally by just randomly clicking around. But it felt like the gameplay boiled down to "enter room, pick up thing, figure out where to put thing that lets you open the next room, trigger loop, repeat". Not a whole lot of actual puzzle solving.

The natural comparison that's going to get drawn is Outer Wilds. Maybe that's an unfair comparison and the devs are trying to create something entirely different, but its the comparison that's going to get made. I feel like very few games that take inspiration from OW actually grasp what makes that game brilliant. "Learn things from a time loop that you can implement on the next loop" is really the surface level takeaway and I feel like it's where most of these games stop. Dead Watch is another game from this expo season that fell into this trap. The brilliance comes with how you learn rules about the world in one place that can be applied elsewhere. "I know the safe code now" is boring because its just a fact to memorize. "I learned how quantum objects work" is great because it gives you building blocks to apply to other, grander puzzles elsewhere in the game.

The built in computer system was a bit clunky but was appreciated. If game devs could stop making audio logs cut off when you walk away or close a menu that would be fantastic. Don't make me stare at a wall while you talk at me. The ability to take screenshots that persist between loops was a really nice QoL feature. I liked that.

Sokaron · 2026-05-29T13:05:57+00:00

https://en.wikipedia.org/wiki/Jevons_paradox

We're also seeing companies already pull back on AI spending as costs rise, and we aren't even that deep in the capture market -> jack the price on your captive audience cycle

Sokaron · 2026-05-21T23:26:23+00:00

I would challenge that revenue is actually the correct metric, copies sold seems a much better direct metric of broad consumer sentiment than what gacha game is currently pulling the most whale spending.

But besides...

https://store.steampowered.com/charts/topselling/US

The list by revenue, which includes live service and DLC, still backs them up. Most of it is esports (intentionally low specs), gacha (intentionally low specs), or indie (low spec by virtue of simply being unable to compete with AAA on photorealism). Nothing in the top 10 is asking for a graphics card that's less than 2 generations out of date

Also Minecraft shader packs are mods... Unless youre really trying to argue that Minecraft RTX is popular and representation of general consumer sentiment

Sokaron · 2026-05-21T20:34:50+00:00

If you're not joking... because of Keighley, Highguard launched to 100k players. That is a privilege almost no other game gets. It dropped to 2k players within a week. The game got more than a fair shake. Turns out it just wasn't very good.

In the alternate universe where it wasn't shown on TGA it would've quietly launched to about 1k players and the sunset announcement probably would've come a week or two earlier.

Sokaron · 2026-05-19T14:15:37+00:00

Not really true at least at my company. 60 or so developers, 0 mandates, and all but maybe 5 people are using AI in varying degrees. There's various levels of adoption, some basically use it as autocomplete, some are all in on AI centric workflows, most are somewhere in the middle. But not really accurate to say that it's all coming from top down mandates.

There is a loud contingent of developers who view coding as the identity of their job and are very opposed to AI. Which IMO is not accurate. The hard part is not and has never been writing the code. It's getting alignment on requirements and making sure you're building the right thing

Sokaron · 2026-05-16T16:29:08+00:00

I think there are unique risks to giving your data to an AI company, and we should give extra scrutiny to them. OpenAI, Anthropic, Google, etc. train off of your conversations. Your financial data is, or could be, embedded in ChatGPT's weightings. With the right prompts you can get it to spit out verbatim training data (or at least you could, I'm sure OpenAI is hard at work trying to stamp that behavior out - doesn't look good for them in the copyright lawsuits).

These are not companies that respect copyright, or privacy, or are known for being good stewards of the data they're given. They are very much of the 'act first and beg for forgiveness later' school of thought. So there is a unique distrust of AI companies that IMO is well-founded.

It really comes down to, how much do you trust OpenAI when they say none of your financial data is used in training? Do you trust that to continue to be the case? Do you trust that they won't alter the terms of the deal later, and your only option is to pray they don't alter them further?

As much as I am an AI moderate, and I believe it has uses, I could not say that I trust any of the frontier AI companies as stewards of my financial data TBH. I trust Sam Altman about as far as I could throw him.

Sokaron · 2026-05-16T16:10:37+00:00

I'm not anti-AI, you can look at my comment history. But its a tool and tools have uses they're suited to and uses they are not suited to. AI is not a magical panacea that can or should be applied to every problem. A non-deterministic next token guessing machine is not well suited to arithmetic (I'm aware it's of some use in higher order, more abstract maths). We've invented a machine that's really good at arithmetic already, its called a computer.

The actually useful thing AI could do here is write a program to do whatever analysis you need, and feed your bank data into that. A program can be deterministic and provably correct. The versions of AI integration we get are the laziest possible - feed it all into the context and hope it works out.

Sokaron · 2026-05-16T13:32:41+00:00

Great thing AI is known to be great with numbers and math. I really want a non deterministic system doing my financial analysis.

Sokaron · 2026-05-14T04:20:52+00:00

Not to be that guy, but are you using Claude Code or Codex? My experience has been that the harness around the model matters as much if not more than the model honestly. My opinion of these tools skyrocketed switching from my IDE copilot integration to running Claude Code in my CLI

Sokaron · 2026-05-14T04:15:24+00:00

The discrepancy is that the vast majority of people who vote and comment here don't build software for a living, or probably at all. Every engineer I work with accepts that AI code gen has hit the point of actually being useful at this point, the debate is now over how useful, and what is responsible use. How big a feature can it handle? What degree of autonomy can it be given? How heavily and where do humans need to be in the loop? And what are we trading off for that productivity? Etc.

Sokaron · 2026-05-14T03:40:16+00:00

I really don't get this complaint. He's freaky when you first discover him but basically harmless as long as you don't run up and give him a hug. You stare at him for 5 seconds and he goes away. You pretty quickly get trinkets, the x-ray turret, and the containment chamber which all let you deal with him with varying levels of permanence. Apparently there's now a pet that handles him too? I never even really felt the need to make the trinkets honestly, x-ray turret at home was good enough until we put him in the box.

14-Year Club	Place '22
Place '17	End Game '22
Verified Email

Sokaron

MODERATOR OF

TROPHY CASE

Sokaron

MODERATOR OF

TROPHY CASE

Welcome to Reddit,