News for hackers. Stuff that matters.
Re:Scaling Relational SQL Databases (2020) by oxfordmale on Wednesday June 16, 2021 @01:18PM (#27530989)
>>When it comes to scaling, we might need to think about: fast INSERTs and UPDATES for write-heavy workloads

If you want to scale database, all your write operations should be immutable and therefore you should rarely need UPDATE statements.

Re:Scaling Relational SQL Databases (2020) by evanelias on Wednesday June 16, 2021 @02:34PM (#27531884)
Immutability makes it easier to scale writes in a relational DB, but comes at the expense of more complexity and difficulty scaling reads. It's also problematic with regulation like GDPR / "right to be forgotten".

Immutability is definitely not a requirement for scaling a database. In my direct experience, the vast majority of large tech companies use mutable relational databases, with a write workload mixing INSERTs, UPDATEs, and DELETEs.