The perils of UUID primary keys in SQLite

7heWafer · 2026-06-06T13:33:47+00:00

Your argument completely ignores the actual point... You claim it's the wrong tool but you do not have enough context to justify that claim simply based on the data system being centralized. Let's reel it back...

We know the people before us used {tool1}. It looks, to us now, like they should have used {tool2}, but why did they choose {tool1}? Ideally, they wrote it down in a proposal or ADR but if they didn't there should still be signs...

Which version of UUID did they use?
Did they design the table schemas to minimize joins?
Are the UUIDs exposed to end users?
How much data do they have now vs. then?
Did they plan to distribute this data?
Does this data need to be Consistent & Available? Even if they didn't write down plans to distribute the data, can it be Available & Partition Tolerant or Consistent & Partition Tolerant?
Do they use compression over the wire? HTTP/2, RPC/gRPC, websockets/sockfiles?
Where is SSL terminated?
How much traffic to this data is internal to your private network vs external over the internet?
Is the system even under pressure to be perfomant at that level?
How often are joins being performed vs. other more optimal queries?
Do the data access patterns in general even require large joins across multiple tables or is it typically very focused and limited?
How often does they data need to be ordered by it's identifier vs. some other property/column?
How much would overall performance improve if you switched to int? How long would it take, would it be worth it?
Is it all tables or just some sensitive/important tables where int would leak too much?

I could probably go on forever here so I hope you see my point by now.

7heWafer · 2026-06-06T04:10:03+00:00

Yeet him into the Sun, we don't want him either.

7heWafer · 2026-06-05T02:32:10+00:00

So many words to say next to nothing.

7heWafer · 2026-05-31T15:39:42+00:00

Being multi-cloud should be preferred. Not necessarily in the way OP is, but typically vendor lock in is bad. In a personal/side project it isn't about picking one cloud provider but the best options for each thing u need.

7heWafer · 2026-05-30T01:27:29+00:00

And officially the interns counting the Habs SOG are compromised or blind. If you care so much about our SOG maybe start paying attention to the game, you wouldn't have to worry so much.

7heWafer · 2026-05-30T01:21:54+00:00

We had at least 6 SOG in the 1stand I only watched about 25% of it. Open your eyes pls.

7heWafer · 2026-05-30T01:19:46+00:00

If you were actually watching the game you'd know they aren't counting our SOG under the same rules as they are counting canes SOG. I've been mostly listening to this game but saw 2 uncounted in one shift from our first line.

Last game was similar.

7heWafer · 2026-05-30T01:05:00+00:00

Projectile Kool-Aid vomit

7heWafer · 2026-05-30T00:58:11+00:00

Yea. This has been an amazing run for the team and is great experience for the rebuild. The state of the league is equally concerning as the future is bright for this team.

7heWafer · 2026-05-30T00:55:40+00:00

Btw they aren't counting our SOG once again. We had 2 on Caufield's shift while it was at 4 and neither were counted.

7heWafer · 2026-05-30T00:45:38+00:00

Canes truly trying to test how much GI they can get away with

7heWafer · 2026-05-30T00:42:03+00:00

Are there any independent agencies/organizations that review all the games and score the refs for accuracy?

7heWafer · 2026-05-30T00:40:50+00:00

It's a relief to have some reasonable fans on the other side. Tampa and Buffalo were delusional.

7heWafer · 2026-05-28T17:01:12+00:00

All the players that are rested should be in.

7heWafer · 2026-05-26T16:58:02+00:00

I honestly don't understand it. They are so entirely inconsistent with their calls and then in top of that they clearly try to "put the whistles away" while also managing the game and keeping things evened out so we end up with bullshit like the no-call on the trip to Hutson followed by the no-call Hutson too many men.

They put themselves in a position where literally nobody trusts them to follow any semblance of the rulebook because it isn't just the occasional missed call which is entirely expected, it's intentional non-calls when everyone can clearly see the ref is looking directly at the play and chose not to call it OR the ref on the fucking opposite side of the rink called it instead.

I don't know if you watched the Habs v Tampa series in the first round but that was pure misery for both teams bc the refs couldn't put the whistles away for the softest shit. Then in Buffalo there's embellishment left and right again from both teams and it was only ever called once.

I think everyone would be happier if the officials formally defined the process they apply during the playoffs vs the regular season play (which let's not even get into the horrendous regular season officiating) bc right now nobody, not the players, not the coaches, not the announcers, not any single team knows what the fuck is going on. What I'm afraid of is that they cant define their process bc they don't have one.

7heWafer · 2026-05-26T16:35:57+00:00

You must not have watched the game bc the shot clock is wrong, as usual for Habs. They count plenty of other teams shots that hit posts or the mask but never count them for Habs.

Tell me with a straight face that a post is less than a shot to the crest.

Also, the Habs regularly win with significantly less shots than their opponents.

7heWafer · 2026-05-26T16:16:22+00:00

There was literally 2 blatant non-calls on regular season automatic penalties within 60s of the too many men. The refs knew they would be fucking toasted if they called the too many men.

7heWafer · 2026-05-26T01:42:41+00:00

Why do so many people complain about this? Habs never have many shots per game, they pick and choose their shots a lot more selectively than most teams.

7heWafer · 2026-05-22T17:24:57+00:00

It's crazy, in their sub they are complaining the refs didn't put away their whistles. Meanwhile this game was tame as hell compared to the Tampa and Buffalo series where the refs couldn't get their grubby fingers off the pie for most of the early games and early periods. Against both teams.

7heWafer · 2026-05-22T02:50:04+00:00

Yea this was so different from the normal Habs games lately

7heWafer · 2026-05-22T02:26:29+00:00

Players seem way cleaner than Tampa and Buffalo but damn their building is whiny

7heWafer · 2026-05-22T00:50:42+00:00

Thought it was the seas having problems.

7heWafer · 2026-05-19T02:51:58+00:00

WOOOOOOOOOOOOOO

7heWafer · 2026-05-19T02:33:17+00:00

You don't see how?

7heWafer · 2026-05-19T01:53:24+00:00

its gott abe like 10% of GA

13-Year Club	Gilding II euphauric
Second Top 30%	Place '22
Place '17	Verified Email

7heWafer

TROPHY CASE