August 24th, 2013, 06:56 AM
How do you keep track of which web pages use which tables?
I want to know how others document or keep track of the tables that their web pages use. For example if I want to change the structure of a table I would need to know which web pages I'm going to impact, right? This means I would have to have a place where I can filter by table and see all of the web pages. Alternatively if I were moving web pages from one server to another I would want to see which tables needed to be migrated first.
What have you all found to be the best and cleanest method for keeping track of this information?
August 24th, 2013, 11:04 PM
Are you talking about database tables? If so, which database system are you using? MySQL? PregSQL? MsSQL? (I'll move this thread for you.)
August 25th, 2013, 06:25 AM
August 25th, 2013, 12:24 PM
document the tables in comments at the top of every program module or html page in the source code
then use a text editor to search the source code library
August 25th, 2013, 02:13 PM
Okay, so that's one way. I have all of the tables in the php files that I'm using so I guess I would open all of the files in my text editor and then do a search for them all?
Originally Posted by r937
Currently I have an excel sheed with the webpages going down column A and each table going across to column CA. It's not very efficient.
October 1st, 2013, 04:15 AM
check out with fire bug...
Comments on this post