On Thu, Sep 12, 2013 at 12:18 AM, Jamu Kakar <[email protected]> wrote: > 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.
Yeah, the resulting schema could be generated automatically at that point though (with psql, pgdump or equivalent). -- storm mailing list [email protected] Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/storm
