News for hackers. Stuff that matters.
Re:Flyway 4.1.0 released by axelfontaine on Thursday February 09, 2017 @10:43AM (#13607663)
Flyway creator here. Happy to answer any questions. Enjoy the release :-)
Re:Flyway 4.1.0 released by donpdonp on Thursday February 09, 2017 @11:57AM (#13608442)
We use flyway with a scala project at work and it does a great job!

It was working with ruby on rails that taught me one of the strongest reasons to use psql over over databases - transactional schema changes. If a migration fails I absolutely want the whole migration rolled back so that the schema can be fixed and tried again.

Which is why this paragraph is alarming:

"First Flyway now autodetects whether a non-transactional statement is present within a migration. If it is, then the whole migration is run without a transaction (and clearly labelled as such in the logs)."

Arguably, mostly devs working with psql dont know that its possible to create schema change commands that cannot be transactional, myself included. I imagine creating such a statement 'by accident' is exceedingly rare, but a default of allowMixedMigrations to false seems more sensible to be 'default safe'. I say 'safe' because a broken, half-executed migration can leave a real mess.

Thanks for your efforts and for the flyway project!

Re:Flyway 4.1.0 released by endymi0n on Thursday February 09, 2017 @10:25AM (#13607526)
Awesome work, Axel - Flyway is our absolute go-to tool for all migrations, very easy, straightforward and one of only two pieces of Java in our stack that's so good we let it stay :)
Re:Flyway 4.1.0 released by gred on Thursday February 09, 2017 @10:30AM (#13607560)
Don't leave us hanging! What's the other?
Re:Flyway 4.1.0 released by endymi0n on Thursday February 09, 2017 @10:34AM (#13607590)
ElasticSearch - definitively the least bad large scale full-text search server out there...

(BTW: Flyway FINALLY supports non-transactional PostgreSQL migrations now, been waiting for that for ages!)

Re:Flyway 4.1.0 released by axelfontaine on Thursday February 09, 2017 @10:42AM (#13607656)
Thanks! Truly appreciated!
Re:Flyway 4.1.0 released by 3adawi on Thursday February 09, 2017 @10:46AM (#13607699)
one of the things i hate most about my job is db migration, didn't know this existed, gonna give it a try
Re:Flyway 4.1.0 released by MBCook on Thursday February 09, 2017 @10:49AM (#13607716)
I was in the same boat with a little home-grown thing that worked.... ok. Then a coworker showed me FlyWay. It's great.