How to make schema and code dynamic?

Posted by Jonarch on Stack Overflow See other posts from Stack Overflow or by Jonarch
Published on 2011-01-02T06:25:03Z Indexed on 2011/01/02 6:53 UTC
Read the original article Hit count: 179

Filed under:
|
|
|

I want to make my database schema and application code as dynamic as possible to handle "unknown" use cases and changes. Developing in PHP and MySQL. Twice now I have had to change my entire schema including table and column names and this means the developers have to go back to the application code and modify all the SQL queries and table/columns names. So to prevent this I want to if just like we do on pages where we have page content, title bar etc dynamic like a %variable%, can we do it for the schema and maybe even for the php code functions and classes somehow? It takes weeks to re-do all changes like this vs if it is dynamic it can be done in under a day.

© Stack Overflow or respective owner

Related posts about php

Related posts about database