hot_gril

43 ms·

631.
by hot_gril 2y ago
It's easier if you have a non-PK UUID column you can use as a crutch.
632.
by hot_gril 2y ago
PK should be bigserial no matter what. "Use an external ID that is random" has the same clustering problem mentioned above since you will need an index on it, so it's not always the right answer, but I would default to it.
633.
by hot_gril 2y ago
Maybe, but they don't need to be the PKs. And you only need some 128bit number at all if you want one generator not to be able to guess the others' numbers, like if clients are generating them.
634.
by hot_gril 2y ago
Even in these situations, you probably want bigserial PKs on the shards. I think Citus does this by starting each shard's sequence at a different value.
635.
by hot_gril 2y ago
I can understand not caring at first if this option is easier, but it's not. Bigserials are already the easiest thing to use.
636.
by hot_gril 2y ago
Postgres hash indexes were sorta unusable until a few years ago, and in my experience they weren't any faster back then. Haven't tried again recently, but if I did, I would run benchmarks before trusting it. Also, giving credit wh
637.
by hot_gril 2y ago
What's the problem with bigserial as a PK?
638.
by hot_gril 2y ago
If people are playing so carefully that they're constantly checking others' resources like this, it might actually be slower.
639.
by hot_gril 2y ago
I leave my resources visible even if we aren't required to. It sometimes makes people more willing to trade with me, and I can still hide them late-game when players are getting more adversarial. Might not be the best strategy, but wha
640.
by hot_gril 2y ago
The usability without extensions part is underrated. Whether I'm a beginner in school or a pro trying to hammer out a quick script, I would prefer the thing that doesn't make me jump through hoops to deal with CSV JSON XML etc. Fa
641.
by hot_gril 2y ago
Sure, but not more adoption than Python. All the examples look math-focused; would you write a web backend or a batch script in Julia?
642.
by hot_gril 2y ago
Well yeah the thing is extremely likely a scam.
643.
by hot_gril 2y ago
I think 2020 was the beta. They announced the full feature in 2023, and I see a 2022 article about enabling the beta. Primary device SoT makes sense, but that has its caveats, and yeah it all goes back to the privacy guarantees. > Are yo
644.
by hot_gril 2y ago
MacBook is what I've got, but if you specifically need lots of RAM and/or a dedicated GPU, that disqualifies it. 64GB RAM isn't even an option in the $3000 model. Also, maybe you want to run Linux for whatever reason, without
645.
by hot_gril 2y ago
I thought about Thinkpads just before you replied and edited to mention the issues I've seen with them. Yes you're right, Google buys them, and they have minor problems, but I've never owned one personally.
646.
by hot_gril 2y ago
Was gonna say, they can bid you farewell without giving you access to stuff.
647.
by hot_gril 2y ago
Julia doesn't have broad adoption because it's too specific, and C++/Rust are more cumbersome, also Python for data science and ML was popular before Rust or Julia even existed. Python's biggest advantage is that it&#x27
648.
by hot_gril 2y ago
What else? NodeJS would be sorta viable, but event loop doesn't mix well with this kind of workload, which is a moot point anyway because Python and all the killer libs like Numpy predate NodeJS. And I think Python's package manag
649.
by hot_gril 2y ago
Chromebook means hardware + software are packaged, which means someone is making sure they work properly together. That's the biggest differentiator. You can maybe get this with some Linux laptops, idk. The Thinkpads we have at work th
650.
by hot_gril 2y ago
I haven't seen those, but it wouldn't surprise me.
651.
by hot_gril 2y ago
WhatsApp didn't have multi-device support until mid 2023. I'd have to see exactly how it works now, cause it raises more questions. If you can rely on users remembering passphrases (no recovery mechanism), it makes chat history ea
652.
by hot_gril 2y ago
Yeah, whoever pushes this is way more annoying than whoever makes the bubbles green. Just one group chat I'm in uses Signal for some reason. People often miss messages cause it silently deprecates old versions. And nobody has verified
653.
by hot_gril 2y ago
I don't want to use a third-party messenger app because I don't want to deal with separate apps, and none of them are very good anyway. FB Messenger is close, but it doesn't work well with non-"friends". On the larg
654.
by hot_gril 2y ago
To build something 1:1 with iMessage, there'd need to be a market the Pixel has a large share of. For something like FB, they tried with G+. And WhatsApp had first mover advantage. They had other messaging apps that were maybe ok, but
655.
by hot_gril 2y ago
The companies did it, but also, the buyer had choices.
656.
by hot_gril 2y ago
I don't have a writeup, but RCS doesn't specify e2ee. Google has their own thing that doesn't work with other RCS clients (including Apple).
657.
by hot_gril 2y ago
What's wrong with that? Google did it too with RCS.
658.
by hot_gril 2y ago
The part of my family that all uses Samsung phones still can't rely on group chats between themselves, so I think it's them.
659.
by hot_gril 2y ago
Because often times the Android phone won't even do group SMS properly, and it screws everything up. You start getting messages that some other group members didn't. Maybe this is why a lot of Android users use WhatsApp, and that&
660.
by hot_gril 2y ago
For reasons like this, I've never owned an iPad. Seems like an intentionally gimped version of a PC.

More ›