Hacker Newsnew | past | comments | ask | show | jobs | submit | brootstrap's commentslogin

have worked on 20TB+ tables before. proper schema / index / query, shit is still fast as hell when you do it right


Yep, was just sharing this experience in the comments as well. By far the most painful part is schema migrations, and that's well-solved with pt-osc or gh-osc.


With MySQL 8.0+, you might not even need pt-osc. A lot of schema changes can be performed online now.

https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-op...


And still my coworkers who 20 years ago were burned by some MySQL minor issue will laugh at the mere suggestion that we could probably use MySQL.

People still think it's a toy to this day and they've struggled to shake that perception.


same. we've got 3 to 4 hundred million rows in one table and our queries still complete in the 100ms range!


Any partitioning?


Wind shear is easy. feel the wind on your face, then jump as high as possible and feel the wind up there.


this is an advanced technique that they don't usually teach until the commercial certificate.


Oh, so that’s what turbulence is.


Wind shear is one of many various causes of turbulence in aviation. Certainly a common one, however.


The game owns and article makes a great point. These games around about high resolution graphics and densely packed pixels. It's about the atmosphere, story, setting, your personal struggle against seemingly impossible odds.

The fact people care about graphic quality is pretty funny to me. Go play the latest FPS online loot shooter if you want "triple A" graphics.

The game is a masterpiece in it's own right. Its like taking a dark souls game and making it bigger and bigger. Then just when you thought you were nearing the end. Oops sorry you are only 30% done with the game!

I'm at 100 hours on PC , getting close to finishing. Some graphic stutters near release but since then i've had no issues at all. Medium level rig.


I wish elden ring was smaller. I thought the open world concept was very poorly executed. I didn’t know where to go at first so I explored pretty much the entire open world unable to do much other than run past everything. The remainder of the game was just teleporting around so the open world was irrelevant. The bosses were good. The legacy dungeons were good. But the open world was largely a one time early game tax to find flak upgrades. I felt frustrated that I was not clearly shown where level appropriate content was. I don’t mind the option of seeking inappropriate content, but it should have been more transparent.

I spent the game picking up herbs. Never used any.

I picked up loads of weapons, but couldn’t use any them effectively without respeccing or farming weapon upgrades.

I found very few of the mini dungeons organically and had to look up where to find them but they tended to be pretty dull and reuse the same bosses. The quests were equally inscrutable without a guide. Finding bosses that are just way too strong for you sucks.

Leyndell and onward aren’t really open world. They’re mostly just linear areas, which I liked more but I also suspected was mostly due to budget and scope cuts. I would have gladly traded the vast open world and mini dungeons for a few more well designed legacy dungeons and bosses.

I played with no summons and beat malenia with two whips and no skills for reference if it matters


I completely agree about the open world. The complete lack of breadcrumbs or anything to help you understand where to go made it a much worse experience for me, especially as my first souls game. The game even tells you to follow the Guidance of Grace, which leads you directly to Stormveil Castle, which you will be underleveled for.

I tried playing blind and ended up in Caelid (~lvl 60 area) instead of Weeping Peninsula. That's when I noped out and spent the rest of the game with my head buried in the wiki. I couldn't imagine trying to play these games without a wiki.

Everything else I enjoyed for the most part. The controls and hitboxes are a little janky, the platforming sections are total garbage (shoehorned into an old engine that never had it), but the open world execution was by far the worst aspect for me. At some point FromSoftware has to start catering to players new to the genre instead of forcing people to struggle and calling it part of the experience. With 12 mil in early sales I guarantee a bunch of players struggled with these aspects of the early game and dropped it altogether.


I think the cryptic nature of Soulsborne games don't work in Open World. Like some of the side quests are near-impossible to complete without a wiki (unless you get very lucky). For instance, some NPCs are like, "I'll see you around." And you have to find them at some random place in the world if you want to continue their quest.

