[storm] Why doesn't Storm generate DDL?

[Jamu Kakar]

I'm glad you're enjoying Storm!  We talked about this years ago and
decided that there are at least two pieces:

1. Schema generation/initial creation of a schema for a new database.
The method most of us have used is to always have a current schema.sql
file that defines the schema for a project.  It should always be
update and acts as documentation as well as bootstrapping for new
deployments.

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.

We've always felt that schema generation, as in from Storm-based
Python classes, was out of scope and instead always thought about
annotating Storm properties in a way that would allow such a system to
be built outside of Storm.  I still think that's a good idea.

On Tue, Sep 10, 2013 at 8:29 AM, Mark E. Haase <mehaase at gmail.com> wrote:
> I've been using Storm for the last few weeks and I love it. In many ways,
> it's the nicest ORM I've ever used.
>
> One quick question: why doesn't storm generate DDL statements, e.g. "CREATE
> TABLE ..."? I assume there is some philosophical reason that Storm omits
> this common feature that most other ORMs have, because I found a page
> (https://storm.canonical.com/AutomaticSchemaGeneration) that indicates
> decent progress, but it hasn't been updated for 5+ years.
>
> Was there opposition to this feature? Or did everybody just lose interest? I
> would love to see a feature like this added as a decoupled component in
> Storm, and I'm willing to work on updating whatever was started 5 years ago.
>
> Thoughts? Feedback?
>
> Thanks,
> Mark
>
> --
> storm mailing list
> storm at lists.canonical.com
> Modify settings or unsubscribe at:
> https://lists.ubuntu.com/mailman/listinfo/storm
>