{"action":"created","issue":{"url":"https://api.github.com/repos/rstats-db/RSQLite/issues/74","repository_url":"https://api.github.com/repos/rstats-db/RSQLite","labels_url":"https://api.github.com/repos/rstats-db/RSQLite/issues/74/labels{/name}","comments_url":"https://api.github.com/repos/rstats-db/RSQLite/issues/74/comments","events_url":"https://api.github.com/repos/rstats-db/RSQLite/issues/74/events","html_url":"https://github.com/rstats-db/RSQLite/issues/74","id":56128740,"number":74,"title":"Strategy for type inference and manual coercion","user":{"login":"hadley","id":4196,"avatar_url":"https://avatars.githubusercontent.com/u/4196?v=3","gravatar_id":"","url":"https://api.github.com/users/hadley","html_url":"https://github.com/hadley","followers_url":"https://api.github.com/users/hadley/followers","following_url":"https://api.github.com/users/hadley/following{/other_user}","gists_url":"https://api.github.com/users/hadley/gists{/gist_id}","starred_url":"https://api.github.com/users/hadley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hadley/subscriptions","organizations_url":"https://api.github.com/users/hadley/orgs","repos_url":"https://api.github.com/users/hadley/repos","events_url":"https://api.github.com/users/hadley/events{/privacy}","received_events_url":"https://api.github.com/users/hadley/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/rstats-db/RSQLite/milestones/3","html_url":"https://github.com/rstats-db/RSQLite/milestones/1.1","labels_url":"https://api.github.com/repos/rstats-db/RSQLite/milestones/3/labels","id":1868599,"number":3,"title":"1.1","description":"Intermediate release with updated SQLite and DBI compatibility","creator":{"login":"krlmlr","id":1741643,"avatar_url":"https://avatars.githubusercontent.com/u/1741643?v=3","gravatar_id":"","url":"https://api.github.com/users/krlmlr","html_url":"https://github.com/krlmlr","followers_url":"https://api.github.com/users/krlmlr/followers","following_url":"https://api.github.com/users/krlmlr/following{/other_user}","gists_url":"https://api.github.com/users/krlmlr/gists{/gist_id}","starred_url":"https://api.github.com/users/krlmlr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/krlmlr/subscriptions","organizations_url":"https://api.github.com/users/krlmlr/orgs","repos_url":"https://api.github.com/users/krlmlr/repos","events_url":"https://api.github.com/users/krlmlr/events{/privacy}","received_events_url":"https://api.github.com/users/krlmlr/received_events","type":"User","site_admin":false},"open_issues":6,"closed_issues":10,"state":"open","created_at":"2016-07-06T21:10:17Z","updated_at":"2016-09-01T15:59:42Z","due_on":null,"closed_at":null},"comments":7,"created_at":"2015-01-31T15:43:37Z","updated_at":"2016-09-01T16:07:58Z","closed_at":null,"body":"`dbFetch()` and `dbGetQuery()` need to have optional coercion object. Should be named list, and provide common converters (e.g. times to number of seconds, dates to days, factors to strings, binary serialisation (default for list, raw should stay as is) etc, bool<->int for sqllite). \r\n\r\nDefaults only need to work with atomic vectors.\r\n"},"comment":{"url":"https://api.github.com/repos/rstats-db/RSQLite/issues/comments/244128955","html_url":"https://github.com/rstats-db/RSQLite/issues/74#issuecomment-244128955","issue_url":"https://api.github.com/repos/rstats-db/RSQLite/issues/74","id":244128955,"user":{"login":"krlmlr","id":1741643,"avatar_url":"https://avatars.githubusercontent.com/u/1741643?v=3","gravatar_id":"","url":"https://api.github.com/users/krlmlr","html_url":"https://github.com/krlmlr","followers_url":"https://api.github.com/users/krlmlr/followers","following_url":"https://api.github.com/users/krlmlr/following{/other_user}","gists_url":"https://api.github.com/users/krlmlr/gists{/gist_id}","starred_url":"https://api.github.com/users/krlmlr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/krlmlr/subscriptions","organizations_url":"https://api.github.com/users/krlmlr/orgs","repos_url":"https://api.github.com/users/krlmlr/repos","events_url":"https://api.github.com/users/krlmlr/events{/privacy}","received_events_url":"https://api.github.com/users/krlmlr/received_events","type":"User","site_admin":false},"created_at":"2016-09-01T16:07:58Z","updated_at":"2016-09-01T16:07:58Z","body":"It seems to occur fairly often that the column type is declared as character. We can't rely on the affinity as start value.\r\n\r\nTherefore:\r\n\r\n- Each dbFetch() call is allowed to return different column types\r\n- An unspecified column type is used on start\r\n- Columns get coerced to fit all data values (int -> character, time -> character)\r\n- Only if all columns were NULL, the column affinity is used"}}
{"actor":{"display_login":"krlmlr"}}