On Wed, Sep 11, 2013 at 1:08 AM, Free Ekanayaka <[email protected]> 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. -- storm mailing list [email protected] Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/storm
