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".
It seems to have 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?
ThoughtStorms:DatabaseViews
No comments:
Post a Comment