Database connection to EcoTaxa — db_connect

Connect to and disconnect from the EcoTaxa database (in read-only mode).

db_connect_ecotaxa()

db_disconnect_ecotaxa(x)

src_ecotaxa()

db_disconnect(x)

Arguments

x	a database connection created by `db_connect_ecotaxa()`.

Value

An object of class RPostgreSQL::PostgreSQLConnection-class().

Examples

db <- db_connect_ecotaxa()
db
#> tbls: __part_histopart_reduit_system_0_6234110810072827, __part_histopart_reduit_system_time_1000, acquisitions, alembic_version, block_for_obj_head, collection, collection_orga_role, collection_project, collection_user_role, countrylist, dbplyr_001, dbplyr_002, images, obj_cnn_features, obj_field, obj_head, obj_path, objectsclassifhisto, part_ctd, part_histocat, part_histocat_lst, part_histopart_det, part_histopart_reduit, part_projects, part_samples, persistantdatatable, process, projects, projects_taxo_stat, projectspriv, roles, samples, taxonomy, temp_tasks, temp_taxo, tmp_acq_proc, user_preferences, users, users_roles, worms
db_disconnect_ecotaxa(db)
#> [1] TRUE
# NB: always disconnect after use. Leaving open connections clobbers the server