schema change management tools
I have been looking to see if there are any schema change management tools for Cassandra. I have not come across any so far. I figured I would check to see if anyone can point me to something before I start trying to implement something on my own. I have used liquibase ( http://www.liquibase.org) for relational databases. Earlier today I tried using it with the cassandra-jdbc driver, but ran into some exceptions due to the SQL generated. I am not looking specifically for something CQL-based. Something that uses the Thrift API via CLI scripts for example would work as well. Thanks - John
Re: schema change management tools
Not that I know of. I've always been really strict about dumping my schemas (to start) and keeping my changes in migration files. I don't do a ton of schema changes so I haven't had a need to really automate it. Even with MySQL I never bothered. Jon On Thu, Oct 4, 2012 at 6:27 PM, John Sanda john.sa...@gmail.com wrote: I have been looking to see if there are any schema change management tools for Cassandra. I have not come across any so far. I figured I would check to see if anyone can point me to something before I start trying to implement something on my own. I have used liquibase ( http://www.liquibase.org) for relational databases. Earlier today I tried using it with the cassandra-jdbc driver, but ran into some exceptions due to the SQL generated. I am not looking specifically for something CQL-based. Something that uses the Thrift API via CLI scripts for example would work as well. Thanks - John -- Jon Haddad http://www.rustyrazorblade.com skype: rustyrazorblade
Re: schema change management tools
For the project I work on and for previous projects as well that support multiple upgrade paths, this kind of tooling is a necessity. And I would prefer to avoid duplicating effort if there is already something out there. If not though, I will be sure to post back to the list with whatever I wind up doing. On Thu, Oct 4, 2012 at 9:34 PM, Jonathan Haddad j...@jonhaddad.com wrote: Not that I know of. I've always been really strict about dumping my schemas (to start) and keeping my changes in migration files. I don't do a ton of schema changes so I haven't had a need to really automate it. Even with MySQL I never bothered. Jon On Thu, Oct 4, 2012 at 6:27 PM, John Sanda john.sa...@gmail.com wrote: I have been looking to see if there are any schema change management tools for Cassandra. I have not come across any so far. I figured I would check to see if anyone can point me to something before I start trying to implement something on my own. I have used liquibase ( http://www.liquibase.org) for relational databases. Earlier today I tried using it with the cassandra-jdbc driver, but ran into some exceptions due to the SQL generated. I am not looking specifically for something CQL-based. Something that uses the Thrift API via CLI scripts for example would work as well. Thanks - John -- Jon Haddad http://www.rustyrazorblade.com skype: rustyrazorblade
Re: schema change management tools
Awesome - keep me posted. Jon On Thu, Oct 4, 2012 at 6:42 PM, John Sanda john.sa...@gmail.com wrote: For the project I work on and for previous projects as well that support multiple upgrade paths, this kind of tooling is a necessity. And I would prefer to avoid duplicating effort if there is already something out there. If not though, I will be sure to post back to the list with whatever I wind up doing. On Thu, Oct 4, 2012 at 9:34 PM, Jonathan Haddad j...@jonhaddad.com wrote: Not that I know of. I've always been really strict about dumping my schemas (to start) and keeping my changes in migration files. I don't do a ton of schema changes so I haven't had a need to really automate it. Even with MySQL I never bothered. Jon On Thu, Oct 4, 2012 at 6:27 PM, John Sanda john.sa...@gmail.com wrote: I have been looking to see if there are any schema change management tools for Cassandra. I have not come across any so far. I figured I would check to see if anyone can point me to something before I start trying to implement something on my own. I have used liquibase ( http://www.liquibase.org) for relational databases. Earlier today I tried using it with the cassandra-jdbc driver, but ran into some exceptions due to the SQL generated. I am not looking specifically for something CQL-based. Something that uses the Thrift API via CLI scripts for example would work as well. Thanks - John -- Jon Haddad http://www.rustyrazorblade.com skype: rustyrazorblade -- Jon Haddad http://www.rustyrazorblade.com skype: rustyrazorblade