Skip to contents

nodbi 0.9.1.9000

BUG FIXES

  • src_duckdb(): handle when json_type returns NULL for non-existing path (2023-02-18)

Changes

  • added warning if DuckDB’s JSON extension is not available; see also issue #45
  • minor simplification of docdb_exists() for src_mongo()

nodbi 0.9.1

CRAN release: 2022-11-20

Changes

  • corrected closing connections to SQL database backends upon session restart
  • improved provisions for parallel write access and corresponding tests
  • capture marginal case of no rows in docdb_query()

nodbi 0.9.0

CRAN release: 2022-10-31

Changes

  • adding support for duckdb (R package version 0.6.0 or higher) as database backend
  • suppressed warnings when checking if a string points to a file

nodbi 0.8.1

CRAN release: 2022-07-01

Changes

  • replaced isa() as not available with R version 3.x

nodbi 0.8.0

CRAN release: 2022-06-12

Changes

  • refactored docdb_update.src_couchdb to use jqr
  • adapted docdb_create to accept jsonlite, jsonify, jqr JSON
  • added details to README
  • testing (unset LANG, relocate open code, better cleaning up)

nodbi 0.7.1

CRAN release: 2022-05-04

BUG FIXES

  • fixed docdb_query to account for change in SQLite 3.38.3 adding quotation of labels (closes issue #44), test added
  • made docdb_query work for PostgreSQL when a string used with the $in operator has a comma(s), test added

nodbi 0.7.0

CRAN release: 2022-01-04

IMPROVEMENTS

  • docdb_create now supports file names and http urls as argument value for importing data
  • docdb_create (and thus docdb_update) now supports quantifiers (e.g., ‘[a-z]{2,3}’) in regular expressions

BUG FIXES

  • for SQLite, return FALSE like other backends when using docdb_delete for a non-existing container (table, in the case of SQLite)
  • better handle special characters and encodings under Windows

nodbi 0.6.0

CRAN release: 2021-12-01

IMPROVEMENTS

  • full support for PostgreSQL (using jsonb)

BUG FIXES

  • for SQLite add closing file references also on exit

nodbi 0.5.1

CRAN release: 2021-11-26

BUG FIXES

  • for SQLite under Windows ensure handling of special characters (avoiding encoding conversions with file operations that stream out / in NDJSON)

nodbi 0.5.0

CRAN release: 2021-11-21

IMPROVEMENTS

  • identical API for docdb_*() functions so that query and fields parameters can be used across database backends
  • identical return values across database backends

UNDER THE HOOD

  • re-factored recently added functions for RSQLite
  • re-factored most functions to provide identical API
  • performance (timing and memory use) profiled and optimised as far as possible

OTHER CHANGES

  • testing now uses the same test file across databases
  • currently, no more support for redis (no way was found to query and update specific documents in a container)
  • docdb_list() added as function to list container in database

NOTES

  • Support for complex queries not yet implemented for Elasticsearch
  • Only root fields (no subitems) returned by Elasticsearch and CouchDB

nodbi 0.4.4

MINOR IMPROVEMENTS

  • made remaining docdb_*() functions return a logical indicating the success of the function (docdb_create, docdb_delete), or a data frame (docdb_get, docdb_query), or the number of documents affected by the function (docdb_update)

BUG FIXES

  • docdb_get() to not return ’_id’ field for src_{sqlite,mongo} since already used for row names

OTHER

  • change testing approach

nodbi 0.4.3

CRAN release: 2021-07-23

MINOR IMPROVEMENTS

  • docdb_query.src_sqlite() now handles JSON objects, returning nested lists (#40)
  • src_sqlite() now uses transactions for relevant functions (#39)
  • docdb_update.src_mongo() now returns the number of upserted or matched documents, irrespective of whether they were updated or not

BUG FIXES

  • docdb_get() to not return ’_id’ field for src_{sqlite,mongo} since already used for row names

OTHER

  • change of maintainer agreed

nodbi 0.4.2

CRAN release: 2021-01-14

BUG FIXES

  • fix for src_couchdb(): we were not setting user and password correctly internally, was causing issues in CouchDB v3 (#35) thanks to @drtagkim for the pull request

nodbi 0.4.0

CRAN release: 2019-11-11

MINOR IMPROVEMENTS

  • in docdb_query() and docdb_get(), for sqlite source, use a connection instead of a regular file path to avoid certain errors on Windows (#33) work by @rfhb
  • in docdb_query() and docdb_create() for sqlite source, fix to handle mixed values of different types (#34) work by @rfhb
  • some Sys.sleep’s added to Elasticserch eg’s to make sure data is available after creation, and before a data request

nodbi 0.3.0

CRAN release: 2019-09-18

NEW FEATURES

  • new author Ralf Herold, with contribution of new functions for working with SQLite/json1. new functions: src_sqlite, print.src_sqlite, docdb_create.src_sqlite, docdb_delete.src_sqlite, docdb_exists.src_sqlite, docdb_get.src_sqlite, docdb_query.src_sqlite, and docdb_update.src_sqlite. includes new dataset contacts (#25) (#27) (#28) (#29) (#30) (#31)
  • docdb_update gains method for working with MongoDB, via (#27)

MINOR IMPROVEMENTS

  • added .github files in the source repository to facilitate contributions
  • src_mongo changes, improved behavior, via (#27)

DEFUNCT

  • etcd (via the etseed package) integration has been removed from this package as etcd doesn’t really fit the main goal of the pkg. functions now defunct are: src_etcd, docdb_create.src_etcd, docdb_delete.src_etcd, docdb_exists.src_etcd, docdb_get.src_etcd, and print.src_etcd (#26)

nodbi 0.2.0

CRAN release: 2019-04-13

NEW FEATURES

MINOR IMPROVEMENTS

  • Updated package for new version of elastic, which has slightly different setup for connecting to the Elasticsearch instance (#20)

nodbi 0.1.0

CRAN release: 2018-08-01

NEW FEATURES

  • released to CRAN