News for hackers. Stuff that matters.
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.

There are no comments on this comment yet.