In a more closed world like Dark Souls, I think the no-handholding of side quest can work. But in an open world, I would've liked a bit more hand holding.


The first guy you meet outside the cave tells you to follow the guidance of grace. The graces around the main storyline literally point to the next grace or way to go. If you follow the road you'll get there.

I did get lost in the beginning because this is my first souls game and the only other game I've really played in the last 10 years is botw. But I've always have a good sense of where to go. The times I don't I explore and find something that leads me down a side quest. There's definitely lots of breadcrumbs imo. I mean if you're lost just look at the map and go towards a castle.

I think what could be better is to be able to revisit people and talk to them about quest lines. Or have a log. Other than that I'm having the complete opposite experience of you and I'm sure I've died 500+ times in my 50 hrs.


> The first guy you meet outside the cave tells you to follow the guidance of grace. The graces around the main storyline literally point to the next grace or way to go. If you follow the road you'll get there.

That's kind of my point though, because, at the beginning of the game, going straight to Stormveil Castle is not the optimal path. The optimal path is to go through East Limgrave and then Weeping Peninsula to get some levels and some gear. Guidance of Grace leads you away from that. Pretty unintuitive for the very first waypoints of the game.


I agree with some of the critique here, but the lesson I took from the experience of following those first graces was "oh, I guess I'm going to need to be stronger to fight this guy, guess I'll go wander around and level up" - which I think is _exactly_ the lesson that the designers intended.


That's exactly what I did and I've been having a ton of fun. "Okay, I'm not ready for this person yet, but there's all these other things around me, let's go explore that and I should be leveled up and just better at the game/controls by the time I come back." This means absolutely no grinding. The game also taught me to not fight everyone and to focus on skills rather than runes. The game is unfair, so you have to be unfair back.


This is what I did too. And my point is that it took me throughout the entirety of Caelid and liurnia which was stupid as shit. Because the rate of progression was extremely slow, especially when you’re just running past things, and the only area that’s particularly appropriate up front is castle Morne which is not advertised.

I don’t think the game is unfair. It’s boss design is great. It’s the pacing that’s shit. Margit was an awesome fight.


> I don’t think the game is unfair

I disagree. It is very intentionally unfair. Two against one bosses where one has long range attacks and one is melee? One shot kills? Losing all your level progress when you die and being unable to retrieve them? This breaks a lot of the common game formulas. It forces you to just "get good" and think about your gameplay differently. But that's exactly what I like about the game. When you're getting you ass handed to you you often can't just come back at a higher level, but need to actually take new strategies. You can for the main questline but outside that you need to "get good"


There’s no one shot kills. If you get one shot it generally just means you don’t have enough vigor.

I’m not clear what you mean by outside the main quest line. The main quest line is the only noteworthy content. Everything can be done at a later level and probably will unless you’re using a guide to find everything in order. Malenia and mohg are outside the main quest line, technically I guess.


I’m 65 hours into this and only have a vague idea what the main quest line is. I see something on the map and run to it. It’s fun to explore and there is so much. I’ve met a lot of random people that want me to do stuff. My only want in the game is a log of who I’ve talked to and what they said.


It’s very easy to find random npcs. It’s incredibly difficult to find them again once they move. Some of them have natural points where you’re likely to encounter them progressing through the game normally, but only if you’ve already encountered all of their previous meeting points by that time.


I guess I don't take the attitude I need to find them again. If I do, great, if not, I still go over the next hill to see what's there. I find the open world exploration quite fun.


I unironically paid zero attention to Varre and accidentally tromped through and completed Weeping Peninsula without any instruction whatsoever. It just felt right. Very intuitive.


I found a lot of sidequest breadcrumbs. Then that was it and I never found the next breadcrumb again because they teleported to an unmarked location I had been to before and had no reason to go to; standing still and saying nothing.


Sounds like you would love the Dark Souls games. They're Elden Ring without open world, and all legacy dungeons.


