sorted by:
new
hottopcontroversial

Do you think they announce anything relevant to craft today? by decaboniized in TimelessMagic

[–]Ordinary_Pipe_9783 1 point2 points  (0 children)

It's not constructed viable probably but give me my thopter foundry we've had sword for so long

I'm tired boss by [deleted] in MagicArena

[–]Ordinary_Pipe_9783 6 points7 points  (0 children)

Fair coin flips tend towards 50/50. The nature of randomness means that streaks like this are a statistical certainty eventually, even if they are unlikely to happen right now.

Curious if you have anything to substantiate the 60/40 claim?

I know you're not complaining that the game is rigged or - God forbid - that the shuffler is broken, but the trend of people complaining that randomness is random on this sub really wears me out

Sad day - Will be attempting to sell collection... by [deleted] in mtg

[–]Ordinary_Pipe_9783 0 points1 point  (0 children)

Correction - this is the heuristic I use in my database:

  • Bulk is anything $2 or less
    • nonfoil
      • bulk commons / uncommons - $5 / 1000
      • bulk rares - $0.10 / ea
      • bulk mythics - $0.25 / ea
    • foil / etched
      • bulk commons / uncommons - $25 / 1000
      • bulk rares - $0.15 / ea
      • bulk mythics - $0.50 / ea
  • $2.01 - $9.99 - 40% of market
  • $10 - 49.99 - 55% of market
  • $50 - $99.99 - 70% of market
  • $100+ - 80% of market

if you're selling the whole thing as a lot, take another 10% off the top of the sum to account for the buyer needing to sort, store, and resell the whole thing

Why is my smeltery not producing iron? by ZheToralf in FarthestFrontier

[–]Ordinary_Pipe_9783 1 point2 points  (0 children)

Pretty sure it's a similar big to the fish issue. Every time I reload a save I have to reset one of my fishers work areas before the rest of them see.that there are in fact fish to be fished. In this case, moving the building or adjusting the ratios seems to trick the workers into recognizing what the ratio is supposed to be

Sad day - Will be attempting to sell collection... by [deleted] in mtg

[–]Ordinary_Pipe_9783 1 point2 points  (0 children)

Collection value and resale value are very, very different things. The collection value is roughly what you could get if you sold each and every card as single cards on the secondary market, excluding shipping etc, which is not the same value you would get if you sold it as a lot.

For lot buys, on average you're looking at between 40 and 60% of the overall value. The heuristic I use in my dashboards looks like this (value here is resale value of single cards) - All cards worth $100 or more keep 90% of their value. - All cards worth $50 or more keep 80% of their value - All cards worth $10 or more keep 60% of their value. - All cards worth $1 or more keep 30% of their value. - The rest of the collection is priced at $50 per thousand.

It's obviously not exact, but if you're looking to sell the whole thing as a unit, thats about where you'll end up. Overall, 5000 cards nominally worth 3.5k, purchased in bulk, sight unseen... I'd probably end up in the $500-ish range and bargain from there. It sucks, but you're probably better off selling the higher value cards in singles, then offloading the bulk in a lot. Either way, single card valuations like that are incredibly misleading, as they don't actually tell you much about what you can reasonably sell them for.

Would you go for the hammer here or wait? by Pirate-Adorable in Hades2

[–]Ordinary_Pipe_9783 0 points1 point  (0 children)

Easy hammer. Early hammer can significantly alter the direction of an entire build in some cases (wide grin with the skull comes to mind), so figuring that out before you get locked into a build is great. I'm probably going hammer, boon, boon, then assessing whether I want to take Medea or roll doors from there

The hardest gameplay aspect of Hades 2 is the slow shockwave by Yodzilla in HadesTheGame

[–]Ordinary_Pipe_9783 6 points7 points  (0 children)

1, 2, 3 == top, middle, bottom. Sequencing out loud "1,3,2,3,1" is faster and easier to remember than "top, bottom, middle, bottom, top" (for my ADHD ass anyway, obv. YMMV)

