Add MySQL Engine #63

Closed
theory opened this Issue Jan 3, 2013 · 7 comments

Comments

Projects
None yet
2 participants
@theory
Owner

theory commented Jan 3, 2013

No description provided.

@melo

This comment has been minimized.

Show comment Hide comment
@melo

melo Apr 29, 2013

Documentation of sqitch mentions support for the mysql engine but in fact, as of 0.965, that is not implemented.

I'll be willing to test this if you end up implementing it...

melo commented Apr 29, 2013

Documentation of sqitch mentions support for the mysql engine but in fact, as of 0.965, that is not implemented.

I'll be willing to test this if you end up implementing it...

@theory

This comment has been minimized.

Show comment Hide comment
@theory

theory Apr 29, 2013

Owner

Thanks, yeah, it's on my list. Shouldn't be too hard, frankly, pretty much a direct port of the SQLite engine and schema.

Owner

theory commented Apr 29, 2013

Thanks, yeah, it's on my list. Shouldn't be too hard, frankly, pretty much a direct port of the SQLite engine and schema.

@theory

This comment has been minimized.

Show comment Hide comment
@theory

theory Jul 4, 2013

Owner

Hey @melo, I spent the last week adding MySQL support, and merged it into master yesterday, including a tutorial. Check it out! I expect to release it in a couple of weeks.

Owner

theory commented Jul 4, 2013

Hey @melo, I spent the last week adding MySQL support, and merged it into master yesterday, including a tutorial. Check it out! I expect to release it in a couple of weeks.

@theory theory closed this Jul 4, 2013

@melo

This comment has been minimized.

Show comment Hide comment
@melo

melo Jul 4, 2013

Wow, perfect timing, i was just about to dig my old SQL::Translator diff scripts to do this on a project... :)

I'll definitively give this a try very soon.

Thanks!

melo commented Jul 4, 2013

Wow, perfect timing, i was just about to dig my old SQL::Translator diff scripts to do this on a project... :)

I'll definitively give this a try very soon.

Thanks!

@theory

This comment has been minimized.

Show comment Hide comment
@theory

theory Jul 4, 2013

Owner

BTW, it requires MySQL 5.6.4. So if you are stuck with an older MySQL, it won't work. There are two reasons for this:

  • The microsecond precision support in DATETIME values, added in v5.6.4. This makes it much easier to keep things in the proper order (deployments usually take less than a second).
  • The SIGNAL functionality, introduced in v5.5. This allows the schema to mock a check constraint in the Sqitch database, as well as make it much easier to write verify tests (as described in the tutorial).

Hope you can try it with a newer MySQL!

Owner

theory commented Jul 4, 2013

BTW, it requires MySQL 5.6.4. So if you are stuck with an older MySQL, it won't work. There are two reasons for this:

  • The microsecond precision support in DATETIME values, added in v5.6.4. This makes it much easier to keep things in the proper order (deployments usually take less than a second).
  • The SIGNAL functionality, introduced in v5.5. This allows the schema to mock a check constraint in the Sqitch database, as well as make it much easier to write verify tests (as described in the tutorial).

Hope you can try it with a newer MySQL!

@melo

This comment has been minimized.

Show comment Hide comment
@melo

melo Jul 4, 2013

Yeah... Not on this project I was considering. MySQL is not under my control, and they use 5.1.

On my other projects I usually use the latest stable Percona release. I'll check if they already have 5.6.x available.

Thanks!

melo commented Jul 4, 2013

Yeah... Not on this project I was considering. MySQL is not under my control, and they use 5.1.

On my other projects I usually use the latest stable Percona release. I'll check if they already have 5.6.x available.

Thanks!

@theory

This comment has been minimized.

Show comment Hide comment
@theory

theory Jul 4, 2013

Owner

Bummer. Hope you can try it soon!

Owner

theory commented Jul 4, 2013

Bummer. Hope you can try it soon!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment