Tuesday, April 13, 2004

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: