{"action":"created","issue":{"url":"https://api.github.com/repos/beanumber/etl/issues/12","labels_url":"https://api.github.com/repos/beanumber/etl/issues/12/labels{/name}","comments_url":"https://api.github.com/repos/beanumber/etl/issues/12/comments","events_url":"https://api.github.com/repos/beanumber/etl/issues/12/events","html_url":"https://github.com/beanumber/etl/issues/12","id":120785926,"number":12,"title":"write etl_load_side() methods for MySQL and PostgreSQL","user":{"login":"beanumber","id":2774211,"avatar_url":"https://avatars.githubusercontent.com/u/2774211?v=3","gravatar_id":"","url":"https://api.github.com/users/beanumber","html_url":"https://github.com/beanumber","followers_url":"https://api.github.com/users/beanumber/followers","following_url":"https://api.github.com/users/beanumber/following{/other_user}","gists_url":"https://api.github.com/users/beanumber/gists{/gist_id}","starred_url":"https://api.github.com/users/beanumber/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beanumber/subscriptions","organizations_url":"https://api.github.com/users/beanumber/orgs","repos_url":"https://api.github.com/users/beanumber/repos","events_url":"https://api.github.com/users/beanumber/events{/privacy}","received_events_url":"https://api.github.com/users/beanumber/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/beanumber/etl/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":{"login":"beanumber","id":2774211,"avatar_url":"https://avatars.githubusercontent.com/u/2774211?v=3","gravatar_id":"","url":"https://api.github.com/users/beanumber","html_url":"https://github.com/beanumber","followers_url":"https://api.github.com/users/beanumber/followers","following_url":"https://api.github.com/users/beanumber/following{/other_user}","gists_url":"https://api.github.com/users/beanumber/gists{/gist_id}","starred_url":"https://api.github.com/users/beanumber/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beanumber/subscriptions","organizations_url":"https://api.github.com/users/beanumber/orgs","repos_url":"https://api.github.com/users/beanumber/repos","events_url":"https://api.github.com/users/beanumber/events{/privacy}","received_events_url":"https://api.github.com/users/beanumber/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2015-12-07T14:31:53Z","updated_at":"2015-12-09T02:17:01Z","closed_at":null,"body":"Using `DBI::dbWriteTable()` requires that the data that you push to the RDBMS be in memory in R. This is fine for most things, since you already have the data in memory. But here, we might have the data in CSVs that we just want to pump directly into the RDBMS, and R really needn't be involved. The right way to do this is with `LOAD DATA INFILE ...`, which should be way faster. \r\n\r\nSo write a method called `etl_load_side.src_mysql()` that will replace `dbWriteTable()` with `dbSendQuery(\"LOAD DATA INFILE ...\")`. "},"comment":{"url":"https://api.github.com/repos/beanumber/etl/issues/comments/163085261","html_url":"https://github.com/beanumber/etl/issues/12#issuecomment-163085261","issue_url":"https://api.github.com/repos/beanumber/etl/issues/12","id":163085261,"user":{"login":"beanumber","id":2774211,"avatar_url":"https://avatars.githubusercontent.com/u/2774211?v=3","gravatar_id":"","url":"https://api.github.com/users/beanumber","html_url":"https://github.com/beanumber","followers_url":"https://api.github.com/users/beanumber/followers","following_url":"https://api.github.com/users/beanumber/following{/other_user}","gists_url":"https://api.github.com/users/beanumber/gists{/gist_id}","starred_url":"https://api.github.com/users/beanumber/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beanumber/subscriptions","organizations_url":"https://api.github.com/users/beanumber/orgs","repos_url":"https://api.github.com/users/beanumber/repos","events_url":"https://api.github.com/users/beanumber/events{/privacy}","received_events_url":"https://api.github.com/users/beanumber/received_events","type":"User","site_admin":false},"created_at":"2015-12-09T02:17:01Z","updated_at":"2015-12-09T02:17:01Z","body":"Upon further review, it looks like this functionality [already exists for MySQL](https://github.com/rstats-db/RMySQL/blob/master/R/table.R#L185)"}}