[thelist] assistance designing schema

r937 rudy at r937.com
Thu Jan 7 22:28:06 CST 2010

jeremy, any time you store meta-data (in your case, column names), you have 
a very fragile design that is just begging for trouble

as well, any time you store multiple similar columns with suffixes like 01, 
02, 03, etc., you are letting yourself in for complex queries that have very 
little chance of being efficient

i would not attempt to implement "generality" where different users can 
specify different column contents

insist up front that they identify and specify their information 
requirements up front, then design a static schema

you'll save yourself gobs of coding and a world of hurt


More information about the thelist mailing list