NEWS.md

In RSQLite.toolkit: Load Data in SQLite from Tabular Files

RSQLite.toolkit 0.1.4

• Using the piggyback package in the vignette "Dealing with DSV files" caused an "API rate limit exceeded" error when accessing the examples files stored in a GitHub repository. To avoid this problem, the code has been modified implementing a function that downloads the files from their static URL.

RSQLite.toolkit 0.1.3

• Fixed bug in file_schema_dsv() and dbTableFromDSV() when \x1A character is present in the DSV file.
• Fixed bug when dbTableFromDSV() is called with skip > 0 among the parameters passed to scan.
• Fixed bug in dbExecFile() when quoted strings in SQL files were more then 9 elements.
• Added support for reading a group of lines of length nlines from the DSV file by chunk_size blocks.
• It is now possible to combine the skip, nlines and chunk_size parameters to read a specific portion of the DSV file.
• Added support for automatic conversion of percentage numbers (i.e. numeric strings ending with %) in DSV files.
• In function file_schema_dsv() added the all_na column to the schema of the DSV file, which indicates whether all values in a column are NA.
• Minor improvements to documentation.

RSQLite.toolkit 0.1.2

• Fixed bug in dbExecFile(): it now supports quoting marks inside quoted strings.

RSQLite.toolkit 0.1.1

• Initial release.

RSQLite.toolkit documentation built on Sept. 2, 2026, 9:06 a.m.