NEWS.md

In nodbi: 'NoSQL' Database Connector

nodbi 0.9.8

• escaping newline character within a JSON value, in docdb_*() functions

nodbi 0.9.7

• changed docdb_update() to directly use ndjson from file for duckdb
• regression error from not specifying top-level jq script
• corrected and improve field selection in docdb_query()
• corrected test exceptions for mongodb, updated GitHub Actions, expanded tests
• changed docdb_update() to directly use ndjson from file for duckdb
• cleaned up unnecessary code in docdb_create()
• no more using transactions with src_duckdb()

nodbi 0.9.6

Bug fixes

• corrected marginal case in docdb_query.src_duckdb()
• corrected minimum R version
• replaced in tests httpbin with webfakes
• removed explicit UTF-8 encoding reference
• speed up in docdb_query()
• switched to v2 GitHub r-lib/action for R CMD check

nodbi 0.9.5

Changes

• replaced a dependency, gained speed

nodbi 0.9.4

Bug fixes

• fix initialisation in docdb_query() with src_duckdb()

nodbi 0.9.3

Changes

• docdb_update() now can do bulk updates when _id's are in value (for SQLite, DuckDB, PostgreSQL, MongoDB; not yet for CouchDB and Elastic)

Bug fixes

• fix tests for value parameter to be a file or an url

nodbi 0.9.2

Bug fixes

• src_duckdb() handles when json_type returns NULL for non-existing path
• src_sqlite() handles when text includes double quotation marks

Changes

• added warning if DuckDB's JSON extension is not available; improve instructions; see also issue #45
• minor simplification of docdb_exists() for src_mongo(), and of docdb_query() for SQL databases

nodbi 0.9.1

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

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

Changes

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

nodbi 0.8.0

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

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

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

Improvements

• full support for PostgreSQL (using jsonb)

Bug fixes

• for SQLite add closing file references also on exit

nodbi 0.5.1

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

Improvements

• identical API for docdb_*() functions so that query and fields parameters can be used across database backends
• identical return values across database backends
• 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
• 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

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)
• change testing approach

Bug fixes

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

nodbi 0.4.3

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

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

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

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)

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

New features

• docdb_get() gains limit parameter to do pagination, for CouchDB, Elasticsearch and MongoDB only (#17) (#23)
• gains function docdb_query() to send queries to each backend (#18) (#22)
• gains function docdb_exists() to check if a database or equivalent exists (#21) (#22)

Improvements

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

nodbi 0.1.0

New features

• released to CRAN

nodbi documentation built on Sept. 24, 2023, 1:08 a.m.