{"action":"created","issue":{"url":"https://api.github.com/repos/preaction/Minion-Backend-mysql/issues/16","repository_url":"https://api.github.com/repos/preaction/Minion-Backend-mysql","labels_url":"https://api.github.com/repos/preaction/Minion-Backend-mysql/issues/16/labels{/name}","comments_url":"https://api.github.com/repos/preaction/Minion-Backend-mysql/issues/16/comments","events_url":"https://api.github.com/repos/preaction/Minion-Backend-mysql/issues/16/events","html_url":"https://github.com/preaction/Minion-Backend-mysql/issues/16","id":275211017,"number":16,"title":"Decide on minimum supported MySQL/MariaDB version","user":{"login":"lammel","id":43678,"avatar_url":"https://avatars2.githubusercontent.com/u/43678?v=4","gravatar_id":"","url":"https://api.github.com/users/lammel","html_url":"https://github.com/lammel","followers_url":"https://api.github.com/users/lammel/followers","following_url":"https://api.github.com/users/lammel/following{/other_user}","gists_url":"https://api.github.com/users/lammel/gists{/gist_id}","starred_url":"https://api.github.com/users/lammel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lammel/subscriptions","organizations_url":"https://api.github.com/users/lammel/orgs","repos_url":"https://api.github.com/users/lammel/repos","events_url":"https://api.github.com/users/lammel/events{/privacy}","received_events_url":"https://api.github.com/users/lammel/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-11-20T01:05:10Z","updated_at":"2017-11-21T00:35:55Z","closed_at":null,"author_association":"NONE","body":"To upgrade the database schema to a recent version matching the schema handled by Minion::Backend-Pg the JSON related functions and storing array must be supported (ENUM should not be an issue).\r\n\r\nThis would mean that the minimum supported MySQL version would have to be raised to MySQL 5.7 / MariaDB 10.2 which would be rather new and limit adoption.\r\n\r\nOn the other hand it would be hard to achieve feature parity without using a newer version.\r\n\r\nThis ticket is meant to decide on the minimum supported MySQL/MariaDB version."},"comment":{"url":"https://api.github.com/repos/preaction/Minion-Backend-mysql/issues/comments/345877711","html_url":"https://github.com/preaction/Minion-Backend-mysql/issues/16#issuecomment-345877711","issue_url":"https://api.github.com/repos/preaction/Minion-Backend-mysql/issues/16","id":345877711,"user":{"login":"lammel","id":43678,"avatar_url":"https://avatars2.githubusercontent.com/u/43678?v=4","gravatar_id":"","url":"https://api.github.com/users/lammel","html_url":"https://github.com/lammel","followers_url":"https://api.github.com/users/lammel/followers","following_url":"https://api.github.com/users/lammel/following{/other_user}","gists_url":"https://api.github.com/users/lammel/gists{/gist_id}","starred_url":"https://api.github.com/users/lammel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lammel/subscriptions","organizations_url":"https://api.github.com/users/lammel/orgs","repos_url":"https://api.github.com/users/lammel/repos","events_url":"https://api.github.com/users/lammel/events{/privacy}","received_events_url":"https://api.github.com/users/lammel/received_events","type":"User","site_admin":false},"created_at":"2017-11-21T00:35:55Z","updated_at":"2017-11-21T00:35:55Z","author_association":"NONE","body":"Well, then I'm going to update the MySQL migrations based on MySQL 5.6 / MariaDB 10.1.\r\nFor array-like usage, we can simply use a many-to-many relation (parents of a job), which should still allow for good enough performance.\r\n\r\nFor the JSON stuff, I'm not sure how we can handle that apart from using a text only string (VARCHAR or TEXT) and handling the results in perl.\r\n\r\nWork will be based on the fix-features branch."}}
{"actor":{"display_login":"lammel"}}