Support for MySQL

[cdolan]

I would like to add support for MySQL in Pliny. But before jumping into working on this, I'd like to get some feedback whether this would be a beneficial addition.

[brandur]

@cdolan Hello! My apologies for the late reply to this issue.

Regarding MySQL support: we generally try to prefer Postgres, and if possible, would like to keep the project as focused as possible along a single track of technology. That said, if this can be a very useful addition, we'd certainly consider it.

In general, I think the Sequel gem that we bundle by default comes with pretty good MySQL support, and with some fairly minimal dependency swapping, you should be able to get MySQL in. Do you have an idea yet of what kind of changes that you'd tackle for this one? I'd imagine the DB Rake tasks would probably need to be amended the most.

[prognostikos]

@cdolan have you done any work on this? I would be happy to test whatever you have, otherwise I will look into my own PR.

[cdolan]

@prognostikos sorry, I have not -- this has been on the back-burner. Feel free to take this on.