News for hackers. Stuff that matters.
Re:Squeeze the hell out of the system you have by endisneigh on Friday August 11, 2023 @09:27PM (#37096024)
I agree but I’m talking in the context where you can’t vertically scale anymore.
Re:Squeeze the hell out of the system you have by fastball on Saturday August 12, 2023 @12:04AM (#37096940)
How is it that your new project can't fit on a single machine?
Re:Squeeze the hell out of the system you have by cuu508 on Saturday August 12, 2023 @01:23AM (#37097276)
Perhaps they're building an internet search engine.
Re:Squeeze the hell out of the system you have by yafbum on Saturday August 12, 2023 @02:47AM (#37097685)
Could be plenty of reasons, but say you want to support spikey traffic like whatever is related to events, news, realtime information, etc., or highly seasonal stuff like a school portal or selling flowers on mother's day, you want the ability to scale horizontally very quickly to accommodate spikes
Re:Squeeze the hell out of the system you have by aidos on Saturday August 12, 2023 @04:21AM (#37098161)
Everyone thinks they start their project with Facebook scale problems.
Re:Squeeze the hell out of the system you have by crazygringo on Saturday August 12, 2023 @10:31AM (#37100558)
Well then you're only really talking about < 0.1% of projects, since a single server and replication and caching will get you as far as you need, even for most social networks.

And if you are needing to massively shard because you're Facebook or Twitter, then it's not much of a hot take at all. But it's also massively oversimplified advice. Because the tradeoffs between joins and denormalization depend entirely on each specific scenario, and have to be analyzed use case by use case. In many cases, joins still win out -- e.g. retrieving the profile name and photo ID for the author of each post being displayed on your screen.

I'm just worried that people without experience will see your advice and think it's a good rule of thumb for their single-server database, because they think joins are scary and you've provided some kind of confirmation.