{"action":"created","issue":{"url":"https://api.github.com/repos/letsencrypt/boulder/issues/132","labels_url":"https://api.github.com/repos/letsencrypt/boulder/issues/132/labels{/name}","comments_url":"https://api.github.com/repos/letsencrypt/boulder/issues/132/comments","events_url":"https://api.github.com/repos/letsencrypt/boulder/issues/132/events","html_url":"https://github.com/letsencrypt/boulder/issues/132","id":72212765,"number":132,"title":"Switch to MySQL only as a supported storage engine","user":{"login":"jsha","id":220205,"avatar_url":"https://avatars.githubusercontent.com/u/220205?v=3","gravatar_id":"","url":"https://api.github.com/users/jsha","html_url":"https://github.com/jsha","followers_url":"https://api.github.com/users/jsha/followers","following_url":"https://api.github.com/users/jsha/following{/other_user}","gists_url":"https://api.github.com/users/jsha/gists{/gist_id}","starred_url":"https://api.github.com/users/jsha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jsha/subscriptions","organizations_url":"https://api.github.com/users/jsha/orgs","repos_url":"https://api.github.com/users/jsha/repos","events_url":"https://api.github.com/users/jsha/events{/privacy}","received_events_url":"https://api.github.com/users/jsha/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-04-30T16:27:07Z","updated_at":"2015-04-30T19:17:05Z","closed_at":null,"body":"There are some frustrating differences between SQLite and MySQL that wind up causing unnecessary differences between the test/dev mode and the production mode, which invites bugs. Some of these differences are:\r\n - Can't \"CREATE INDEX IF NOT EXISTS.\"\r\n - Can't set user permissions. We want this, for instance, to enforce that certain tables like certificates are INSERT-only and can't be updated.\r\n\r\nWe should make MySQL a requirement to run the dev environment, provide instructions on how to set up a dev DB, and assume presence of MySQL in the dev environment.\r\n\r\ncc @rolandshoemaker"},"comment":{"url":"https://api.github.com/repos/letsencrypt/boulder/issues/comments/97934154","html_url":"https://github.com/letsencrypt/boulder/issues/132#issuecomment-97934154","issue_url":"https://api.github.com/repos/letsencrypt/boulder/issues/132","id":97934154,"user":{"login":"kuba","id":106176,"avatar_url":"https://avatars.githubusercontent.com/u/106176?v=3","gravatar_id":"","url":"https://api.github.com/users/kuba","html_url":"https://github.com/kuba","followers_url":"https://api.github.com/users/kuba/followers","following_url":"https://api.github.com/users/kuba/following{/other_user}","gists_url":"https://api.github.com/users/kuba/gists{/gist_id}","starred_url":"https://api.github.com/users/kuba/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kuba/subscriptions","organizations_url":"https://api.github.com/users/kuba/orgs","repos_url":"https://api.github.com/users/kuba/repos","events_url":"https://api.github.com/users/kuba/events{/privacy}","received_events_url":"https://api.github.com/users/kuba/received_events","type":"User","site_admin":false},"created_at":"2015-04-30T19:17:05Z","updated_at":"2015-04-30T19:17:05Z","body":"Boulder is my first project in Go, ever :). Therefore I won't be of help here, but maybe @rolandshoemaker knows more..."}}