Re:Avoiding the soft delete anti-pattern
by panstromek on Wednesday May 15, 2024 @12:07AM
(#40363004)
Views are fragile in a sense that they don't update when the table that they depend on change and generally, you don't have any notification when you break one (e.g. by dropping a column that the view selects). I bumped into both of these in MySQL and SQLite. It looks to me like a view acts just like a cached sql string and not much more than that.
[ Parent
| on HN ]
There are no comments on this comment yet.