Package: RSQLite.toolkit 0.1.2.9030
RSQLite.toolkit: Load Data in SQLite from Tabular Files
A lightweight wrapper around the 'RSQLite' package for streamlined loading of data from tabular files (i,e. text delimited files like Comma Separated Values and Tab Separated Values, Microsoft Excel, and Arrow Inter-process Communication files) in 'SQLite' databases. Includes helper functions for inspecting the structure of the input files, and some functions to simplify activities on the 'SQLite' tables.
Authors:
RSQLite.toolkit_0.1.2.9030.tar.gz
RSQLite.toolkit_0.1.2.9030.zip(r-4.7)RSQLite.toolkit_0.1.2.9030.zip(r-4.6)RSQLite.toolkit_0.1.2.9030.zip(r-4.5)
RSQLite.toolkit_0.1.2.9030.tgz(r-4.6-any)RSQLite.toolkit_0.1.2.9030.tgz(r-4.5-any)
RSQLite.toolkit_0.1.2.9030.tar.gz(r-4.7-any)RSQLite.toolkit_0.1.2.9030.tar.gz(r-4.6-any)
RSQLite.toolkit_0.1.2.9030.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
RSQLite.toolkit/json (API)
NEWS
| # Install 'RSQLite.toolkit' in R: |
| install.packages('RSQLite.toolkit', repos = c('https://fab-algo.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/fab-algo/rsqlite.toolkit/issues
Pkgdown/docs site:https://fab-algo.github.io
Last updated from:b3113ff512. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | OK | 143 | ||
| source / vignettes | OK | 188 | ||
| linux-release-x86_64 | OK | 142 | ||
| macos-release-arm64 | OK | 94 | ||
| macos-oldrel-arm64 | OK | 92 | ||
| windows-devel | OK | 107 | ||
| windows-release | OK | 81 | ||
| windows-oldrel | OK | 100 | ||
| wasm-release | OK | 112 |
Exports:dbCopyTabledbCreatePKdbExecFiledbTableFromDataFramedbTableFromDSVdbTableFromFeatherdbTableFromViewdbTableFromXlsxfile_schema_dsvfile_schema_featherfile_schema_xlsxformat_column_namesR2SQL_types
Dependencies:arrowassertthatbitbit64blobcachemclicpp11DBIfastmapgluelifecyclemagrittrmemoiseopenxlsx2pkgconfigpurrrR6RcpprlangRSQLitestringitidyselectvctrswithr
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Copy a table from one SQLite database to another | dbCopyTable |
| Creates a unique index on a table in a SQLite database | dbCreatePK |
| Execute SQL statements from a text file | dbExecFile |
| Create a table in a SQLite database from a data frame | dbTableFromDataFrame |
| Create a table from a delimiter separated values (DSV) text file | dbTableFromDSV |
| Create a table from a Feather (Arrow IPC) file | dbTableFromFeather |
| Create a table in a SQLite database from a view | dbTableFromView |
| Create a table in a SQLite database from an Excel worksheet | dbTableFromXlsx |
| error_handler manage error messages for package | error_handler |
| Preview the table structure contained in a DSV file. | file_schema_dsv |
| Preview the table structure contained in a Feather file. | file_schema_feather |
| Preview the structure of a range of an Excel worksheet. | file_schema_xlsx |
| Format column names for SQLite | format_column_names |
| From R class names to SQLite data types | R2SQL_types |
