{"action":"created","issue":{"url":"https://api.github.com/repos/ScalaWilliam/duel.gg/issues/35","labels_url":"https://api.github.com/repos/ScalaWilliam/duel.gg/issues/35/labels{/name}","comments_url":"https://api.github.com/repos/ScalaWilliam/duel.gg/issues/35/comments","events_url":"https://api.github.com/repos/ScalaWilliam/duel.gg/issues/35/events","html_url":"https://github.com/ScalaWilliam/duel.gg/issues/35","id":114479865,"number":35,"title":"Simplify pinger-service & use PostgreSQL for our storage needs.","user":{"login":"ScalaWilliam","id":2464813,"avatar_url":"https://avatars.githubusercontent.com/u/2464813?v=3","gravatar_id":"","url":"https://api.github.com/users/ScalaWilliam","html_url":"https://github.com/ScalaWilliam","followers_url":"https://api.github.com/users/ScalaWilliam/followers","following_url":"https://api.github.com/users/ScalaWilliam/following{/other_user}","gists_url":"https://api.github.com/users/ScalaWilliam/gists{/gist_id}","starred_url":"https://api.github.com/users/ScalaWilliam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ScalaWilliam/subscriptions","organizations_url":"https://api.github.com/users/ScalaWilliam/orgs","repos_url":"https://api.github.com/users/ScalaWilliam/repos","events_url":"https://api.github.com/users/ScalaWilliam/events{/privacy}","received_events_url":"https://api.github.com/users/ScalaWilliam/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-01T16:48:12Z","updated_at":"2015-11-01T16:50:12Z","closed_at":null,"body":"It makes sense for us to use something like PostgreSQL for caching etc.\r\n\r\nPinger service can then be reduced to nothing more than a notification service which says:\r\n'here is a live game update', streaming the game from start to finish.\r\n\r\nAnd of course journalling. If we send only IDs there's little for us to worry about and we query directly from the database instead. Yesszzszsz, good stuff ennit :+1: "},"comment":{"url":"https://api.github.com/repos/ScalaWilliam/duel.gg/issues/comments/152843243","html_url":"https://github.com/ScalaWilliam/duel.gg/issues/35#issuecomment-152843243","issue_url":"https://api.github.com/repos/ScalaWilliam/duel.gg/issues/35","id":152843243,"user":{"login":"ScalaWilliam","id":2464813,"avatar_url":"https://avatars.githubusercontent.com/u/2464813?v=3","gravatar_id":"","url":"https://api.github.com/users/ScalaWilliam","html_url":"https://github.com/ScalaWilliam","followers_url":"https://api.github.com/users/ScalaWilliam/followers","following_url":"https://api.github.com/users/ScalaWilliam/following{/other_user}","gists_url":"https://api.github.com/users/ScalaWilliam/gists{/gist_id}","starred_url":"https://api.github.com/users/ScalaWilliam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ScalaWilliam/subscriptions","organizations_url":"https://api.github.com/users/ScalaWilliam/orgs","repos_url":"https://api.github.com/users/ScalaWilliam/repos","events_url":"https://api.github.com/users/ScalaWilliam/events{/privacy}","received_events_url":"https://api.github.com/users/ScalaWilliam/received_events","type":"User","site_admin":false},"created_at":"2015-11-01T16:50:12Z","updated_at":"2015-11-01T16:50:12Z","body":"Then the API can also use the database as its main data store for loading in the initial data.\r\n\r\nThen absolutely no need to worry about having to re-index things and such. We store our cache/results right in there and refresh should the facts change later."}}