[aerogear-dev] database migration

[Daniel Passos]

I've never played with liquibase. but +1 for start using migrations

-- Passos

On Mon, Oct 6, 2014 at 2:24 PM, Stian Thorgersen <stian at redhat.com> wrote:

> We're looking at this for Keycloak atm as well, and those where the two
> that stood out at first glance. I haven't looked in depth or tried them out
> yet though.
>
> ----- Original Message -----
> > From: "Erik Jan de Wit" <edewit at redhat.com>
> > To: "AeroGear Developer Mailing List" <aerogear-dev at lists.jboss.org>
> > Sent: Monday, 6 October, 2014 5:48:53 PM
> > Subject: [aerogear-dev] database migration
> >
> > Hi,
> >
> > Now that we have 2 versions out of the door, when we change stuff we
> need an
> > easy upgrade path. Not only for the API but also for the database.
> Because
> > we support a couple of them having something of a process would help.
> >
> > I’ve have used liquibase in the past. You write ‘change sets’ in yaml,
> json
> > or if you must in xml, it will create a migration table in the database
> and
> > execute the changes needed to bring it up to date or you can create a sql
> > script that will do the same. Cool thing about this approach is that it’s
> > independent of the database
> >
> > http://www.liquibase.org
> >
> > Another tool I’ve heard about, but also promising is Flyway. It’s
> supports
> > writing migrations in sql and java comes with it’s own java api.
> Basically
> > the same idea with regards to this migration table, but here you need to
> > specify your own sql scripts. Or you can write migrations in java where
> > having special named java class gets executed to update/migrate the data.
> >
> > http://flywaydb.org
> >
> > WDYT?
> >
> > Cheers,
> > Erik Jan
> >
> >
> > _______________________________________________
> > aerogear-dev mailing list
> > aerogear-dev at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/aerogear-dev
>
> _______________________________________________
> aerogear-dev mailing list
> aerogear-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/aerogear-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-dev/attachments/20141006/d246a417/attachment.html