Hello Saulo, 2017-02-08 16:15 GMT+06:00 Saulo Araujo <[email protected]>:
> 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). > > Thank you, I will take a look. > 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 > > -- Cheers, Artyom Shalkhakov
_______________________________________________ Ur mailing list [email protected] http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
