{"action":"created","issue":{"url":"https://api.github.com/repos/SpongePowered/Sponge/issues/199","labels_url":"https://api.github.com/repos/SpongePowered/Sponge/issues/199/labels{/name}","comments_url":"https://api.github.com/repos/SpongePowered/Sponge/issues/199/comments","events_url":"https://api.github.com/repos/SpongePowered/Sponge/issues/199/events","html_url":"https://github.com/SpongePowered/Sponge/pull/199","id":60770422,"number":199,"title":"Implement SQL service","user":{"login":"zml2008","id":629092,"avatar_url":"https://avatars.githubusercontent.com/u/629092?v=3","gravatar_id":"","url":"https://api.github.com/users/zml2008","html_url":"https://github.com/zml2008","followers_url":"https://api.github.com/users/zml2008/followers","following_url":"https://api.github.com/users/zml2008/following{/other_user}","gists_url":"https://api.github.com/users/zml2008/gists{/gist_id}","starred_url":"https://api.github.com/users/zml2008/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zml2008/subscriptions","organizations_url":"https://api.github.com/users/zml2008/orgs","repos_url":"https://api.github.com/users/zml2008/repos","events_url":"https://api.github.com/users/zml2008/events{/privacy}","received_events_url":"https://api.github.com/users/zml2008/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/SpongePowered/Sponge/labels/input%20wanted","name":"input wanted","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-03-12T04:40:11Z","updated_at":"2015-03-12T11:30:37Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/SpongePowered/Sponge/pulls/199","html_url":"https://github.com/SpongePowered/Sponge/pull/199","diff_url":"https://github.com/SpongePowered/Sponge/pull/199.diff","patch_url":"https://github.com/SpongePowered/Sponge/pull/199.patch"},"body":"Just want to PR this for some comments on the supported database platforms.\r\nThis differs from Bukkit in a few ways\r\n\r\n1. Mariadb rather than MySQL connector: I chose the MariaDB one over the MySQL one because to me it seems like there has been a switch away from oracle MySQl based on the fact that Oracle sucks. (they should be protocol-compatible anyways)\r\n\r\n2. H2 rather than sqlite: SQLite has a ton of limitations in a lot of areas (like modifying tables) that make working with it hard. H2 has a richer feature set, and as a bonus is pure-java. A few bukkit plugins have used this database engine in the past, so I think it is worth including instead of sqlite.\r\n\r\n(and yeah, I dumped another slightly unrelated commit in because I had to work with the config while implementing this API)"},"comment":{"url":"https://api.github.com/repos/SpongePowered/Sponge/issues/comments/78463555","html_url":"https://github.com/SpongePowered/Sponge/pull/199#issuecomment-78463555","issue_url":"https://api.github.com/repos/SpongePowered/Sponge/issues/199","id":78463555,"user":{"login":"modwizcode","id":369772,"avatar_url":"https://avatars.githubusercontent.com/u/369772?v=3","gravatar_id":"","url":"https://api.github.com/users/modwizcode","html_url":"https://github.com/modwizcode","followers_url":"https://api.github.com/users/modwizcode/followers","following_url":"https://api.github.com/users/modwizcode/following{/other_user}","gists_url":"https://api.github.com/users/modwizcode/gists{/gist_id}","starred_url":"https://api.github.com/users/modwizcode/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/modwizcode/subscriptions","organizations_url":"https://api.github.com/users/modwizcode/orgs","repos_url":"https://api.github.com/users/modwizcode/repos","events_url":"https://api.github.com/users/modwizcode/events{/privacy}","received_events_url":"https://api.github.com/users/modwizcode/received_events","type":"User","site_admin":false},"created_at":"2015-03-12T11:30:37Z","updated_at":"2015-03-12T11:30:37Z","body":"Please do not bundle SQL, this is something that we can leave up to\ndevelopers of plugins.\n"}}