MySQL Forums
Forum List  »  Newbie

Re: Automatic changes on my queries when changing my database ?
Posted by: Peter Brawley
Date: August 10, 2022 04:57AM

Unfortunately that'd require software with psychic abilities. Specifically, to the extent that sets of database table names, column names, their aliases, and their integrity & business rules fail to follow perfectly consistent patterns, to the extent they don't overlap, and to the degree that query requirements change over time: no.

What you can do is ...

(i) make the query maintenance/update process more manageable by keeping/documenting all query text in one place--that is, rather than scattering it through code in stored routines, Triggers and applications..

(ii) document all such query requirement changes to a set of one or more meta-tables that serve to track the status of each such change.

When query management is hostage to such externally driven changes, it can be a nightmare. Good luck.

Options: ReplyQuote


Subject
Written By
Posted
Re: Automatic changes on my queries when changing my database ?
August 10, 2022 04:57AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.