Re:Do We Still Have to Denormalize? Have Your Schema and Sea...
by fauigerzigerk on Monday November 16, 2026 @07:11AM
(#50516736)
>a) thats the reason why lot of platforms do not allow to change username after signup
Nor any of the other user data that is indexed with every single post?
Re:Do We Still Have to Denormalize? Have Your Schema and Sea...
by KellyCriterion on Monday November 16, 2026 @07:43AM
(#50517018)
If I look at my youtube comment notification, Id say propably not? (Timestamp belongs to a post as well as likes etc.?)
Re:Do We Still Have to Denormalize? Have Your Schema and Sea...
by sgarland on Monday November 16, 2026 @08:45AM
(#50517548)
Experience across multiple companies of varying size and maturity has proven to me that devs are incapable of doing the RDBMS’ job for it; there are always orphaned rows and referential integrity issues when FK Constraints get dropped.
Databases are hard. They’re also some of the best-tested code that exists, so maybe let them do their job.
b) absolutely manageable with a solid tooling (and honestly, in 99% of cases this event is trivial as most systems just do not hold enough data to make it like a "eeek this change will run for 3 days for that 1 user")