News for hackers. Stuff that matters.

A comment on Squeeze the hell out of the system you have. Parent comment

Re:Squeeze the hell out of the system you have by alfor on Friday August 11, 2023 @05:08PM (#37094054)
But for the saves the structure is visible?
[ Parent | on HN ]
Re:Squeeze the hell out of the system you have by taylodl on Friday August 11, 2023 @05:10PM (#37094077)
You can update underlying data via a materialized view.
[ Parent | on HN ]
Re:Squeeze the hell out of the system you have by NortySpock on Friday August 11, 2023 @10:39PM (#37096455)
Heck, at least with SQL Server 2017, I've been able to write updates to a thin view, and so long as the columns referenced were not ambiguous, the database would handle the underlying tables and locks required.
[ Parent | on HN ]