{"action":"created","issue":{"url":"https://api.github.com/repos/pyr/cyanite/issues/238","repository_url":"https://api.github.com/repos/pyr/cyanite","labels_url":"https://api.github.com/repos/pyr/cyanite/issues/238/labels{/name}","comments_url":"https://api.github.com/repos/pyr/cyanite/issues/238/comments","events_url":"https://api.github.com/repos/pyr/cyanite/issues/238/events","html_url":"https://github.com/pyr/cyanite/pull/238","id":173314249,"number":238,"title":"Simplify indexes, remove paths table","user":{"login":"ifesdjeen","id":12669,"avatar_url":"https://avatars.githubusercontent.com/u/12669?v=3","gravatar_id":"","url":"https://api.github.com/users/ifesdjeen","html_url":"https://github.com/ifesdjeen","followers_url":"https://api.github.com/users/ifesdjeen/followers","following_url":"https://api.github.com/users/ifesdjeen/following{/other_user}","gists_url":"https://api.github.com/users/ifesdjeen/gists{/gist_id}","starred_url":"https://api.github.com/users/ifesdjeen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ifesdjeen/subscriptions","organizations_url":"https://api.github.com/users/ifesdjeen/orgs","repos_url":"https://api.github.com/users/ifesdjeen/repos","events_url":"https://api.github.com/users/ifesdjeen/events{/privacy}","received_events_url":"https://api.github.com/users/ifesdjeen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-08-25T21:26:38Z","updated_at":"2016-08-26T07:38:31Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/pyr/cyanite/pulls/238","html_url":"https://github.com/pyr/cyanite/pull/238","diff_url":"https://github.com/pyr/cyanite/pull/238.diff","patch_url":"https://github.com/pyr/cyanite/pull/238.patch"},"body":"Paths table is redundant and was slowing down both write\r\nand read path, since it was much harder to simplify it.\r\nIt was initially an artefact of having leaves and prefixes\r\nqueries, although after optimising the query building,\r\nit's all not required and will allow for faster queries."},"comment":{"url":"https://api.github.com/repos/pyr/cyanite/issues/comments/242653357","html_url":"https://github.com/pyr/cyanite/pull/238#issuecomment-242653357","issue_url":"https://api.github.com/repos/pyr/cyanite/issues/238","id":242653357,"user":{"login":"pyr","id":110280,"avatar_url":"https://avatars.githubusercontent.com/u/110280?v=3","gravatar_id":"","url":"https://api.github.com/users/pyr","html_url":"https://github.com/pyr","followers_url":"https://api.github.com/users/pyr/followers","following_url":"https://api.github.com/users/pyr/following{/other_user}","gists_url":"https://api.github.com/users/pyr/gists{/gist_id}","starred_url":"https://api.github.com/users/pyr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pyr/subscriptions","organizations_url":"https://api.github.com/users/pyr/orgs","repos_url":"https://api.github.com/users/pyr/repos","events_url":"https://api.github.com/users/pyr/events{/privacy}","received_events_url":"https://api.github.com/users/pyr/received_events","type":"User","site_admin":false},"created_at":"2016-08-26T07:38:31Z","updated_at":"2016-08-26T07:38:31Z","body":"Good riddance."}}
{"actor":{"display_login":"pyr"}}