{"action":"created","issue":{"url":"https://api.github.com/repos/rubygems/rubygems.org/issues/1208","repository_url":"https://api.github.com/repos/rubygems/rubygems.org","labels_url":"https://api.github.com/repos/rubygems/rubygems.org/issues/1208/labels{/name}","comments_url":"https://api.github.com/repos/rubygems/rubygems.org/issues/1208/comments","events_url":"https://api.github.com/repos/rubygems/rubygems.org/issues/1208/events","html_url":"https://github.com/rubygems/rubygems.org/issues/1208","id":136920350,"number":1208,"title":"Remove redis","user":{"login":"dwradcliffe","id":118850,"avatar_url":"https://avatars.githubusercontent.com/u/118850?v=3","gravatar_id":"","url":"https://api.github.com/users/dwradcliffe","html_url":"https://github.com/dwradcliffe","followers_url":"https://api.github.com/users/dwradcliffe/followers","following_url":"https://api.github.com/users/dwradcliffe/following{/other_user}","gists_url":"https://api.github.com/users/dwradcliffe/gists{/gist_id}","starred_url":"https://api.github.com/users/dwradcliffe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dwradcliffe/subscriptions","organizations_url":"https://api.github.com/users/dwradcliffe/orgs","repos_url":"https://api.github.com/users/dwradcliffe/repos","events_url":"https://api.github.com/users/dwradcliffe/events{/privacy}","received_events_url":"https://api.github.com/users/dwradcliffe/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"arthurnn","id":833383,"avatar_url":"https://avatars.githubusercontent.com/u/833383?v=3","gravatar_id":"","url":"https://api.github.com/users/arthurnn","html_url":"https://github.com/arthurnn","followers_url":"https://api.github.com/users/arthurnn/followers","following_url":"https://api.github.com/users/arthurnn/following{/other_user}","gists_url":"https://api.github.com/users/arthurnn/gists{/gist_id}","starred_url":"https://api.github.com/users/arthurnn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arthurnn/subscriptions","organizations_url":"https://api.github.com/users/arthurnn/orgs","repos_url":"https://api.github.com/users/arthurnn/repos","events_url":"https://api.github.com/users/arthurnn/events{/privacy}","received_events_url":"https://api.github.com/users/arthurnn/received_events","type":"User","site_admin":true},"milestone":null,"comments":4,"created_at":"2016-02-27T13:39:22Z","updated_at":"2016-02-27T16:43:12Z","closed_at":null,"body":"We would like to remove redis from the RubyGems.org infrastructure. It has been painful to run and it's a dependency that we don't need. We want to store the gem download stats in postgres, which will be much easier and faster. This is related to rubygems/rubygems-infrastructure#35 but this is a separate task.\r\n\r\nHere's what I think we need to do:\r\n\r\n- [ ] add any database columns necessary to store number of downloads per gem and per version (not sure if they are there yet or not)\r\n- [ ] add methods/rake tasks that will sync the gem and version download counts from redis to postgres (this should be able to run many times, to sync things as we work on this)\r\n- [ ] update app views to pull stats from the model instead of redis\r\n- [ ] update `FastlyLogProcessor` to push to postgres instead of redis\r\n- [ ] should be able to remove all redis?\r\n\r\n@arthurnn @evanphx @skottler @indirect @ktheory "},"comment":{"url":"https://api.github.com/repos/rubygems/rubygems.org/issues/comments/189680562","html_url":"https://github.com/rubygems/rubygems.org/issues/1208#issuecomment-189680562","issue_url":"https://api.github.com/repos/rubygems/rubygems.org/issues/1208","id":189680562,"user":{"login":"nateberkopec","id":845662,"avatar_url":"https://avatars.githubusercontent.com/u/845662?v=3","gravatar_id":"","url":"https://api.github.com/users/nateberkopec","html_url":"https://github.com/nateberkopec","followers_url":"https://api.github.com/users/nateberkopec/followers","following_url":"https://api.github.com/users/nateberkopec/following{/other_user}","gists_url":"https://api.github.com/users/nateberkopec/gists{/gist_id}","starred_url":"https://api.github.com/users/nateberkopec/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nateberkopec/subscriptions","organizations_url":"https://api.github.com/users/nateberkopec/orgs","repos_url":"https://api.github.com/users/nateberkopec/repos","events_url":"https://api.github.com/users/nateberkopec/events{/privacy}","received_events_url":"https://api.github.com/users/nateberkopec/received_events","type":"User","site_admin":false},"created_at":"2016-02-27T16:43:12Z","updated_at":"2016-02-27T16:43:12Z","body":">  add any database columns necessary to store number of downloads per gem and per version (not sure if they are there yet or not)\r\n\r\nMay be worth doing this in a separate table to minimize locking."}}