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: 205
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