Re: Schema Versioning

2016-02-12 Thread John Sanda
If you are interested in a solution that maintains scripts, there are at least a few projects available, https://github.com/comeara/pillar - Runs on the JVM and written in Scala. Scripts are CQL files. https://github.com/Contrast-Security-OSS/cassandra-migration - Runs on JVM and I believe a port

Re: Schema Versioning

2016-02-10 Thread Alex Popescu
On Wed, Feb 10, 2016 at 12:05 PM, Joe Bako wrote: > Modern RDBMS tools can compare schemas between DDL object definitions and > live databases and generate change scripts accordingly. Older techniques > included maintaining a version and script table in the database,

Re: Schema Versioning

2016-02-10 Thread Jonathan Haddad
I wrote most of the cqlengine keyspace & table management pieces of the Python driver to solve this exact problem. Instead of working with a series of statements for creating tables & managing columns, we simply created classes in Python and sync'ed them to the DB. It automatically figured out

Schema Versioning

2016-02-10 Thread Joe Bako
Hi all, I am curious what techniques are used by others to manage schema changes over time in Cassandra. Modern RDBMS tools can compare schemas between DDL object definitions and live databases and generate change scripts accordingly. Older techniques included maintaining a version and