{"action":"created","issue":{"url":"https://api.github.com/repos/ckan/ideas-and-roadmap/issues/143","labels_url":"https://api.github.com/repos/ckan/ideas-and-roadmap/issues/143/labels{/name}","comments_url":"https://api.github.com/repos/ckan/ideas-and-roadmap/issues/143/comments","events_url":"https://api.github.com/repos/ckan/ideas-and-roadmap/issues/143/events","html_url":"https://github.com/ckan/ideas-and-roadmap/issues/143","id":69250140,"number":143,"title":"extension: json datastore","user":{"login":"joetsoi","id":241130,"avatar_url":"https://avatars.githubusercontent.com/u/241130?v=3","gravatar_id":"","url":"https://api.github.com/users/joetsoi","html_url":"https://github.com/joetsoi","followers_url":"https://api.github.com/users/joetsoi/followers","following_url":"https://api.github.com/users/joetsoi/following{/other_user}","gists_url":"https://api.github.com/users/joetsoi/gists{/gist_id}","starred_url":"https://api.github.com/users/joetsoi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joetsoi/subscriptions","organizations_url":"https://api.github.com/users/joetsoi/orgs","repos_url":"https://api.github.com/users/joetsoi/repos","events_url":"https://api.github.com/users/joetsoi/events{/privacy}","received_events_url":"https://api.github.com/users/joetsoi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"joetsoi","id":241130,"avatar_url":"https://avatars.githubusercontent.com/u/241130?v=3","gravatar_id":"","url":"https://api.github.com/users/joetsoi","html_url":"https://github.com/joetsoi","followers_url":"https://api.github.com/users/joetsoi/followers","following_url":"https://api.github.com/users/joetsoi/following{/other_user}","gists_url":"https://api.github.com/users/joetsoi/gists{/gist_id}","starred_url":"https://api.github.com/users/joetsoi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joetsoi/subscriptions","organizations_url":"https://api.github.com/users/joetsoi/orgs","repos_url":"https://api.github.com/users/joetsoi/repos","events_url":"https://api.github.com/users/joetsoi/events{/privacy}","received_events_url":"https://api.github.com/users/joetsoi/received_events","type":"User","site_admin":false},"milestone":null,"comments":3,"created_at":"2015-04-18T01:14:54Z","updated_at":"2015-07-09T16:02:16Z","closed_at":null,"body":"https://github.com/joetsoi/ckanext-jsondatastore\r\n\r\nThis is an extension that I've wanted to work on for a long time. I haven't done more than test that it's possible. I'd like to replace the datastore, because I hate it (that's a lie, hate is a strong word), with a json based datastore using a postgres jsonb field for storage. This allows more flexibility and we don't need to care so much about data types when importing.\r\n\r\ncsv files are generally a bit rubbish when detecting field types, numeric, datetime and it often gets it wrong. Basically because csv files are 'weakly typed' as it were and a database is 'strongly type' (by whcih I mean you have to specify exact data types). With a json datastore, we don't need to care and we can leave the concerns of datatype to the user of the datastore because our datatypes will be a more flexible json format\r\n\r\nThis also would full fill the wishes of people who want a hipster nosql datastore, because jsonb is even more hipster.\r\n\r\n(bonus wish, not to use raw sql, but to provide an equivalent api that allows the functionality of any sql query people wish. Mainly because raw sql keeps me awake at night."},"comment":{"url":"https://api.github.com/repos/ckan/ideas-and-roadmap/issues/comments/120049503","html_url":"https://github.com/ckan/ideas-and-roadmap/issues/143#issuecomment-120049503","issue_url":"https://api.github.com/repos/ckan/ideas-and-roadmap/issues/143","id":120049503,"user":{"login":"wardi","id":153258,"avatar_url":"https://avatars.githubusercontent.com/u/153258?v=3","gravatar_id":"","url":"https://api.github.com/users/wardi","html_url":"https://github.com/wardi","followers_url":"https://api.github.com/users/wardi/followers","following_url":"https://api.github.com/users/wardi/following{/other_user}","gists_url":"https://api.github.com/users/wardi/gists{/gist_id}","starred_url":"https://api.github.com/users/wardi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wardi/subscriptions","organizations_url":"https://api.github.com/users/wardi/orgs","repos_url":"https://api.github.com/users/wardi/repos","events_url":"https://api.github.com/users/wardi/events{/privacy}","received_events_url":"https://api.github.com/users/wardi/received_events","type":"User","site_admin":false},"created_at":"2015-07-09T16:02:16Z","updated_at":"2015-07-09T16:02:16Z","body":"I'd also like a pyspark datastore. :-)"}}