News for hackers. Stuff that matters.
Re:Pinterest's simple tech stack to scale to 11M monthly users by tmsh on Saturday December 23, 2023 @06:06AM (#38743301)
In 2024 all major cloud providers have NoSQL (AWS DynamoDB and its equivalents) that will easily scale to beyond this use case, managed purely by good single table design. That is the best practice for this and most basic use cases — not RDBMS in 2024.

Why? key/value data stores have consistent hashing which scales to planet scale built in. No need for sharding or caching or other bs that brings down slack and GitHub every other month.

Re:Pinterest's simple tech stack to scale to 11M monthly users by Denvercoder9 on Saturday December 23, 2023 @08:04AM (#38743963)
Most applications don't need planet scale, though.
Re:Pinterest's simple tech stack to scale to 11M monthly users by rsanek on Saturday December 23, 2023 @07:51AM (#38743882)
do you have a reference to how this might be accomplished? how do you avoid high read / write latencies if you put everything into a single table / key-value pair per user?
Re:Pinterest's simple tech stack to scale to 11M monthly users by Zanfa on Saturday December 23, 2023 @08:52AM (#38744231)
I think they're referring to single-table data design as described in https://www.youtube.com/watch?v=HaEPXoXVf2k It's quite clever and scales well, but completely unnecessary for the vast majority of CRUD apps.
Re:Pinterest's simple tech stack to scale to 11M monthly users by evntdrvn on Saturday December 23, 2023 @09:22AM (#38744392)
IMO it’s also difficult when you’re in the initial phases of a new company/product, because the system is evolving fast and that doesn’t play nice with single-table-design needing upfront design to work well.

I have had much better luck sticking to a plain old relational DB stack for those phases, because it’s fast to iterate, and then consider moving to single-table NOSQL when the system/DDD has “gelled” and traffic is starting to hockey-stick

Re:Pinterest's simple tech stack to scale to 11M monthly users by adrianN on Saturday December 23, 2023 @09:54AM (#38744629)
I know cases where caches on top of a kv store improved performance a lot. I don’t think it’s as simple as you claim.