Show HN: Heap is a new approach to analytics. Just capture everything

Re:Show HN: Heap is a new approach to analytics. Just captur... by pvnick on Friday March 22, 2013 @02:56PM (#5424855)

Or a table with two columns, Key and Value. Index by key. Specify keys in code with constants. No need to alter table when adding new metrics.

[ Parent | on HN ]

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.

[ Parent | on HN ]

Re:Show HN: Heap is a new approach to analytics. Just captur... by dustin on Friday March 22, 2013 @03:35PM (#5425104)

This!

[ Parent | on HN ]