search

ropensci / nodbi

Document DBI connector for R
https://docs.ropensci.org/nodbi
Other
76 stars 6 forks source link

Databases #2

Closed sckott closed 11 months ago

sckott commented 9 years ago

Last updated on 2022-11-03 (@rfhb):

Previously considered:

sandys commented 8 years ago

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

sckott commented 8 years ago

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

jeroen commented 8 years ago

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

sandys commented 8 years ago

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" notifications@github.com 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 commented 8 years ago

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

sandys commented 8 years ago

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 <notifications@github.com

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 commented 8 years ago

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 commented 2 years ago

@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 commented 2 years ago

nice work

rfhb commented 1 year ago

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

rfhb commented 11 months ago

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