Package: readwritesqlite 0.2.0.9039

Joe Thorley

readwritesqlite: Enhanced Reading and Writing for 'SQLite' Databases

Reads and writes data frames to 'SQLite' databases while preserving time zones (for POSIXct columns), projections (for 'sfc' columns), units (for 'units' columns), levels (for factors and ordered factors) and classes for logical, Date and 'hms' columns. It also logs changes to tables and provides more informative error messages.

Authors:Joe Thorley [aut, cre], Sebastian Dalgarno [ctb], Poisson Consulting [cph, fnd]

readwritesqlite_0.2.0.9039.tar.gz
readwritesqlite_0.2.0.9039.zip(r-4.7)readwritesqlite_0.2.0.9039.zip(r-4.6)readwritesqlite_0.2.0.9039.zip(r-4.5)
readwritesqlite_0.2.0.9039.tgz(r-4.6-any)readwritesqlite_0.2.0.9039.tgz(r-4.5-any)
readwritesqlite_0.2.0.9039.tar.gz(r-4.7-any)readwritesqlite_0.2.0.9039.tar.gz(r-4.6-any)
readwritesqlite_0.2.0.9039.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
readwritesqlite/json (API)

# Install 'readwritesqlite' in R:

install.packages('readwritesqlite', repos = c('https://poissonconsulting.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/poissonconsulting/readwritesqlite/issues

Pkgdown/docs site:https://poissonconsulting.github.io

Datasets:

rws_data - Example Data

On CRAN:

dbi log metadata posixct read sfc sqlite units write

7.26 score 39 stars 2 packages 13 scripts 52 downloads 27 exports 33 dependencies

Last updated from:c0ebd3b5d9. Checks:9 OK. Indexed: yes.

Target	Result	Time
linux-devel-x86_64	OK	189
source / vignettes	OK	191
linux-release-x86_64	OK	206
macos-release-arm64	OK	141
macos-oldrel-arm64	OK	117
windows-devel	OK	156
windows-release	OK	135
windows-oldrel	OK	167
wasm-release	OK	131

Exports:check_sqlite_connection chk_sqlite_conn rws_close_connection rws_connect rws_describe_meta rws_disconnect rws_drop_table rws_export_gpkg rws_list_tables rws_open_connection rws_query rws_query_sqlite rws_read rws_read_init rws_read_log rws_read_meta rws_read_sqlite rws_read_sqlite_init rws_read_sqlite_log rws_read_sqlite_meta rws_read_sqlite_table rws_read_table rws_rename_column rws_rename_table rws_write rws_write_sqlite vld_sqlite_conn

Dependencies:bit bit64 blob cachem chk class classInt cli cpp11 crayon DBI e1071 fastmap glue hms KernSmooth lifecycle magrittr MASS memoise pillar pkgconfig proxy Rcpp rlang RSQLite s2 sf tibble units utf8 vctrs wk

Using readwritesqlite

Rendered fromusing-readwritesqlite.Rmdusingknitr::rmarkdown

Last update: 2019-07-07
Started: 2018-12-10

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Check SQLite Connection	check_sqlite_connection chk_sqlite_conn
Opens SQLite Database Connection	rws_connect rws_open_connection
Example Data	rws_data
Add Descriptions to SQL Meta Data Table	rws_describe_meta
Add Descriptions to SQL Meta Data Table	rws_describe_meta.character
Add Data Frame of Descriptions to SQL Meta Data Table	rws_describe_meta.data.frame
Close SQLite Database Connection	rws_close_connection rws_disconnect
Drop SQLite Table	rws_drop_table
Export all spatial datasets in a database as geopackages.	rws_export_gpkg
Table Names	rws_list_tables
Query SQLite Database	rws_query rws_query_sqlite
Read from a SQLite Database	rws_read rws_read_sqlite
Read Initialization Data table from a SQLite Database	rws_read_init rws_read_sqlite_init
Read Log Data Table from a SQLite Database	rws_read_log rws_read_sqlite_log
Read Meta Data table from a SQLite Database	rws_read_meta rws_read_sqlite_meta
Read a Table from a SQLite Database	rws_read_sqlite_table rws_read_table
Read Tables from a SQLite Database	rws_read.character
Read All Tables from a SQLite Database	rws_read.SQLiteConnection
Rename SQLite Column	rws_rename_column
Rename SQLite Table	rws_rename_table
Write to a SQLite Database	rws_write rws_write_sqlite
Write a Data Frame to a SQLite Database	rws_write.data.frame
Write the Data Frames in an Environment to a SQLite Database	rws_write.environment
Write a Named List of Data Frames to a SQLite Database	rws_write.list
Validate SQLite Connection	vld_sqlite_conn