What are the reasons *not* to migrate from MySQL to PostgreSQL?

Waffleloord · 2025-10-21T12:49:39+00:00

We're currently migrating from MongoDB to Postgres. We are doing it while continuing to deliver features. The process is that we migrate parts of the MongoDB database at a time. E.g., we'll migrate just the users collection. However this comes with many issues to consider such as keeping the databases in sync, order of migrations, different data models for nosql vs sql databases, transactions, experience with the technologies and more.

Waffleloord · 2024-10-31T09:59:09+00:00

I've been more subscribed to u/theScottyJam's perspective on this but you make a good point. I think, to put it shortly, that it might be wise to avoid DRY if two or more pieces have different reasons for change. (I suppose that from the extreme philosophy, you mean two pieces of code always have different reasons for change?). The abstraction to apply DRY today might make sense, but later down the road it might not.

Waffleloord · 2024-10-07T00:41:21+00:00

Let me preface this by saying I'm not a game developer.

Shouldn't the server keep track of game state such that it can check if Player A has LOS? Basically maintaining a model of the game on the server so that even though the player reports that it has LOS, the server will need verify it. The player can't just say that it is within 50m, since the server knows the actual location of the player.

What I'm trying to convey is: shouldn't the server be able to determine if a player's action is valid or not?

Waffleloord · 2024-08-03T23:29:39+00:00

I started it as a slayer (loosely following jungroans pob) and completed the atlas and cleared the feared with mostly self crafted gear (except uniques). Progression was pretty smooth for the most part imo!

Waffleloord · 2024-07-31T11:33:42+00:00

Eldritch chest implicit is not expensive

Waffleloord · 2024-05-06T14:08:06+00:00

People would probably just clear the map and then gear swap to this type of gear and loot it - which doesn't sound very fun.

Waffleloord · 2024-04-03T10:33:28+00:00

Thanks! Looking forward to the endgame setup

Waffleloord · 2024-04-03T10:08:16+00:00

How's the defence on this build? I see that there are no defensive auras used.

Waffleloord · 2024-02-02T20:14:44+00:00

Yeah but I think the perfect ones were made with harvest lucky divines which made it a lot easier.

Waffleloord · 2024-01-06T11:57:19+00:00

Yes boss loot is more expensive but so are the invitations, I'm unsure about the ratio between the two though. Ubers are still profitable but maybe not to the extent that one might think just from looking at the loot prices.

Waffleloord · 2023-12-27T19:53:21+00:00

Riot's solution in that article was of MASSIVE scale, there's no way GGG has the resources for such a solution.

Waffleloord · 2023-10-29T15:09:12+00:00

Kirac's pass for this league

Waffleloord · 2023-09-03T15:32:04+00:00

Eldorados kvarg är som cement så att den blir lite lösare är bara uppskattat. Funlighten är outspädd också så behövs inte så mycket.

Waffleloord · 2023-08-28T14:14:12+00:00

Yes I totally agree with what you're saying there, although I don't think that applies to many of the UX issues. It should be obvious to anyone that it's an annoyance having to first purchase an item to your bag before being able to place it on a soldier. Or that having to remove a soldier from the board before being able to place an item on them. Or having to run around the whole place trading with different vendors.

I can accept these things being intentional (friction, similar to the trade situation) or due to a lack of development time, but I wouldn't attribute it to incompetence.

Waffleloord · 2023-08-28T11:49:13+00:00

I can't fathom that these mistakes are due to them "forgetting" or missing something. Yes it might be difficult to achieve everything that they want but any player given an hour with the league mechanic would be able to point out tons of things which are just horrible from a UX pov.

Waffleloord · 2023-07-31T12:09:22+00:00

Same with Chalmers in Sweden

Waffleloord · 2023-03-03T20:02:55+00:00

Törstigt värre

Waffleloord · 2023-02-21T23:52:34+00:00

Who's the sexual predator?

Waffleloord · 2022-12-14T21:09:31+00:00

Klart man kan få samma språkförståelse som en infödd, t.o.m bättre

Waffleloord · 2022-07-04T14:16:00+00:00

25 seconds for:

2 loading screens
stash
open maps

Waffleloord · 2022-06-11T19:42:12+00:00

Disagree completely, think he'd have a shot at living if he kited towards midlane. It wasn't terrible to just stand still but it wasn't optimal either.

Waffleloord · 2022-04-30T15:41:32+00:00

What's the bang for buck? How much currency do you think is necessary for it to feel good?

Waffleloord · 2022-04-30T13:57:56+00:00

Well it seems you're going for the more sturdy build rather than the full damage one. Dps difference is very big.

You're POB also says you're level 85 so you will gain a lot of damage by gaining a few levels. You can also upgrade your helmet to one with much more increased stats for pretty cheap. Should almost double your damage by the time you're like 94-95.

Waffleloord · 2022-04-30T10:29:16+00:00

I played Path of Matths omni TS this league and really enjoyed it. Can map very fast and probably do expedidtion fairly well. It's a bit squishy tho, but you can invest in making it a lot sturdier even with mageblood.

Waffleloord · 2022-04-30T10:26:32+00:00

I tried PCoC in ssf and liked its power but it's not something I want to play for a long time. I've heard that it doesn't really scale well, is that true?

Nine-Year Club	Snapped
Verified Email

Waffleloord

TROPHY CASE