Purge unused fields

[aarontitus]

Original author: cpw...@gmail.com (February 26, 2013 12:05:28)

In #133, Aaron asks: "Is it possible to start off by purging all of the fields that have never been used?"

Original issue: http://code.google.com/p/sandy-disaster-recovery/issues/detail?id=204

[aarontitus]

From cpw...@gmail.com on February 26, 2013 12:09:52
May include

• tree_damage
• tree_damage_details

[aarontitus]

From cpw...@gmail.com on February 26, 2013 12:13:14
May include

• tree_diameter

[aarontitus]

From v...@aarontitus.net on February 26, 2013 14:16:22
We should be able to do a simple query and count non-blank or non-NULL cells, correct?
...or would that require creation of a dozen more indices? Oh, the joys of NOSQL... database optimization: 1. Optimization? We don't need no stinking optimization! 2. You'd better get it right the first time, because if you try for it later, you will explode your DB in the attempt, thus rendering any resulting optimization futile.

[aarontitus]

From v...@aarontitus.net on February 26, 2013 14:27:27
I have a vague uneasy feeling that in very short order the database will become completely beyond the control of any human, making fixes and migration impossible.
Call me old-fashioned, but I like understanding my own database. I don't want to be forced to rely on SkyNet to fix my database for me.

Oh, Google... into thy hands I commend my digital soul... ;-)