{"action":"created","issue":{"url":"https://api.github.com/repos/openworm/open-worm-analysis-toolbox/issues/193","repository_url":"https://api.github.com/repos/openworm/open-worm-analysis-toolbox","labels_url":"https://api.github.com/repos/openworm/open-worm-analysis-toolbox/issues/193/labels{/name}","comments_url":"https://api.github.com/repos/openworm/open-worm-analysis-toolbox/issues/193/comments","events_url":"https://api.github.com/repos/openworm/open-worm-analysis-toolbox/issues/193/events","html_url":"https://github.com/openworm/open-worm-analysis-toolbox/issues/193","id":157553675,"number":193,"title":"Make AWS database queries accessible via web interface","user":{"login":"MichaelCurrie","id":5267078,"avatar_url":"https://avatars.githubusercontent.com/u/5267078?v=3","gravatar_id":"","url":"https://api.github.com/users/MichaelCurrie","html_url":"https://github.com/MichaelCurrie","followers_url":"https://api.github.com/users/MichaelCurrie/followers","following_url":"https://api.github.com/users/MichaelCurrie/following{/other_user}","gists_url":"https://api.github.com/users/MichaelCurrie/gists{/gist_id}","starred_url":"https://api.github.com/users/MichaelCurrie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MichaelCurrie/subscriptions","organizations_url":"https://api.github.com/users/MichaelCurrie/orgs","repos_url":"https://api.github.com/users/MichaelCurrie/repos","events_url":"https://api.github.com/users/MichaelCurrie/events{/privacy}","received_events_url":"https://api.github.com/users/MichaelCurrie/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"MichaelCurrie","id":5267078,"avatar_url":"https://avatars.githubusercontent.com/u/5267078?v=3","gravatar_id":"","url":"https://api.github.com/users/MichaelCurrie","html_url":"https://github.com/MichaelCurrie","followers_url":"https://api.github.com/users/MichaelCurrie/followers","following_url":"https://api.github.com/users/MichaelCurrie/following{/other_user}","gists_url":"https://api.github.com/users/MichaelCurrie/gists{/gist_id}","starred_url":"https://api.github.com/users/MichaelCurrie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MichaelCurrie/subscriptions","organizations_url":"https://api.github.com/users/MichaelCurrie/orgs","repos_url":"https://api.github.com/users/MichaelCurrie/repos","events_url":"https://api.github.com/users/MichaelCurrie/events{/privacy}","received_events_url":"https://api.github.com/users/MichaelCurrie/received_events","type":"User","site_admin":false},"assignees":[{"login":"MichaelCurrie","id":5267078,"avatar_url":"https://avatars.githubusercontent.com/u/5267078?v=3","gravatar_id":"","url":"https://api.github.com/users/MichaelCurrie","html_url":"https://github.com/MichaelCurrie","followers_url":"https://api.github.com/users/MichaelCurrie/followers","following_url":"https://api.github.com/users/MichaelCurrie/following{/other_user}","gists_url":"https://api.github.com/users/MichaelCurrie/gists{/gist_id}","starred_url":"https://api.github.com/users/MichaelCurrie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MichaelCurrie/subscriptions","organizations_url":"https://api.github.com/users/MichaelCurrie/orgs","repos_url":"https://api.github.com/users/MichaelCurrie/repos","events_url":"https://api.github.com/users/MichaelCurrie/events{/privacy}","received_events_url":"https://api.github.com/users/MichaelCurrie/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/openworm/open-worm-analysis-toolbox/milestones/7","html_url":"https://github.com/openworm/open-worm-analysis-toolbox/milestones/Brown%20Lab%20Priorities","labels_url":"https://api.github.com/repos/openworm/open-worm-analysis-toolbox/milestones/7/labels","id":1795176,"number":7,"title":"Brown Lab Priorities","description":"","creator":{"login":"MichaelCurrie","id":5267078,"avatar_url":"https://avatars.githubusercontent.com/u/5267078?v=3","gravatar_id":"","url":"https://api.github.com/users/MichaelCurrie","html_url":"https://github.com/MichaelCurrie","followers_url":"https://api.github.com/users/MichaelCurrie/followers","following_url":"https://api.github.com/users/MichaelCurrie/following{/other_user}","gists_url":"https://api.github.com/users/MichaelCurrie/gists{/gist_id}","starred_url":"https://api.github.com/users/MichaelCurrie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MichaelCurrie/subscriptions","organizations_url":"https://api.github.com/users/MichaelCurrie/orgs","repos_url":"https://api.github.com/users/MichaelCurrie/repos","events_url":"https://api.github.com/users/MichaelCurrie/events{/privacy}","received_events_url":"https://api.github.com/users/MichaelCurrie/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":1,"state":"open","created_at":"2016-05-30T05:52:08Z","updated_at":"2016-08-04T07:51:15Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2016-05-30T20:33:07Z","updated_at":"2016-08-05T06:19:40Z","closed_at":null,"body":"At first we'll just want a search bar that allows you to query the feature vector when you supply the strain name or gene name.\r\n\r\nAt first the address would just be an IPv4 address, but after [https://github.com/openworm/org.openworm.website/issues/68](I find out how to route DNS entries for openworm.org), we could have the interface operate from movement.openworm.org, for instance."},"comment":{"url":"https://api.github.com/repos/openworm/open-worm-analysis-toolbox/issues/comments/237765889","html_url":"https://github.com/openworm/open-worm-analysis-toolbox/issues/193#issuecomment-237765889","issue_url":"https://api.github.com/repos/openworm/open-worm-analysis-toolbox/issues/193","id":237765889,"user":{"login":"MichaelCurrie","id":5267078,"avatar_url":"https://avatars.githubusercontent.com/u/5267078?v=3","gravatar_id":"","url":"https://api.github.com/users/MichaelCurrie","html_url":"https://github.com/MichaelCurrie","followers_url":"https://api.github.com/users/MichaelCurrie/followers","following_url":"https://api.github.com/users/MichaelCurrie/following{/other_user}","gists_url":"https://api.github.com/users/MichaelCurrie/gists{/gist_id}","starred_url":"https://api.github.com/users/MichaelCurrie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MichaelCurrie/subscriptions","organizations_url":"https://api.github.com/users/MichaelCurrie/orgs","repos_url":"https://api.github.com/users/MichaelCurrie/repos","events_url":"https://api.github.com/users/MichaelCurrie/events{/privacy}","received_events_url":"https://api.github.com/users/MichaelCurrie/received_events","type":"User","site_admin":false},"created_at":"2016-08-05T06:19:40Z","updated_at":"2016-08-05T06:19:40Z","body":"For Django to be the interface, we need the database to be in utf-8.  Sadly, it's currently in `latin-1`:\r\n\r\n```\r\nmysql> show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mrc_db             |\r\n+--------------------+\r\n2 rows in set (0.00 sec)\r\n\r\nmysql> use mrc_db;\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\n\r\nmysql> show variables like 'character_set_database';\r\n+------------------------+--------+\r\n| Variable_name          | Value  |\r\n+------------------------+--------+\r\n| character_set_database | latin1 |\r\n+------------------------+--------+\r\n1 row in set (0.00 sec)\r\n```\r\n\r\n[This blog entry](https://blogs.harvard.edu/djcp/2010/01/convert-mysql-database-from-latin1-to-utf8-the-right-way/) from Dan Collis-Puro suggests a way to convert the database is the following command:\r\n\r\n`mysqldump --add-drop-table mrc_db | replace CHARSET=latin1 CHARSET=utf8 | iconv -f latin1 -t utf8 | mysql mrc_db`\r\n\r\nI will try this now."}}
{"actor":{"display_login":"MichaelCurrie"}}