[ANN] goose: a database/sql migration tool

[Liam Staskawicz]

Hi!

I've been working on https://bitbucket.org/liamstask/goose to make it easier to manage your database schema.

goose is a simple tool that allows you to create incremental migrations either directly in SQL or in Go (using database/sql), and easily apply them or roll them back. Otherwise I've tried to stay out of the way as much as possible.

On the todo list is: generation of migration skeletons, and support for SQL dialects in addition to postgres (should be trivial, with any luck), and more test coverage.

Any and all feedback is more than welcome - I haven't yet gotten much feedback on how this might fit into the workflows of others, so definitely still open to tweaks and updates. Cheers!

Liam

[Ernest Micklei]

Hi,

I used to work a lot with migrations for development and deployment of SQL backends.

Have you looked at MyBatis migrations? http://www.mybatis.org/migrations/index.html 

Are you planning to provide similar commands? 

^ Ernest

Op zondag 16 december 2012 18:45:48 UTC+1 schreef Liam Staskawicz het volgende:

[Liam Staskawicz]

On Sunday, December 16, 2012 10:30:25 AM UTC-8, Ernest Micklei wrote:

Hi,

I used to work a lot with migrations for development and deployment of SQL backends.

Have you looked at MyBatis migrations? http://www.mybatis.org/migrations/index.html 

Are you planning to provide similar commands? 

^ Ernest

I had not seen that tool, but it's very similar in scope :) Many of those commands would be sensible (and not particularly difficult) to support - I would definitely be in favor.

[Francisco Souza]

FWIW, there's already an unrelated Go project named goose:
https://launchpad.net/goose.

> --
>
>



--
~f

[Liam Staskawicz]

On Sun, Dec 16, 2012 at 1:36 PM, Francisco Souza <f...@souza.cc> wrote:

FWIW, there's already an unrelated Go project named goose:
https://launchpad.net/goose.

Thanks for the heads up - looks like they were created at roughly the same time (a month apart) :) I'd be happy to consider altering the name if it's deemed to be confusing.

Liam