Package index • readwritesqlite

Connection

Open, Close or Check SQLite Connection

chk_sqlite_conn() check_sqlite_connection(): Check SQLite Connection

rws_connect(): Opens SQLite Database Connection

rws_disconnect(): Close SQLite Database Connection

vld_sqlite_conn(): Validate SQLite Connection

Edit

Edit SQLite Database

rws_describe_meta(): Add Descriptions to SQL Meta Data Table

rws_describe_meta(<character>): Add Descriptions to SQL Meta Data Table

rws_describe_meta(<data.frame>): Add Data Frame of Descriptions to SQL Meta Data Table

rws_drop_table(): Drop SQLite Table

rws_rename_column(): Rename SQLite Column

rws_rename_table(): Rename SQLite Table

rws_write(): Write to a SQLite Database

rws_write(<data.frame>): Write a Data Frame to a SQLite Database

rws_write(<environment>): Write the Data Frames in an Environment to a SQLite Database

rws_write(<list>): Write a Named List of Data Frames to a SQLite Database

Read

Read SQLite Database

rws_data: Example Data

rws_list_tables(): Table Names

rws_query(): Query SQLite Database

rws_read(): Read from a SQLite Database

rws_read(<SQLiteConnection>): Read All Tables from a SQLite Database

rws_read(<character>): Read Tables from a SQLite Database

rws_read_init(): Read Initialization Data table from a SQLite Database

rws_read_log(): Read Log Data Table from a SQLite Database

rws_read_meta(): Read Meta Data table from a SQLite Database

rws_read_table(): Read a Table from a SQLite Database

Export

Export spatial data from SQLite Database

rws_export_gpkg(): Export all spatial datasets in a database as geopackages.