Use dplyr::copy_to() to create multiple related tables

tidyverse
, ,
1

So it's possible to create a table in a database using dplyr::copy_to(), but wouldn't it be cool if instead of creating ONE table it could optionally create multiple related tables (if specified to do so by the user)?

For example, consider the following dataset:

image
image994×420 17.2 KB

If we wanted to convert this to a database schema, it probably makes more sense to convert this into two related tables:

image
image800×281 7.46 KB

which are linked together as such:
image

The fields could be mapped to one table or another using new inputs from the user, or by requiring a separate data.frame where the table-fields are mapped, or other hacky methods.

So I have two questions:

  1. Do you all think it's a good idea? To be able to engineer a database from R?
  2. Do you think dplyr is the correct place for this? or should I create a separate package for this functionality.
2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.