Enhanced Reading and Writing for 'SQLite' Databases
Check SQLite Connection
readwritesqlite: Enhanced Reading and Writing for 'SQLite' Databases
Opens SQLite Database Connection
Add Descriptions to SQL Meta Data Table
Add Data Frame of Descriptions to SQL Meta Data Table
Add Descriptions to SQL Meta Data Table
Close SQLite Database Connection
Drop SQLite Table
Export all spatial datasets in a database as geopackages.
Table Names
Query SQLite Database
Read Tables from a SQLite Database
Read from a SQLite Database
Read All Tables from a SQLite Database
Read Initialization Data table from a SQLite Database
Read Log Data Table from a SQLite Database
Read Meta Data table from a SQLite Database
Read a Table from a SQLite Database
Rename SQLite Column
Rename SQLite Table
Write a Data Frame to a SQLite Database
Write the Data Frames in an Environment to a SQLite Database
Write a Named List of Data Frames to a SQLite Database
Write to a SQLite Database
Validate SQLite Connection
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.
Useful links