Databases

[sckott]

Last updated on 2022-06-26 (@rfhb):

• [x] Mongodb - @jeroen
• [x] CouchDB - @sckott
• [x] Elasticsearch - @sckott
• [x] SQLite - @rfhb (from 0.3.0)
• [x] PostgreSQL - @rfhb (from 0.6.0)
• [ ] Duckdb - @rfhb (planned for 2022)
• [ ] Redis - richfitz (removed 2021, could not work on docs)
• [ ] Etcd - rich
• [ ] Riak - sckott (pulling out for now - not done yet)
• [ ] OrientDB -
• [ ] ArangoDB -
• [ ] RethinkDB https://github.com/mbq/rethinker
• [ ] BerkeleyDB https://github.com/hrbrmstr/RBerkeley / https://github.com/richfitz/storr.bdb
• [ ] ~~Foundationdb~~ ha! nevermind, :apple: happened

[sandys]

please support postgresql jsonb - its one of the most extensively used document database now. Redshift is entirely based on this.

[sckott]

thanks for the suggestion @sandys - we'll look into it

[jeroen]

@sandys what do you mean? postgresql is not part of the nodbi suite? And jsonb is already supported in Rpostgres ?

[sandys]

Hi jeroen I did not mean as a connection mechanism (of which you just fixed a bug yesterday), but of the usage paradigm.

For example the mental model of mongodb, etcd is along key values... Postgresql jsonb is incredible and rivals mongo in speed, yet gives ACID... But most of the connectors still use it as a relational db.

This request was to enable a nosql use model for postgresql jsonb. On Feb 4, 2016 22:30, "Jeroen Ooms" [email protected] wrote:

@sandys https://github.com/sandys what do you mean? postgresql is not part of the nodbi suite? And it is already supported in Rpostgres https://github.com/rstats-db/RPostgres ?

— Reply to this email directly or view it on GitHub https://github.com/ropensci/nodbi/issues/2#issuecomment-179945853.

[sckott]

@jeroenooms i think it makes sense here, do you not?

[sandys]

just FYI - these are the operators and types that are supported by Postgresql in its NOSQL jsonb schema

http://www.postgresql.org/docs/9.5/static/datatype-json.html http://www.postgresql.org/docs/9.4/static/functions-json.html

On Thu, Feb 4, 2016 at 11:39 PM, Scott Chamberlain <[email protected]

wrote:

@jeroenooms https://github.com/jeroenooms i think it makes sense here, do you not?

— Reply to this email directly or view it on GitHub https://github.com/ropensci/nodbi/issues/2#issuecomment-179973702.

[jeroen]

I'm not very familiar with jsonb. Can you elaborate @sandys ? Afaik, the jsonb is a field within a table, not an entire table or collectino. What would a nodbi interface to a jsonb value look like?

[rfhb]

@sandys @jeroen @sckott nodbi now also works with PostgreSQL, using jsonb functions and the RPostgres connector package; the API and the return values are the same across backends. For a benchmark, see https://github.com/ropensci/nodbi#benchmark.

[sckott]

nice work

[rfhb]

Added: support for using DuckDB (R package duckdb >= 0.6.0) as backend

[rfhb]

Closing as mostly covered at https://github.com/ropensci/nodbi#database-connections; a new development roadmap remains to be drafted.