Package: readwritesqlite 0.2.0.9001

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.9001.tar.gz
readwritesqlite_0.2.0.9001.zip(r-4.5)readwritesqlite_0.2.0.9001.zip(r-4.4)readwritesqlite_0.2.0.9001.zip(r-4.3)
readwritesqlite_0.2.0.9001.tgz(r-4.4-any)readwritesqlite_0.2.0.9001.tgz(r-4.3-any)
readwritesqlite_0.2.0.9001.tar.gz(r-4.5-noble)readwritesqlite_0.2.0.9001.tar.gz(r-4.4-noble)
readwritesqlite_0.2.0.9001.tgz(r-4.4-emscripten)readwritesqlite_0.2.0.9001.tgz(r-4.3-emscripten)
readwritesqlite.pdf |readwritesqlite.html✨
readwritesqlite/json (API)
NEWS

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

Peer review:

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

Datasets:

On CRAN:

dbilogmetadataposixctreadsfcsqliteunitswrite

6.50 score 38 stars 11 scripts 234 downloads 27 exports 35 dependencies

Last updated 21 days agofrom:3410b25940. Checks:OK: 5 NOTE: 2. Indexed: yes.

TargetResultDate
Doc / VignettesOKNov 01 2024
R-4.5-winNOTENov 01 2024
R-4.5-linuxNOTENov 01 2024
R-4.4-winOKNov 01 2024
R-4.4-macOKNov 01 2024
R-4.3-winOKNov 01 2024
R-4.3-macOKNov 01 2024

Exports:check_sqlite_connectionchk_sqlite_connrws_close_connectionrws_connectrws_describe_metarws_disconnectrws_drop_tablerws_export_gpkgrws_list_tablesrws_open_connectionrws_queryrws_query_sqliterws_readrws_read_initrws_read_logrws_read_metarws_read_sqliterws_read_sqlite_initrws_read_sqlite_logrws_read_sqlite_metarws_read_sqlite_tablerws_read_tablerws_rename_columnrws_rename_tablerws_writerws_write_sqlitevld_sqlite_conn

Dependencies:bitbit64blobcachemchkclassclassIntclicpp11crayonDBIe1071fansifastmapgluehmsKernSmoothlifecyclemagrittrMASSmemoisepillarpkgconfigplogrproxyRcpprlangRSQLites2sftibbleunitsutf8vctrswk

Using readwritesqlite

Joe Thorley

Rendered fromusing-readwritesqlite.Rmdusingknitr::rmarkdownon Nov 01 2024.

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

Readme and manuals

Help Manual

Help pageTopics
Check SQLite Connectioncheck_sqlite_connection chk_sqlite_conn
Opens SQLite Database Connectionrws_connect rws_open_connection
Example Datarws_data
Add Descriptions to SQL Meta Data Tablerws_describe_meta
Add Descriptions to SQL Meta Data Tablerws_describe_meta.character
Add Data Frame of Descriptions to SQL Meta Data Tablerws_describe_meta.data.frame
Close SQLite Database Connectionrws_close_connection rws_disconnect
Drop SQLite Tablerws_drop_table
Export all spatial datasets in a database as geopackages.rws_export_gpkg
Table Namesrws_list_tables
Query SQLite Databaserws_query rws_query_sqlite
Read from a SQLite Databaserws_read rws_read_sqlite
Read Initialization Data table from a SQLite Databaserws_read_init rws_read_sqlite_init
Read Log Data Table from a SQLite Databaserws_read_log rws_read_sqlite_log
Read Meta Data table from a SQLite Databaserws_read_meta rws_read_sqlite_meta
Read a Table from a SQLite Databaserws_read_sqlite_table rws_read_table
Read Tables from a SQLite Databaserws_read.character
Read All Tables from a SQLite Databaserws_read.SQLiteConnection
Rename SQLite Columnrws_rename_column
Rename SQLite Tablerws_rename_table
Write to a SQLite Databaserws_write rws_write_sqlite
Write a Data Frame to a SQLite Databaserws_write.data.frame
Write the Data Frames in an Environment to a SQLite Databaserws_write.environment
Write a Named List of Data Frames to a SQLite Databaserws_write.list
Validate SQLite Connectionvld_sqlite_conn