Re:Show HN: Heap is a new approach to analytics. Just captur...
by bcoates on Friday March 22, 2013 @03:51PM
(#5425224)
Please don't do this! Entity-Attribute-Value tables are a nightmare waiting to happen about 98% of the time.
If there's something wrong with your DBMS where the alter table to add a row is an expensive or dangerous operation, just add a new table for every attribute, having lots of tables in a database is no worse than having lots of variables in a program.
If your DBA gets angry at you for adding new tables all the time, get a new DBA.
If there's something wrong with your DBMS where the alter table to add a row is an expensive or dangerous operation, just add a new table for every attribute, having lots of tables in a database is no worse than having lots of variables in a program.
If your DBA gets angry at you for adding new tables all the time, get a new DBA.