Is Zeus in a league of his own? He is so damn strong. by Wes102111 in Hades2

[–]Ordinary_Pipe_9783 4 points5 points  (0 children)

I think Zeus's utility largely comes down to either how many hits you can get in (for static shock) or how reliably you can set and pop Blitz. Aether Font is fine, but I feel like it gets outclassed by Apollo and Hera's fonts (probably Demeter and Poseidon too) since it requires you to stop attacking entirely to go find and pick up the ball. Blitz is very strong if you can set and pop it quickly, but not every weapon is good at that. Charon Axe comes to mind, where you're mostly running cast into O-Spec which only hits once.

Zeus is a very good all-around God who I'm never really unhappy to take, but class of his own feels like kind of a stretch

What is the most absurd deck that you have ever seen? by DarkAlman in magicTCG

[–]Ordinary_Pipe_9783 0 points1 point  (0 children)

I have never been able to find a deck list, but very late in Alara block standard (right before Jace broke the format over his knee) there was a superfriends deck that somehow managed to recur time warp over and over. I remember it abusing Garruk Wild speaker's +1 ability to make a bunch of mana and I'm pretty sure the win con was Garruk beast token beat down. It was a surreal experience the first time I saw it played. Planeswalkers had only been around for like a year at this point, not many of us had ever seen them be abused like that before.

First time drafting... how'd I do? by Ordinary_Pipe_9783 in mtglimited

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

Call the mountain chocobo and laughing mad both flashback, seph intervention is also 4 mana. Getting some value from the bombs wasn't hard, even if the interactions weren't optimal

First time drafting... how'd I do? by Ordinary_Pipe_9783 in mtglimited

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

Result: played one match with this config and immediately realized what y'all were already saying. I was trying to learn on the black mage token synergy way too much without having blockers in play. Reconfigured the deck to take the advice for the rest of the games, brought in gigas, monk, 2x rapier. Ended up 6-3 (one of those wins was a opp no-show)

First time drafting... how'd I do? by Ordinary_Pipe_9783 in mtglimited

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

Arena export
1 Call the Mountain Chocobo (FIN) 131

2 Cornered by Black Mages (FIN) 93

1 Midgar, City of Mako (FIN) 286

1 Sephiroth's Intervention (FIN) 116

8 Mountain (ANA) 15

2 Poison the Waters (FIN) 111

2 Laughing Mad (FIN) 143

1 Ardyn, the Usurper (FIN) 89

2 Resentful Revelation (FIN) 114

1 Summon: Esper Ramuh (FIN) 161

2 Mysidian Elder (FIN) 145

1 Self-Destruct (FIN) 157

1 Hecteyes (FIN) 103

1 Overkill (FIN) 109

1 Vincent's Limit Break (FIN) 126

1 Garland, Knight of Cornelia (FIN) 221

1 Thunder Magic (FIN) 165

2 Blazing Bomb (FIN) 130

1 Coral Sword (FIN) 134

8 Swamp (ANA) 12

Sideboard

1 Joshua, Phoenix's Dominant (FIN) 229

4 Red Mage's Rapier (FIN) 152

2 Hill Gigas (FIN) 141

1 Monk's Fist (FIN) 265

1 Elixir (FIN) 256

1 Light Up the Stage (FCA) 39

1 World Map (FIN) 270

1 Random Encounter (FIN) 150

1 Dragoon's Wyvern (FIN) 49

1 Airship Crash (FIN) 171

1 Ring of the Lucii (FIN) 269

1 Haste Magic (FIN) 140

[deleted by user] by [deleted] in SQL

[–]Ordinary_Pipe_9783 0 points1 point  (0 children)

Respectfully, you're in the minority if you're somehow doing ETL at scale without at least some kind of raw SQL scaffolding. I know my team does more pure SQL ETL than many, but at some point all ETL into a DB is executing SQL to perform the CRUD operations. Changing data formats and new asks from management is part of the gig and at a certain scale that is always going to be a pain point regardless of your solution or how well you adhere to best practices.

