DatabaseViews
ThoughtStorms Wiki
I've just had to make minor change in a database schema (break a table into two). And in order to hide this change from several web-pages which used it, I've hidden the joining of these two tables behind a View.
Made the transition very clean. I changed the "update" page to update the real table, but all the other pages which pull out the data were just changed to reference the view.
Is this a good place to put an abstraction layer between pages and database schema? Or is it a ModularityMistake which will turn round an bite me?
See also WebServiceDesignPatterns
Backlinks (1 items)