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-11 Thread Carlos Alonso
Here we use the Cassanity gem: https://github.com/jnunemaker/cassanity This one suggests using schema migration files that are then registered in a column family to keep track of the version. Carlos Alonso | Software Engineer | @calonso On 10 February 2016 at 21:29,

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 wh

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, storing > schema change scri