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.