Hi Artyon, I believe that Liquibase satisfies, at least partially, your requirements. In particular, it is able diff databases ( http://www.liquibase.org/documentation/diff.html).
Regards, Saulo On Wed, Feb 8, 2017 at 4:52 AM, Artyom Shalkhakov < [email protected]> wrote: > Hello all, > > I'd like to see Ur/Web helping with database migrations. Currently, the > compiler will output an SQL script containing DDL statements to create the > schema from scratch. > > Ur/Web largely follows a "code-first" approach: the program's code is > authoritative source of the database schema (or, put it differently, > program's code is enough to infer the definition of the database schema). > > My idea is to have Ur/Web generate the database schema in a > database-independent format (e.g. as some simple JSON), and then use a tool > to find the diff/patch between two such schemas. > > Having searched for off-the-shelf tools to help with generating DDL > statements given two schemas expressed in a database-independent format, I > came up with basically nothing that can be easily reused.[2] > > I'm looking for help with the format definition (preferably something that > comes with tools: e.g. convert schema definition to DDL of target > database). Seems like the simplest/best way forward is to go with an > Ur/Web-specific tool. > > -- > Cheers, > Artyom Shalkhakov > > [1] https://github.com/urweb/urweb/issues/65 > [2] https://github.com/urweb/urweb/issues/65#issuecomment-277904189 > > _______________________________________________ > Ur mailing list > [email protected] > http://www.impredicative.com/cgi-bin/mailman/listinfo/ur > >
_______________________________________________ Ur mailing list [email protected] http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
