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)