nodbi (version 0.15.0)

src_mariadb: Setup a RMariaDB database connection

Description

Setup a RMariaDB database connection

Usage

src_mariadb(dbname = "test", ...)

Value

A nodbi source object

Arguments

dbname

(character) name of database file, defaults to ":memory:" for an in-memory database, see RMariaDB::MariaDB()

...

additional named parameters passed on to RMariaDB::MariaDB()

Details

Uses RSMariaDB as backend; requires MariaDB 12.3 or later. nodbi creates or uses a table with columns _id and json, created and used by package nodbi, applying SQL or JSON functions as per https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions 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. For a benchmark, see https://github.com/ropensci/nodbi#benchmark.

Examples

if (FALSE) {
con <- src_sqlite()
print(con)
}