this demonstrates the use of a local SQLite database where you can store data and keep the variable type and perform database operations on. Also the data is read by R and data is written back into SQLite with R. The benefit is that the types of data will be better preserved than with CSV.
This is a companion discussion topic for the original entry at https://kni.me/w/TXkb0Dqco-l8mx95