Please excuse me if this has been covered.
Can someone please explain to me the reasoning behind why the sites domain name is stored?
I have been searching for why this is necessary but all I can find is the same regurgitated explanation of how to move your site on 100 different blogs.
I hate to say this, but I find this to be one of the biggest flaws in the entire system. Makes moving a site a royal pain in the @$$, not to mention the fact that if I want to do any work I MUST push all the changes to the server to test and cannot test those changes locally first, nor can I have one database for testing and another for the live site without two complete installations and then migrate the data.
Why is this a PITA? Because every client I have ever worked for has a current site with a domain name they do not want to change. I must always build on a test server. Except for WordPress, making a development site live, for me, means changing the folder name where the site lives from dev.whatever.com to http://www.whatever.com. Takes me less than a minute... This is the only platform I have ever worked with that requires numerous database changes to get the site to work after the switch and then there is no guarantee do to the way some plugins store data.
Perhaps, if I understood the reason why this is required it would not irritate me so much.
Please don't point me to another "how to migrate your site" blog, I want to understand the reason I need to fix it.