News for hackers. Stuff that matters.
Re:Squeeze the hell out of the system you have by rocqua on Saturday August 12, 2023 @05:03AM (#37098355)
I wish for a DB that lets me write a completely normalized scheme, and then lets me specify how it should denormalize the scheme for actual storage. There is no reason manual updates to denormalized DBs need to be hand-rolled every time. They are easy to automatically deduce.
Re:Squeeze the hell out of the system you have by kaba0 on Saturday August 12, 2023 @08:50AM (#37099657)
These are called material views.
Re:Squeeze the hell out of the system you have by tremon on Saturday August 12, 2023 @09:13AM (#37099829)
*updatable views.

Not every material view is updatable, and a view doesn't need to be materialized to be updatable.