I liked the first one. Sekiro was their best imo.

But elden ring’s design philosophy seemed to start with “what if we did dark souls but all doors and passages were open from the start?”

The answer is unsurprisingly that many players track awkward paths of hitting things too soon and too late.

If you’re going to have such significant character progression, linear games just make more sense. Breath of the wild gets away from it because link barely gets any stronger over the course of the game. Just a bit tankier.

Fighting bosses in elden ring and finding they’re drastically undertuned really ruins the point of playing a soulslike…


Having played some of the soulsborne games before I much prefer being able to go away and explore something else if I hit a hard boss or area. It keeps the game much more enjoyable and not feel as "grindy". You do have a point about hitting some things earlier or later than you should, but usually under-leveled players are not going to make much progress in the tougher areas anyway...


A larger problem is that the whole level system to all of these games is just kind of bad. It would be more fun if you just were appropriately leveled for each encounter and that was that. And each weapon were useable without needing to dedicate resources to it.

I prefer feeling confident that I’m at a good state to fight something and if I’m losing it’s just a skill issue to practice.

Farming in all souls games doesn’t actually net you that much, but it still feels like the easiest path forward at times. Elden ring is particularly weird with its scaling. Vigor gives much larger buffs to hp than people expect. Damage stats do much less.


A key feature of the leveling system is that it allows somewhat for player controlled difficulty levels.

There is a wide range of skill levels of players, and what is "appropriately leveled" for one player might be trivial or impossibly hard for others.

Players level to the point where they can beat the bosses that they get stuck on.


In theory maybe. In practice not really. Leveling up does not make a huge difference. Leveling up weapons does. Leveling up flasks does too. The amount of time you need to spend to level up is a terrible trade off.

If you’re not good at the game, you can trivialize most encounters with the summons, or use multiplayer which adds a ton of luck to the outcome.

Actually farming runes is almost a trap for anything last stormveil.


I think leveling systems are arguably the biggest mistake in gaming right now. By that, I specifically mean things that just power you up or down based on a single number (give or take a few numbers), which you can go up basically by just playing the game for longer. It gives the entire game a natural skew towards becoming easier over time, which, being backwards, then requires a large number of gyrations to overcome.

I don't think the solution is just to rip them out and then proceed forward. And there are still other bad designs, of course; a sibling comment cites Oblivion. (Although I would call that an example of one of the "gyrations" I refer to; having a leveling system but then trying to remove it by somehow mathematically cancelling it is just weird. Quite distinct from not starting with one in the first place.)

