{"action":"created","issue":{"url":"https://api.github.com/repos/favll/pogom/issues/15","repository_url":"https://api.github.com/repos/favll/pogom","labels_url":"https://api.github.com/repos/favll/pogom/issues/15/labels{/name}","comments_url":"https://api.github.com/repos/favll/pogom/issues/15/comments","events_url":"https://api.github.com/repos/favll/pogom/issues/15/events","html_url":"https://github.com/favll/pogom/issues/15","id":167726239,"number":15,"title":"[Improvement] Supporting other databases","user":{"login":"lisandro52","id":5612241,"avatar_url":"https://avatars.githubusercontent.com/u/5612241?v=3","gravatar_id":"","url":"https://api.github.com/users/lisandro52","html_url":"https://github.com/lisandro52","followers_url":"https://api.github.com/users/lisandro52/followers","following_url":"https://api.github.com/users/lisandro52/following{/other_user}","gists_url":"https://api.github.com/users/lisandro52/gists{/gist_id}","starred_url":"https://api.github.com/users/lisandro52/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lisandro52/subscriptions","organizations_url":"https://api.github.com/users/lisandro52/orgs","repos_url":"https://api.github.com/users/lisandro52/repos","events_url":"https://api.github.com/users/lisandro52/events{/privacy}","received_events_url":"https://api.github.com/users/lisandro52/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/favll/pogom/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":11,"created_at":"2016-07-26T22:21:54Z","updated_at":"2016-08-09T15:14:55Z","closed_at":null,"body":"# Motivation\r\nRight now, we have awesome requesting speeds between our server and the API servers, but we are getting bottlenecked by the parsing/saving to the DB.\r\n\r\n## Posible solution\r\nOne way to ease this out is by supporting others RDBMs like MySQL/MariaDB or PostgreSQL (even NoSQL could be useful, e.g. RethinkDB [on this PokemonGo-Map fork](https://github.com/fourbytes/pogomap))\r\n\r\nShould we focus on supporting an ORM like Peewee or SQLAlchemy, or just grab a single library like we do now for SQLite?"},"comment":{"url":"https://api.github.com/repos/favll/pogom/issues/comments/238585917","html_url":"https://github.com/favll/pogom/issues/15#issuecomment-238585917","issue_url":"https://api.github.com/repos/favll/pogom/issues/15","id":238585917,"user":{"login":"lisandro52","id":5612241,"avatar_url":"https://avatars.githubusercontent.com/u/5612241?v=3","gravatar_id":"","url":"https://api.github.com/users/lisandro52","html_url":"https://github.com/lisandro52","followers_url":"https://api.github.com/users/lisandro52/followers","following_url":"https://api.github.com/users/lisandro52/following{/other_user}","gists_url":"https://api.github.com/users/lisandro52/gists{/gist_id}","starred_url":"https://api.github.com/users/lisandro52/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lisandro52/subscriptions","organizations_url":"https://api.github.com/users/lisandro52/orgs","repos_url":"https://api.github.com/users/lisandro52/repos","events_url":"https://api.github.com/users/lisandro52/events{/privacy}","received_events_url":"https://api.github.com/users/lisandro52/received_events","type":"User","site_admin":false},"created_at":"2016-08-09T15:14:55Z","updated_at":"2016-08-09T15:14:55Z","body":"I already added MySQL support on my fork (I didn't push the changes, though. Sorry!). I simply changed [line 7](https://github.com/favll/pogom/blob/master/pogom/models.py#L7) `SqliteDatabase` with `MySQLDatabase`, and changed lines 15-19 on [models.py](https://github.com/favll/pogom/blob/master/pogom/models.py) with the following:\r\n\r\n```\r\ndb = MySQLDatabase('database_name', user='user', passwd='password', host='localhost')\r\n```\r\n(Adjust the options according to your system)\r\nYou'll also need to install PyMySQL (`pip install PyMySQL`) and have a database with `database_name` (or whatever you want) created on your MySQL/MariaDB instance.\r\n"}}
{"actor":{"display_login":"lisandro52"}}