Archive and Unarchive Databases Using Flat Files
Archive tables from a database as flat files
delete the local arkdb database
arkdb: Archive and Unarchive Databases Using Flat Files
Disconnect from the arkdb database.
Connect to a local stand-alone database
process a table in chunks
streamable csv using base R functions
streamable tsv using base R functions
streamable chunked parquet using arrow
streamable csv using readr
streamable tsv using readr
streamable table
streamable tables using vroom
Unarchive a list of compressed tsv files into a database
Flat text files provide a robust, compressible, and portable way to store tables from databases. 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.
Useful links