I would cite something like Bayonetta as a good example of what I mean, though by no means the only possibility. Especially as "RPGs" continue to move more and more in the direction of straight-up-action-game combat anyhow. You open up some weapons. You can double your health and the other resource (forget what it's called), and I'm not even sure I love that, but you can. But fights are not about whether you're level 34 and they're level 63. Difficult fights are difficult because they are difficult.

In some sense the biggest mistake in my mind is that it gives designers such an easy answer; just slap a leveling system on it. More thought would be nice.

I could also cite something like Slay the Spire. No "levels" in sight, but your character certainly becomes more powerful over time, and your play gets better. Skill acquisition, clever combinations of abilities and features, etc. So much better than just a number that goes up.


Borderlands 3 does this thing where enemies are scaled to your local client level. So like if I’m level 30 playing with a level 20 friend and he finds a level 22 enemy, for me it’ll be level 32.

Which certainly seems another step removed from logic.


As much as I have enjoyed Borderlands (2), it is one of the things that really triggered this thought it me. For whatever reason I encountered a high-level enemy about 5 levels above me in one of the DLCs, and I managed to trap it on the level geometry and kill it with about 80% of my ammo. And I realized just how silly this was.

The primary purpose of the leveling system in Borderlands, at least to my eyes, is to make it so you can't just pick up a gun on level one and use it the whole game, defeating the purpose of the main game loop to be forcing you to be constantly changing guns. OK, I get that purpose and in context it makes sense. But the leveling system is a really weird way to do it. I'd almost rather see guns decay instead. (Not do the whole "100% functional until they instantly and totally break"; we've got enough experiences with that to know how frustrating it is.) Decay is somewhat plausible though then you have to have the strength of will to reject repair mechanisms, which is still physically weird.

But I'm not really trying to propose all the solutions to all possible alternatives to leveling systems; I'm just saying "hey let's make the player and all the enemies 11% stronger every 30 minutes, except across a large set of dimensions impossible to ever keep scaled properly relative to each other in an exponential regime" is a silly thing.


>> It would be more fun if you just were appropriately leveled for each encounter

Elder Scrolls: Oblivion. That leveling system meant you never ran into anything beyond your level. But it also mean that in the late game you were constantly hounded by insanely powerful creatures randomly out on the road.


Worse yet, if your character build scaled poorly, end-game became a horrible slog. If it scaled well, end-game became a walk in the park.

Unfortunately, mods that de-leveled the open world were not very good. You had no idea if you were walking into an area you outleveled, or were outleveled by, and many early quests took you to incredibly high-level areas.


You're looking for a completely different experience than soulsborne games seek to provide my guy. The effort makes the experience meaningful. It's just like WoW was meaningfully better before the abundance of fast travel options later added to the game, or the nerfs to leveling and item acquisition. It's not everyone's cup of tea but it's a strong, flavorful and relatively unadulterated cup of tea and we stan that.

I don't even like soulsborne games that much but I recognize the beauty and purity of the experience they provide. I'd rather be playing quake 3, but it's the same thing in a certain conceptual way.


The defining feature of souls likes is undoubtedly their fluid combat. Not the shitty numbers behind them. You could. Have just as good of an experience getting x level ups after beating a boss and that’s it.

Farming souls is stupid.


One thing that changed my view is to just stop caring about runes. Unless it's a significant amount, close to a level up, they aren't important. The other thing is to use your items. It's easy to hoard in a game like this but you shouldn't.


Yes. They don’t matter. In part because the game is very stingy with them. In another part because of you actually need a level up you’re going to get what you need much faster going to a nice farming spot and starting from scratch. In third part because they’re nothing compared to the value of weapon upgrades and flask upgrades.

The game is also just unintuitive when it comes to defensive stats. Putting lots of points into endurance to wear the biggest armor is nothing compared to boosting vigor. Armor mostly sucks tbh.


Honestly I haven't farmed in the game ever. I'm not sure why I would need to. I do agree that some things are not as intuitive though, like armor. Or that poise is what's important, because it is about knockback.


You will have to farm a bit in late game if you want to try out different equipment. Because due to yet another stupid leveling system, any gear that isn’t upgraded is worse than the shittiest club with upgrades. So if you want to try anything else in the end game you need to go farm runes to buy stones to upgrade your weapons. Not terribly slow, but annoying and it could have been avoided entirely.


I was able to max level maybe a dozen weapons for funsies without any grinding involved. Later in the game, Hero's Runes and similar are laying around like candy.


I just try them out at later points. You can even respec.


> I felt frustrated that I was not clearly shown where level appropriate content was.

The map indicates the main path with glowy little directional markers all along it. Usually areas around the appropriate section of the main path are level appropriate, but there is much more to explore.


Yeah I’m gonna hard disagree there. The lines, and even the first NPC you meet, immediately lead you to storm veil castle which is a total trap. Margit is a very strong first boss, with unblockable chip damage and some fairly long and difficult to dodge combos. Heck he’s probably one of the hardest fights mechanically. The slow swings of the final boss are so much easier to avoid. If you follow the lines you will not get any flask upgrades either. And if you don’t go that way initially you could easily find yourself discovering another “main path” instead first.

Imo it was really just the one time tax of getting your flasks and weapon upgrades. The initial scaling of things was just… really bad. Weapon upgrades are too good for something that’s so uncontrolled game progression wise. Flasks get way too powerful very quickly, filling up more than your entire health bar with just one of many many charges. Health starts too low but then scales up stupidly fast.


I'm at 150 hours on PS4, and probably not anywhere near finishing. The only problem I've had is that sometimes the game freezes when I'm being summoned for co-op, and I end up having the reset the console.

That, and my cat hates sitting in my lap when I play Elden Ring. He can't get comfortable because I'm always on edge, expecting an ambush. He'd rather I played Final Fantasy XIV.


> That, and my cat hates sitting in my lap when I play Elden Ring.

Yeah, well, my 30kg golden retriever doesn't care what I'm playing, because when she gets on my lap -- and she does so frequently -- I can't do anything else ...


These posts make me feel like an oldster. I got Elden Ring, but learned that you had to use a controller. Using a controller to play a 1st or 3rd person game feels so wrong to my M+K sensibilities. Maybe I just don't grok it, but using swivel sticks while simultaneously pressing buttons seems so clumsy and weird. I guess I could suffer through the learning curve, but instead, I'll just write off the games that are really designed for console.


Seems a shame to get hung up on that one thing (I don't know anything about ER's KB/M support), but I understand. Being comfortable with your input method is pretty important. ER definitely stretches gamepad input to the limits. It's pretty often I do the infamous "claw grip"[1] to get access to both the right stick (camera control) and face buttons (actions). If you can get over the controller thing, or find the KB/M controls sufficient, I really recommend it. ER is definitely one of "those" generation-defining games that are really special.

[1] https://i.ytimg.com/vi/-oLlVzXeXOU/maxresdefault.jpg


Ugh, that hurts my wrists & hands just looking at it. Have you tried one of the Xbox Elite controllers? I've been using them for a number of years now and they're great. They do take a while to get used to, but they basically give you buttons you can use your middle & ring fingers on. They're remappable, but I've got mine setup for A, B, X & Y buttons, so my thumbs never have to leave the joysticks. I know the controllers aren't cheap, but they're worth it, in my opinion.


Every time I think about buying an Elite controller and its $180 price tag, I look at the perfectly good controller I've already got and say nahhhhh.


I claw grip when I am forced to both hold the right-most button and don't have the luxury of letting go of the camera stick, no matter the game. More pronounced in this series in particular because of the punishment of death.


I've been playing Elden Ring on M+KB, why do you think you have to use a controller? M+KB support was kinda garbage in the PC port of the original Dark Souls but even then it was still there.


I bought the first DS and never played it because it flat out required a controller. I bought a controller to use with ES because the game got so much hype. From what I have read, you can use M+KB with ES, but it is sub-optimal in a game that requires hyper optimal play.


I definitely played Dark Souls 1 on PC ("Prepare to Die Edition") from start to finish and did not at that time own a controller. I have my AutoHotKey script around for it somewhere. It did not "flat out require" a controller.

I haven't bought Elden Ring yet (it has been a very busy year), but I was alarmed by your claim that you "have to" use a controller, but now that I learn you're just wrong about DS1, I can calm down and carry on.

Also, "requires hyper optimal play"? Are you kidding? Just because kids who've never played a hard game think Souls games are hard doesn't mean it's true.


I was surprised how Much Elden Ring didn’t feel punishing to me. I was expecting it to be much more unpleasant to die. For the most part I can shrug off runes and usually you spawn pretty close.


M+KB is fine. The game does not require hyper optimal play by any means.


The style of gameplay just works much better with a controller. I would say the same thing about most melee oriented action games. Devil May Cry with a keyboard is horrible.


I couldn't disagree more. I've played tons of melee oriented action games with M+KB and the only time it gets annoying is when it is a bad console first port.


I'm fifty years old - surely a fellow oldster by now - and mouse+keyboard always feels incredibly awkward for any kind of fast action game. It's a matter of what you're used to; I've been doing most of my gaming on consoles since leaving my old Amiga for a Mac.

My husband used to be like you until they got into Nuclear Throne, now they're at home with a controller for games that work better that way. A twin-stick shooter is probably much better to learn a controller with than Elden Ring IMHO. Or a friendlier jumpy-adventurey-fighty game like Spyro or Sonic or Breath of the Wild that's built with the assumption they might be some kid's very first encounter with this style of game, and has appropriate amounts of training.

But really, there's only so much time in a life to play video games, and only so much time in a life for everything you enjoy doing. If don't wanna get used to a controller then, well, that's fine. You'd miss out on a ton of great games even if your day job was nothing but playing them.


I didn't have any trouble completing the game and killing all of the extra bosses with mouse and keyboard. I could see how some of the horse parkour might be easier with a controller, but never felt like I needed it for fighting. I find the ability to turn much more quickly to be a huge advantage of the mouse over the controller.


Thanks for that! I'll rebuy it and give it a try with M+KB.


One of my good co-workers is daughter of a dentist from the UK. the practices there are much different. We have had him analyze xrays and scans, he says its fine the people here just want/need your money!


Some people are just looking in the wrong places. Tim and Gregg have kept me in touch with quallity Cinema. 5 bagger for sure.


And in sausage rolls.


self driving tractors have been around for years already. The guy operating usually just chills there listening to the radio and occasionally engages to help with precise turns or whatnot.


Yes, but the new sensor pack to remove the rider is a huge upgrade. Like going from flipping toggle switches to Windows 95 kind of an upgrade. The previous commenter was amazed by the transition from Windows 3.1 to Windows 95.

But, again, it's boring because we watched the development of those sensors as it was happening. In the past the masses would have been unaware of the development going on. But nowadays we know what's coming and it seems old hat by the time it hits the market.


You are contradicting yourself. A self-driving tractor that requires an operator is not fully self-driving.


There are countless indie games out there too worth all your time and more. If you like elden ring you need to experience the whole soulsborne series. AAA games are as trash as they've ever been.


Elden Ring is published by Bandai Namco, which makes it an AAA game; Bandai Namco is larger than Ubisoft which is where most of the "AAA = bad" games are from.


Is Elden Ring not a AAA game?


i'm not worried about my DIS shares getting hacked as they chill in the digital world compounding interest. It appears that investing in crypto is not quite as safe? One of my bros got hacked in mt gox and since then i've been a bit weary of putting serious sums of money into it (i have maybe 1-5% of my portfolio in crypto and not planning on betting the house anytime soon).


It's certainly not as safe. And one hack doesn't constitute "proof" that the entire space is a total fail at beating traditional finance, which should be obvious. Instead we have people like OP making sensational claims about "shills", providing nothing of value to any conversation about the topic.


It's not one. It's like one per week.

And every smart contract is a self-funded hack bounty.

Smart contracts are a complete misunderstanding of what contracts are, and what the hard parts of the space of contracts are. They're simply changing the simple problem to be enormously complex, without making the hard problems any easier. In fact it makes the hard problems harder too.

causing great public interest and excitement.

> OP making sensational claims

Def 1. "causing great public interest and excitement"

Well, not really. This story is just "huh, another one". Brings to mind the meme "I'm shocked, shocked!, to see another one of the cryptocurrency LARPers topple over"

Def 2. "very good indeed; very impressive or attractive."

Thank you!


I've 100% noticed it in the past months. Have a new employee that i'm trying to train up a bit with python and googling has gotten more annoying. fucking codegrepper.com & shit. FUG EM . hilarious when you find the exact same snippet over and over. Even more hilarious those asswipes are probably making $$ (potentially lots) with all the stupid clicks n that.


Oh god yeah, I wish SO got better at blocking scrapers, I'm pretty sure services like CloudFlare have anti-scraping protection. They need killing off ASAP!


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: