The goal of dabr is to provide functions to manage databases: select, update, insert, and delete records, list tables, backup tables as CSV files, and import CSV files as tables.
You can install the released version of dabr from CRAN with:
And the development version from GitHub with:
Connecting to the Reading Palaeofire Database (RPD), locally installed under the name RPD-latest:
conn <- dabr::open_conn_mysql("RPD-latest",
password = rstudioapi::askForPassword(prompt = "Password"))Explore the database structure by listing the tables and their attributes:
dabr::list_tables(conn)
#>
#>
#> |age_model |
#> |:---------|
#> |ID_MODEL |
#> |ID_SAMPLE |
#> |mean |
#> |median |
#> |UNCERT_5 |
#> |UNCERT_25 |
#> |UNCERT_75 |
#> |UNCERT_95 |
#>
#>
#> |chronology |
#> |:----------------|
#> |ID_MODEL |
#> |ID_SAMPLE |
#> |original_est_age |
#>
#>
#> |date_info |
#> |:----------------|
#> |ID_ENTITY |
#> |ID_DATE_INFO |
#> |material_dated |
#> |date_type |
#> |avg_depth |
#> |thickness |
#> |lab_number |
#> |age_C14 |
#> |age_calib |
#> |error |
#> |correlation_info |
#> |age_used |
#> |reason_age_used |
#> |notes |
#>
#>
#> |DELETE_charcoal |
#> |:---------------|
#> |ID_SAMPLE |
#> |quantity |
#> |sample_size |
#>
#>
#> |DELETE_chronology |
#> |:------------------|
#> |ID_SAMPLE |
#> |original_age_model |
#> |original_est_age |
#> |BACON_INTCAL13_age |
#> |UNCERT_5 |
#> |UNCERT_25 |
#> |UNCERT_75 |
#> |UNCERT_95 |
#>
#>
#> |entity |
#> |:--------------------|
#> |ID_SITE |
#> |ID_ENTITY |
#> |entity_name |
#> |latitude |
#> |longitude |
#> |elevation |
#> |depositional_context |
#> |measurement_method |
#> |TYPE |
#> |source |
#> |core_location |
#> |last_updated |
#> |ID_UNIT |
#>
#>
#> |entity_link_pub |
#> |:---------------|
#> |ID_ENTITY |
#> |ID_PUB |
#>
#>
#> |model_name |
#> |:----------|
#> |ID_MODEL |
#> |model_name |
#>
#>
#> |pub |
#> |:-----------|
#> |ID_PUB |
#> |citation |
#> |pub_DOI_URL |
#>
#>
#> |sample |
#> |:------------------------|
#> |ID_ENTITY |
#> |ID_SAMPLE |
#> |avg_depth |
#> |depth_top |
#> |depth_bottom |
#> |sample_thickness |
#> |charcoal_measurement |
#> |analytical_sample_volume |
#>
#>
#> |site |
#> |:----------------|
#> |ID_SITE |
#> |site_name |
#> |latitude |
#> |longitude |
#> |elevation |
#> |site_type |
#> |water_depth |
#> |basin_size_class |
#> |catch_size_class |
#> |flow_type |
#> |basin_size_km2 |
#> |catch_size_km2 |
#>
#>
#> |unit |
#> |:-------|
#> |ID_UNIT |
#> |UNIT |ALWAYS! close your connection to the database (when you are done):