{"action":"created","issue":{"url":"https://api.github.com/repos/duckduckgo/android/issues/229","repository_url":"https://api.github.com/repos/duckduckgo/android","labels_url":"https://api.github.com/repos/duckduckgo/android/issues/229/labels{/name}","comments_url":"https://api.github.com/repos/duckduckgo/android/issues/229/comments","events_url":"https://api.github.com/repos/duckduckgo/android/issues/229/events","html_url":"https://github.com/duckduckgo/android/issues/229","id":146255808,"number":229,"title":"Optimize Database Code","user":{"login":"hkasera","id":6101687,"avatar_url":"https://avatars.githubusercontent.com/u/6101687?v=3","gravatar_id":"","url":"https://api.github.com/users/hkasera","html_url":"https://github.com/hkasera","followers_url":"https://api.github.com/users/hkasera/followers","following_url":"https://api.github.com/users/hkasera/following{/other_user}","gists_url":"https://api.github.com/users/hkasera/gists{/gist_id}","starred_url":"https://api.github.com/users/hkasera/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hkasera/subscriptions","organizations_url":"https://api.github.com/users/hkasera/orgs","repos_url":"https://api.github.com/users/hkasera/repos","events_url":"https://api.github.com/users/hkasera/events{/privacy}","received_events_url":"https://api.github.com/users/hkasera/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"hkasera","id":6101687,"avatar_url":"https://avatars.githubusercontent.com/u/6101687?v=3","gravatar_id":"","url":"https://api.github.com/users/hkasera","html_url":"https://github.com/hkasera","followers_url":"https://api.github.com/users/hkasera/followers","following_url":"https://api.github.com/users/hkasera/following{/other_user}","gists_url":"https://api.github.com/users/hkasera/gists{/gist_id}","starred_url":"https://api.github.com/users/hkasera/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hkasera/subscriptions","organizations_url":"https://api.github.com/users/hkasera/orgs","repos_url":"https://api.github.com/users/hkasera/repos","events_url":"https://api.github.com/users/hkasera/events{/privacy}","received_events_url":"https://api.github.com/users/hkasera/received_events","type":"User","site_admin":false},"milestone":null,"comments":15,"created_at":"2016-04-06T09:50:22Z","updated_at":"2016-06-02T15:11:01Z","closed_at":"2016-05-30T09:27:24Z","body":"In the file [`DdgDB.java`](https://github.com/duckduckgo/android/blob/master/src/com/duckduckgo/mobile/android/db/DdgDB.java), I noticed that the code is not optimized. \r\nFor example, the field names of tables are hard coded everywhere. I suggest that we create a file called `DdgContracts.java` which lists all the constants like the table name and the fields in the table. The file `DdgDB.java` should then use these constants everywhere. This will help make the code more maintainable. \r\n\r\nI would be happy to send a PR for the same. Let me know if this is a welcome contribution right now.\r\n\r\nThanks,\r\nHarshita"},"comment":{"url":"https://api.github.com/repos/duckduckgo/android/issues/comments/223322196","html_url":"https://github.com/duckduckgo/android/issues/229#issuecomment-223322196","issue_url":"https://api.github.com/repos/duckduckgo/android/issues/229","id":223322196,"user":{"login":"moollaza","id":873785,"avatar_url":"https://avatars.githubusercontent.com/u/873785?v=3","gravatar_id":"","url":"https://api.github.com/users/moollaza","html_url":"https://github.com/moollaza","followers_url":"https://api.github.com/users/moollaza/followers","following_url":"https://api.github.com/users/moollaza/following{/other_user}","gists_url":"https://api.github.com/users/moollaza/gists{/gist_id}","starred_url":"https://api.github.com/users/moollaza/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/moollaza/subscriptions","organizations_url":"https://api.github.com/users/moollaza/orgs","repos_url":"https://api.github.com/users/moollaza/repos","events_url":"https://api.github.com/users/moollaza/events{/privacy}","received_events_url":"https://api.github.com/users/moollaza/received_events","type":"User","site_admin":false},"created_at":"2016-06-02T15:11:01Z","updated_at":"2016-06-02T15:11:01Z","body":"> Let me know if I can go ahead and pick it up\r\n\r\n@hkasera you're welcome to pick it up!"}}
{"actor":{"display_login":"moollaza"}}