<div dir="ltr">I've never played with <span style="font-family:arial,sans-serif;font-size:12.8000001907349px">liquibase</span>. but +1 for start using migrations<br><div><br></div><div>-- Passos</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Oct 6, 2014 at 2:24 PM, Stian Thorgersen <span dir="ltr"><<a href="mailto:stian@redhat.com" target="_blank">stian@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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.<br>
<div><div class="h5"><br>
----- Original Message -----<br>
> From: "Erik Jan de Wit" <<a href="mailto:edewit@redhat.com">edewit@redhat.com</a>><br>
> To: "AeroGear Developer Mailing List" <<a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a>><br>
> Sent: Monday, 6 October, 2014 5:48:53 PM<br>
> Subject: [aerogear-dev] database migration<br>
><br>
> Hi,<br>
><br>
> Now that we have 2 versions out of the door, when we change stuff we need an<br>
> easy upgrade path. Not only for the API but also for the database. Because<br>
> we support a couple of them having something of a process would help.<br>
><br>
> I’ve have used liquibase in the past. You write ‘change sets’ in yaml, json<br>
> or if you must in xml, it will create a migration table in the database and<br>
> execute the changes needed to bring it up to date or you can create a sql<br>
> script that will do the same. Cool thing about this approach is that it’s<br>
> independent of the database<br>
><br>
> <a href="http://www.liquibase.org" target="_blank">http://www.liquibase.org</a><br>
><br>
> Another tool I’ve heard about, but also promising is Flyway. It’s supports<br>
> writing migrations in sql and java comes with it’s own java api. Basically<br>
> the same idea with regards to this migration table, but here you need to<br>
> specify your own sql scripts. Or you can write migrations in java where<br>
> having special named java class gets executed to update/migrate the data.<br>
><br>
> <a href="http://flywaydb.org" target="_blank">http://flywaydb.org</a><br>
><br>
> WDYT?<br>
><br>
> Cheers,<br>
> Erik Jan<br>
><br>
><br>
</div></div>> _______________________________________________<br>
> aerogear-dev mailing list<br>
> <a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a><br>
> <a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><br>
<br>
_______________________________________________<br>
aerogear-dev mailing list<br>
<a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a></blockquote></div><br></div>