buildr-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Assaf Arkin" <ar...@intalio.com>
Subject Re: suggestion for new feature: db migrations
Date Wed, 17 Sep 2008 00:31:50 GMT
Apropos, here's the Rails guide for using migrations. Might have some
good ideas:
http://guides.rails.info/migrations/migrations.html

Assaf

On Thu, Sep 11, 2008 at 7:57 AM, Shane Witbeck <shane@digitalsanctum.com> wrote:
> Provide the framework for doing arbitrary database operations (SQL) via a
> jdbc driver? The addons would do the same arbitrary tasks via a specific ORM
> framework although not sure how useful ORM is in this context.
>
> Maybe an intitial step would be creating an arbitrary sql task that could
> then be called before and/or after a deploy task or integration test task. I
> attribute this to the SQL Ant task.
>
> A later step would be something closer to true migrations similar to how RoR
> handles them. Associate 1 to n sql tasks to a versioned project complete
> with rollback capability.
>
> -Shane
>
>
> On Wed, Sep 10, 2008 at 11:29 PM, Assaf Arkin <arkin@intalio.com> wrote:
>
>> On Wed, Sep 10, 2008 at 10:50 AM, Shane Witbeck
>> <shane@digitalsanctum.com> wrote:
>> > My answer to these types of questions is always to let the user decide or
>> in
>> > this case let them develop the addons. When I first proposed this I was
>> > actually just thinking about a SQL-only solution.
>>
>> So what should Buildr role be?  Provide one default set of migration
>> tasks?  Specify how the tasks are used, but not implement any?
>>
>> Assaf
>>
>> >
>> > -Shane
>> >
>> >
>> > On Wed, Sep 10, 2008 at 12:58 PM, Assaf Arkin <arkin@intalio.com> wrote:
>> >
>> >> On Tue, Sep 9, 2008 at 6:56 AM, Shane Witbeck <shane@digitalsanctum.com
>> >
>> >> wrote:
>> >> > DB migrations as part of the build/deploy process via Buildr:
>> >> >
>> >> > http://code.google.com/p/c5-db-migration/
>> >> >
>> >> > What do you think?
>> >>
>> >> Yes.
>> >>
>> >> It sounds to me like all migration solutions are nearly the same when
>> >> you're changing schemas around.  But then you need to populate a
>> >> table, generate fake data, or shift data around, and now it's a
>> >> question of how to run non-SQL code and which language and ORM you
>> >> favor.
>> >>
>> >> Do we want to pick, or just have people develop different addons?
>> >>
>> >> Assaf
>> >>
>> >> >
>> >> >
>> >> > -Shane
>> >> >
>> >>
>> >
>>
>

Mime
View raw message