[storm] Why doesn't Storm generate DDL?

[Free Ekanayaka]

On Thu, Sep 12, 2013 at 12:18 AM, Jamu Kakar <jkakar at kakar.ca> wrote:
> 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.

Yeah, the resulting schema could be generated automatically at that
point though (with psql, pgdump or equivalent).