4 ms·

Interesting... I can imagine uttering some four letter words while trying to figure out what was going on if I was to take over maintaining a system that used

Interesting... I can imagine uttering some four letter words while trying to figure out what was going on if I was to take over maintaining a system that used this (principal of least surprise)

jerrysievert 8y ago
probably the same four letter words that were uttered when it was determined that something wild and crazy was needed in order to support the requirements. documentation is key.
gaius 8y ago
Writing through a view is totally unremarkable and has been for a long time. It’s quite common in Oracle and SQL Server lands. You can update via a CTE too, very easy, very elegant.
Jweb_Guru 8y ago
Counterpoint: using writable views was one of the best decisions my company ever made and no one regretted it. It is much easier to comprehend than ordinary triggers (specifically, the automated version).