[Ur] Database migrations

[Artyom Shalkhakov]

Hello Saulo,

2017-02-08 16:15 GMT+06:00 Saulo Araujo <saulo2 at gmail.com>:

> 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 <
> artyom.shalkhakov at gmail.com> 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
>> Ur at impredicative.com
>> http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
>>
>>
>
> _______________________________________________
> Ur mailing list
> Ur at impredicative.com
> http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
>
>


-- 
Cheers,
Artyom Shalkhakov
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.impredicative.com/pipermail/ur/attachments/20170214/62c43f0b/attachment.html>