{"action":"created","issue":{"url":"https://api.github.com/repos/kjolley/BIGSdb/issues/158","repository_url":"https://api.github.com/repos/kjolley/BIGSdb","labels_url":"https://api.github.com/repos/kjolley/BIGSdb/issues/158/labels{/name}","comments_url":"https://api.github.com/repos/kjolley/BIGSdb/issues/158/comments","events_url":"https://api.github.com/repos/kjolley/BIGSdb/issues/158/events","html_url":"https://github.com/kjolley/BIGSdb/issues/158","id":101183131,"number":158,"title":"Support for large numbers of sparsely populated fields","user":{"login":"kjolley","id":7817395,"avatar_url":"https://avatars.githubusercontent.com/u/7817395?v=3","gravatar_id":"","url":"https://api.github.com/users/kjolley","html_url":"https://github.com/kjolley","followers_url":"https://api.github.com/users/kjolley/followers","following_url":"https://api.github.com/users/kjolley/following{/other_user}","gists_url":"https://api.github.com/users/kjolley/gists{/gist_id}","starred_url":"https://api.github.com/users/kjolley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kjolley/subscriptions","organizations_url":"https://api.github.com/users/kjolley/orgs","repos_url":"https://api.github.com/users/kjolley/repos","events_url":"https://api.github.com/users/kjolley/events{/privacy}","received_events_url":"https://api.github.com/users/kjolley/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/kjolley/BIGSdb/labels/auto-migrated","name":"auto-migrated","color":"ededed"},{"url":"https://api.github.com/repos/kjolley/BIGSdb/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/kjolley/BIGSdb/labels/sourceforge","name":"sourceforge","color":"ededed"}],"state":"open","locked":false,"assignee":{"login":"kjolley","id":7817395,"avatar_url":"https://avatars.githubusercontent.com/u/7817395?v=3","gravatar_id":"","url":"https://api.github.com/users/kjolley","html_url":"https://github.com/kjolley","followers_url":"https://api.github.com/users/kjolley/followers","following_url":"https://api.github.com/users/kjolley/following{/other_user}","gists_url":"https://api.github.com/users/kjolley/gists{/gist_id}","starred_url":"https://api.github.com/users/kjolley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kjolley/subscriptions","organizations_url":"https://api.github.com/users/kjolley/orgs","repos_url":"https://api.github.com/users/kjolley/repos","events_url":"https://api.github.com/users/kjolley/events{/privacy}","received_events_url":"https://api.github.com/users/kjolley/received_events","type":"User","site_admin":false},"assignees":[{"login":"kjolley","id":7817395,"avatar_url":"https://avatars.githubusercontent.com/u/7817395?v=3","gravatar_id":"","url":"https://api.github.com/users/kjolley","html_url":"https://github.com/kjolley","followers_url":"https://api.github.com/users/kjolley/followers","following_url":"https://api.github.com/users/kjolley/following{/other_user}","gists_url":"https://api.github.com/users/kjolley/gists{/gist_id}","starred_url":"https://api.github.com/users/kjolley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kjolley/subscriptions","organizations_url":"https://api.github.com/users/kjolley/orgs","repos_url":"https://api.github.com/users/kjolley/repos","events_url":"https://api.github.com/users/kjolley/events{/privacy}","received_events_url":"https://api.github.com/users/kjolley/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/kjolley/BIGSdb/milestones/11","html_url":"https://github.com/kjolley/BIGSdb/milestones/1.15","labels_url":"https://api.github.com/repos/kjolley/BIGSdb/milestones/11/labels","id":1388827,"number":11,"title":"1.15","description":"","creator":{"login":"kjolley","id":7817395,"avatar_url":"https://avatars.githubusercontent.com/u/7817395?v=3","gravatar_id":"","url":"https://api.github.com/users/kjolley","html_url":"https://github.com/kjolley","followers_url":"https://api.github.com/users/kjolley/followers","following_url":"https://api.github.com/users/kjolley/following{/other_user}","gists_url":"https://api.github.com/users/kjolley/gists{/gist_id}","starred_url":"https://api.github.com/users/kjolley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kjolley/subscriptions","organizations_url":"https://api.github.com/users/kjolley/orgs","repos_url":"https://api.github.com/users/kjolley/repos","events_url":"https://api.github.com/users/kjolley/events{/privacy}","received_events_url":"https://api.github.com/users/kjolley/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":14,"state":"open","created_at":"2015-11-02T13:40:48Z","updated_at":"2016-07-26T13:57:30Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2015-04-09T06:51:48Z","updated_at":"2016-07-27T09:39:36Z","closed_at":null,"body":"To store phenotypic data we may need to store a large number of fields but values for these may only be available for a small proportion of the dataset.  Rather than create extra isolate table fields which will be empty for most records, a means to define extra fields and store them as key/value pairs will be much more efficient and flexible.\n\nReported by: kjolley"},"comment":{"url":"https://api.github.com/repos/kjolley/BIGSdb/issues/comments/235537291","html_url":"https://github.com/kjolley/BIGSdb/issues/158#issuecomment-235537291","issue_url":"https://api.github.com/repos/kjolley/BIGSdb/issues/158","id":235537291,"user":{"login":"kjolley","id":7817395,"avatar_url":"https://avatars.githubusercontent.com/u/7817395?v=3","gravatar_id":"","url":"https://api.github.com/users/kjolley","html_url":"https://github.com/kjolley","followers_url":"https://api.github.com/users/kjolley/followers","following_url":"https://api.github.com/users/kjolley/following{/other_user}","gists_url":"https://api.github.com/users/kjolley/gists{/gist_id}","starred_url":"https://api.github.com/users/kjolley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kjolley/subscriptions","organizations_url":"https://api.github.com/users/kjolley/orgs","repos_url":"https://api.github.com/users/kjolley/repos","events_url":"https://api.github.com/users/kjolley/events{/privacy}","received_events_url":"https://api.github.com/users/kjolley/received_events","type":"User","site_admin":false},"created_at":"2016-07-27T09:39:36Z","updated_at":"2016-07-27T09:39:36Z","body":"Possibilities are to use:\r\nEAV, with separate tables for each data type (int, text, float etc.).\r\nExpand the use of meta tables which are already implemented. Currently these are associated with a set, but making them generally available across all records could work.\r\n"}}
{"actor":{"display_login":"kjolley"}}