Setup a PostgreSQL database connection
Arguments
- dbname
(character) name of database, has to exist to open a connection
- host
(character) host of the database, see
RPostgres::Postgres()
- port
(integer) port of the database, see
RPostgres::Postgres()
- ...
additional named parameters passed on to
RPostgres::Postgres()
Details
Uses RPostgres as backend. nodbi creates or uses
a PostgreSQL table, with columns _id
and json
created and used
by package nodbi
, applying SQL functions as per
https://www.postgresql.org/docs/current/functions-json.html
to the json
column.
Each row in the table represents a JSON
document.
Any root-level _id
is extracted from the document(s) and used
for column _id
, otherwise a UUID is created as _id
.
The table is indexed on _id
. A custom plpgsql
function
jsonb_merge_patch()
is used for docdb_update()
.
The order of variables in data frames returned by docdb_get()
and docdb_query()
can differ from their order the input to
docdb_create()
.
For a benchmark, see https://github.com/ropensci/nodbi#benchmark
Examples
if (FALSE) { # \dontrun{
con <- src_postgres()
print(con)
} # }