Flyway DB Migrations

2015-01-14 Thread Josh Mahonin
Hi all, As an FYI, I've got a pull request into Flyway (http://flywaydb.org/) for Phoenix support: https://github.com/flyway/flyway/pull/930 I don't know what everyone else is using for schema management, if anything at all, but the preliminary support works well enough for Flyway's various

Re: Flyway DB Migrations

2015-01-14 Thread Josh Mahonin
Hi James, I had actually hoped to use the DatabaseMetaData originally, but I was getting some interesting behaviour when using the 'getTables()' query when 'schemaPattern' was null. I'm not at my dev. machine to check for sure, but I think I was getting back a list of all tables, rather than just

Re: Flyway DB Migrations

2015-01-14 Thread James Taylor
Wow, that's really awesome, Josh. Nice work. Can you let us know if/when it makes it in? One modification you may want to consider in a future revision to protect yourself in case the SYSTEM.CATALOG schema changes down the road: Use the DatabaseMetaData APIs[1] instead of querying the