{"action":"created","issue":{"url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/1223","repository_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map","labels_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/1223/labels{/name}","comments_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/1223/comments","events_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/1223/events","html_url":"https://github.com/AHAAAAAAA/PokemonGo-Map/pull/1223","id":167047144,"number":1223,"title":"Enable MySQL as an database alternative","user":{"login":"vaurdan","id":5804923,"avatar_url":"https://avatars.githubusercontent.com/u/5804923?v=3","gravatar_id":"","url":"https://api.github.com/users/vaurdan","html_url":"https://github.com/vaurdan","followers_url":"https://api.github.com/users/vaurdan/followers","following_url":"https://api.github.com/users/vaurdan/following{/other_user}","gists_url":"https://api.github.com/users/vaurdan/gists{/gist_id}","starred_url":"https://api.github.com/users/vaurdan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vaurdan/subscriptions","organizations_url":"https://api.github.com/users/vaurdan/orgs","repos_url":"https://api.github.com/users/vaurdan/repos","events_url":"https://api.github.com/users/vaurdan/events{/privacy}","received_events_url":"https://api.github.com/users/vaurdan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-22T13:38:21Z","updated_at":"2016-07-22T14:15:15Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/pulls/1223","html_url":"https://github.com/AHAAAAAAA/PokemonGo-Map/pull/1223","diff_url":"https://github.com/AHAAAAAAA/PokemonGo-Map/pull/1223.diff","patch_url":"https://github.com/AHAAAAAAA/PokemonGo-Map/pull/1223.patch"},"body":"Since there are people having a bunch of Database locked issues because of SQLite - see #1028 and #744 - I've decided to implement an alternative MySQL connection. \r\n\r\nI'm storing the database settings on the `credentials.json` file. If the `db_name` value is empty, it will simply use the normal SQLite database, so by default and for the basic users it's still simply plug-and-play to use. \r\n\r\nHowever, when you have several instances of PokemonGo-Map running, SQLite doesn't work that well, and with this PR you can move all your database logic to MySQL.\r\n\r\nThis pull request includes a\r\n\r\n- [X] Bug fix\r\n- [x] New feature\r\n- [ ] Translation\r\n\r\nThe following changes were made\r\n\r\n- Added an alternative MySQL backend\r\n- Changed `credentials.json` to store mysql settings\r\n\r\nRelated issues: #1028 and #744"},"comment":{"url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/comments/234555300","html_url":"https://github.com/AHAAAAAAA/PokemonGo-Map/pull/1223#issuecomment-234555300","issue_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/1223","id":234555300,"user":{"login":"jangrewe","id":126137,"avatar_url":"https://avatars.githubusercontent.com/u/126137?v=3","gravatar_id":"","url":"https://api.github.com/users/jangrewe","html_url":"https://github.com/jangrewe","followers_url":"https://api.github.com/users/jangrewe/followers","following_url":"https://api.github.com/users/jangrewe/following{/other_user}","gists_url":"https://api.github.com/users/jangrewe/gists{/gist_id}","starred_url":"https://api.github.com/users/jangrewe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jangrewe/subscriptions","organizations_url":"https://api.github.com/users/jangrewe/orgs","repos_url":"https://api.github.com/users/jangrewe/repos","events_url":"https://api.github.com/users/jangrewe/events{/privacy}","received_events_url":"https://api.github.com/users/jangrewe/received_events","type":"User","site_admin":false},"created_at":"2016-07-22T14:15:15Z","updated_at":"2016-07-22T14:15:15Z","body":"Thank you, thank you, thank you."}}
{"actor":{"display_login":"jangrewe"}}