undefined | Better HN

0 pointscommandlinefan2y ago0 comments

> to mutate the status of individual posts and comment

AKA why you should normalize your data models.

0 comments

Meh it's a tradeoff usually. De-normalize for better read performance at the expense of some complexity and worse update performance/semantics.

eropple2y ago

This is true, but FWIW (it probably wouldn't save you here, too much is changing too fast) something like a SQL materialized view can very often give you both the chocolate and the peanut butter.

j / k navigate · click thread line to collapse

0 pointscommandlinefan2y ago0 comments

> to mutate the status of individual posts and comment

AKA why you should normalize your data models.

0 comments

ElevenLathe2y ago

Meh it's a tradeoff usually. De-normalize for better read performance at the expense of some complexity and worse update performance/semantics.

eropple2y ago

This is true, but FWIW (it probably wouldn't save you here, too much is changing too fast) something like a SQL materialized view can very often give you both the chocolate and the peanut butter.

j / k navigate · click thread line to collapse