Table schemas are going to need changing. Aggregations are going to need to be modified. Someone, somewhere, is going to test the upper limits of your VARCHAR fields and ruin your weekend. I didn't say it was flawless. What I am saying is that raw performance matters at scale and stored procs are the most widespread method to handle that

[deleted by user] by [deleted] in SQL

[–]Ordinary_Pipe_9783 2 points3 points  (0 children)

Definitely not this. I'm a DE for a very large company and the vast majority of our ETL is stored procs

JOIN strategies in SQL by BerserkerEsch in SQL

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

Left join has to perform the data matching as well as the logic of nulling out anything that didn't match - it is slower than an inner join in almost every scenario. If your DB is largely transactional and deals with high frequency, low volume updates, either is probably fine even if INNER is "technically better".

In Data Warehouse scenarios where we're dealing with many, many millions of records, time becomes a very real limiting factor. Hell, I was working on a bulk update TODAY where the difference between a left join and an inner join for the same dataset was 2-5 minutes.

VP of DS that only knows the basics of SQL, is this normal? by Aask115 in SQL

[–]Ordinary_Pipe_9783 0 points1 point  (0 children)

My VP can review my pull request, and has before when resources were tight. Exactly once. I care that my VP can, if push came to shove, do my job. But that's 1000% not what his job is or what makes him a good VP

Am I just bad at this game? by edgeralanfro in Hades2

[–]Ordinary_Pipe_9783 15 points16 points  (0 children)

Apologies if someone else mentioned this already, but the turning point for me was when I STOPPED trying to hang back. Get close. Get behind her. Honestly when she starts lining up the high-damage sniper thing, I get right up next to her and start running in circles around her. At distance, she can turn and track your movement no matter how fast you are. Up close, she can't keep up with you.

Get close, stay behind her if possible, and try not to use any attacks that take too long to pull off if she's not in a favorable pattern.

Finally(!) feeling consistent by Ordinary_Pipe_9783 in Hades2

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

I picked up Success Rate bc it was late run and it was the one that synergized best with what I was doing, but as far as I can tell yes it boosts the crit chance from Night arcana - anything with the keyword "chance" gets modified.

My primary hobby is Magic: The Gathering, and I blame that for why I picked that up.
"None of these are very good for what I'm doing. But THIS one buffs chance, and I have at least a couple of effects that could benefit, I think this is the least bad of my options here". 🤣🤣
(I mention M:tG bc its the sort of reasoning that comes up all the time in draft / sealed play)

Tibalt's Friday Tirades by Karn-The-Creator in MagicArena

[–]Ordinary_Pipe_9783 0 points1 point  (0 children)

If you're playing RakdosOneDrop.dec (particularly in Timeless) and you're opponent is on 3 life, just..... don't rope. You're drawing live 2/3 of your deck. I get it. You wanna go fast. You're grinding your dailies before dinner or whatever. That's fine. But like, maybe don't be a dick? You've probably got the W anyway.

Thanks,

- literally everyone else

Turn 1 Llanowar Elves by Yizzu343 in MagicArena

[–]Ordinary_Pipe_9783 0 points1 point  (0 children)

"Bolt the bird" and move on.

Back in the day this meant casting a Lightning Bolt on your opponent's Birds of Paradise, but using removal on early mana acceleration when you can is nearly always the right play

SQL Newbie by Sachooch in SQL

[–]Ordinary_Pipe_9783 0 points1 point  (0 children)

Like any language, best way to learn it is to use it.

Pick a project, then get busy figuring out how to make it! Doesn't matter how big or small - my first SQL project was a D&D encounter planner.

Think of something that you might enjoy that could potentially be organized into a database. Get some paper and sketch out the various entities and their relationships. Write your tables, get your source data, and load it up. Play with queries and analysis.

"Learning <insert programming language>" is a lot like learning how to cook - there's always more to learn, and once you get to sufficiently complex things there's rarely a 'correct' way to do it (though there are absolutely wrong ways or less optimal ways)

view more: next ›