Flat text files provide a more robust, compressible, and portable way to store tables. This package provides convenient functions for exporting tables from relational database connections into compressed text files and streaming those text files back into a database without requiring the whole table to fit in working memory.
Details
It has two functions:
ark()
: archive a database into flat files, chunk by chunk.unark()
: Unarchive flat files back int a database connection.
arkdb will work with any DBI
supported connection. This makes it
a convenient and robust way to migrate between different databases
as well.
Author
Maintainer: Carl Boettiger cboettig@gmail.com (ORCID) [copyright holder]
Other contributors:
Richard FitzJohn [contributor]
Brandon Bertelsen brandon@bertelsen.ca [contributor]