[storm] Why doesn't Storm generate DDL?

[Jamu Kakar]

On Wed, Sep 11, 2013 at 1:08 AM, Free Ekanayaka
<free.ekanayaka at gmail.com> wrote:
>> 2. Patches to update live databases.  We have a simple system in
>> storm.schema that can be used to apply patches to a live database and
>> bring up to the spec defined in schema.sql.  There's the obvious
>> problem that bugs in your patches can introduce skew between live
>> production systems and what's in schema.sql but we've always lived
>> with that and it hasn't been a big problem, in practice.
>
> One solution would to initialize new databases using the patch
> sequence, so the final schema will be always the same.

I would caution against doing that.  Having an always up-to-date SQL
schema has some benefits:

- It's a single source of truth for what the schema should be.

- Patches have a way of bit rotting over time.