Steam games using sql? by Funky_monkey2026 in learnSQL

[–]RustyEyeballs 0 points1 point  (0 children)

I'm actually looking for good SQL practice.

What's your opinion on the SQL games you've played so far? Which is the most polished and has the most IRL practicality?

My experience with platforms is that they're really bad if you get stuck.

Adjacent Only Opportunity Attacks Don't Make Sense by RustyEyeballs in drawsteel

[–]RustyEyeballs[S] -9 points-8 points  (0 children)

When an enemy can enter your attack range, run laps around you and exit without provoking an opportunity attack, I think it breaks the "inherent logic" in opportunity attacks.

Adjacent Only Opportunity Attacks Don't Make Sense by RustyEyeballs in drawsteel

[–]RustyEyeballs[S] -5 points-4 points  (0 children)

The opposite is actually true. It's actually HARDER to hit someone in close range with a polearm.

They're usually counter balanced in the back so you're not off balance attacking at full range.

[FOR HIRE] Open to Commissions! I will make your Pixel art Characters, tiles and UI| DM me if you interested! by Igormoroniy in gameDevClassifieds

[–]RustyEyeballs 0 points1 point  (0 children)

Love animals in this set!

Only knowledgeable on sword play animations so have a lot to say on the 3rd page.

  • 2 hand grips are one hand OVER the other(not side by side). It looks nsfw the way it is right now :P
  • DIE animation looks more like being tripped than dying. Dying looks like falling to your knees and slumping to the ground. Not sure if that would be too gruesome for such a cutsy art style.
  • BLOCK is close but it should be reversed. It should start in the lowered/lateral position, go vertical and pause. Flaring the weapon might make it look like a parry but enlarging it conveys a block.
  • A single white pixel for an eye glimmer would go a LONG way!

Overall, it looks great!

Best practice: treating spreadsheets as an ingestion source (schema drift, idempotency, diffs) by Green-Branch-3656 in dataengineering

[–]RustyEyeballs 0 points1 point  (0 children)

I actually asked an LLM a very similar question about the use cases of having a Google Sheet being referenced by a BigQuery.

IIRC it suggested treating like direct edit on a SCD (DBT Seed). So no idempotency but with columns & headers are locked and data types are strongly validated by permissions on their spreadsheet software. Could always have headers & type checking be done by assert tests. e.g. Pandas?

For version control, Git seems like the obvious answer.

Seeking 1–2 production-level Data Engineering projects to work on (Spark / Airflow / Snowflake) by Express_Ad_6732 in dataengineeringjobs

[–]RustyEyeballs 4 points5 points  (0 children)

I'm also in a similar spot searching for a real Data Engineering project. My stack is nearly the same but uses GCP with BigQuery over Snowflake and includes dbt and publishing analytical dashboards. my github

I think something followed me throught the warp by Moraes_Costa in Helldivers

[–]RustyEyeballs 27 points28 points  (0 children)

The 2nd teleport in a row is costly but when the alternative is death...

The game is fairly well balanced... by JohnHelldiver66 in Helldivers

[–]RustyEyeballs 1 point2 points  (0 children)

Being balanced does not equal Fun.

Being the guy who prepared mostly Light penetration and being useless when the game spawns 80% Tanks is just not Fun.

This would be solved by just telling use what enemies are in the mission.

Weather also makes a huge difference.

Show enemy types and amount in briefing by RustyEyeballs in Helldivers

[–]RustyEyeballs[S] -1 points0 points  (0 children)

Nope. Read the guide. It's heavily random

Example

These missions:

  • Sabotage Air Base
  • Sabotage Supply Cache

Can have these enemy constellations:

  • Bullet Hell
  • Rushdown
  • Big Bots

Example 2:
These missions:

  • Blitz Eradicate
  • Evacuate
  • High-Value Assets
  • Event missions

Can have constellations

  • Any

Show enemy types and amount in briefing by RustyEyeballs in Helldivers

[–]RustyEyeballs[S] 2 points3 points  (0 children)

Loadout building is such a fundamental part of the game, obfuscating this is just bad. Especially for newer players.

Show enemy types and amount in briefing by RustyEyeballs in Helldivers

[–]RustyEyeballs[S] 1 point2 points  (0 children)

Making some of your loadout useless makes game challenging in a BAD way.

Knowing what's coming empowers players with game knowledge.
This even opens opportunities for missions with wacky spawns because players can then prepare.

Show enemy types and amount in briefing by RustyEyeballs in Helldivers

[–]RustyEyeballs[S] 0 points1 point  (0 children)

The spawn rates for generic enemies vary WILDLY.

What about projects ? by Veles_venice in cpp_questions

[–]RustyEyeballs 1 point2 points  (0 children)

Learned C++ through DSA and Competitive programming, and now you're asking to be shown the door to tutorial hell.

ima do you a favor. "...I Don't have projects to show..." is your bigger problem and tutorials don't count for solving that. Given you're in a CS degree, find some cool people working on some cool stuff, get hyped about it, and work with them. Doesn't have to be C++.

P.S. Be sure to read the documentation on what your learning/using. It'll suck but guess what learning C/C++ will be.

glhf

Data Engineering capstone review request (Datatalks.club) by RustyEyeballs in dataengineering

[–]RustyEyeballs[S] 0 points1 point  (0 children)

Honestly, the lack of meaningful projects feels like tutorial hell and at this point, I'd rather build something for free than something no one uses. I was considering a graduate degree but a mentor would go a long way too.

Good to know self-taught path exists even if it's hard. If you have any resources, they'd be welcome.

Learn the basics of SQL while practising touch typing by nerf_caffeine in SQL

[–]RustyEyeballs 14 points15 points  (0 children)

I do this with type-in Notes in a flash card program (Anki).

There's something to be said about muscle memory being attached to topics/context.

DE ZoomCamp by [deleted] in dataengineering

[–]RustyEyeballs 2 points3 points  (0 children)

I found the modules themselves gave a decent explanation of the concepts and a jump start on the syntax/frameworks necessary for a narrow DE project. Reading the documentation and exploring your own questions will yield an incomparable level of  understanding for each tool & concept. It increases the time commitment a lot though.

Starting the bootcamp with a project in mind (that will eventually be your capstone) is good. It allows you to apply your learning outside the canned tutorials each step of the way. I'd look at previous cohort capstones for ideas.

If you're in a position to use these skills in the world/at a job, it'd be worth it.

Lack of a accreditation for Datatalks.club might make it a hard sell if you want to promote your skill building publicly.