{"Package":"RPostgres","Title":"'Rcpp' Interface to 'PostgreSQL'","Version":"1.1.1","Date":"2018-05-05","Authors@R":"c(\nperson(\"Hadley\", \"Wickham\", role = \"aut\"),\nperson(\"Jeroen\", \"Ooms\", role = \"aut\"),\nperson(\"Kirill\", \"M\\u00fcller\", role = c(\"aut\", \"cre\"), email = \"krlmlr+r@mailbox.org\", comment = c(ORCID = \"0000-0002-1416-3412\")),\nperson(\"RStudio\", role = \"cph\"),\nperson(\"R Consortium\", role = \"fnd\"),\nperson(\"Tomoaki\", \"Nishiyama\", role = \"ctb\",\ncomment = \"Code for encoding vectors into strings derived from RPostgreSQL\")\n)","Description":"\nFully 'DBI'-compliant 'Rcpp'-backed interface to 'PostgreSQL' ,\nan open-source relational database.","License":"GPL-2","URL":"https://github.com/r-dbi/RPostgres","BugReports":"https://github.com/r-dbi/RPostgres/issues","Depends":"R (>= 3.1.0)","Imports":"bit64, blob (>= 1.1.1), DBI (>= 1.0.0), hms, methods, Rcpp (>=\n0.11.4.2), withr","Suggests":"DBItest, testthat","LinkingTo":"BH, plogr (>= 0.2.0), Rcpp","Encoding":"UTF-8","LazyLoad":"true","RoxygenNote":"6.0.1.9000","SystemRequirements":"libpq >= 9.0: libpq-dev (deb) or postgresql-devel\n(rpm)","Collate":"'PqDriver.R' 'PqConnection.R' 'PqResult.R' 'RPostgres-pkg.R'\n'RcppExports.R' 'default.R' 'export.R' 'names.R' 'quote.R'\n'tables.R' 'transactions.R' 'utils.R'","NeedsCompilation":"yes","Packaged":"2018-05-06 17:03:57 UTC; kirill","Author":"Hadley Wickham [aut],\nJeroen Ooms [aut],\nKirill Mller [aut, cre] (),\nRStudio [cph],\nR Consortium [fnd],\nTomoaki Nishiyama [ctb] (Code for encoding vectors into strings derived\nfrom RPostgreSQL)","Maintainer":"Kirill Mller ","Repository":"CRAN","Date/Publication":"2018-05-06 20:51:11 UTC","repoType":"cran","tarballUrl":"ftp://cran.r-project.org/pub/R/src/contrib/RPostgres_1.1.1.tar.gz","jsonAuthors":[{"name":"Hadley Wickham","email":null,"maintainer":false},{"name":"Jeroen Ooms","email":null,"maintainer":false},{"name":"Kirill Müller","email":"krlmlr+r@mailbox.org","maintainer":true},{"name":"RStudio ","email":null,"maintainer":false},{"name":"R Consortium ","email":null,"maintainer":false},{"name":"Tomoaki Nishiyama","email":null,"maintainer":false}],"readme":"# RPostgres\n\n[![Travis-CI Build Status](https://travis-ci.org/r-dbi/RPostgres.png?branch=master)](https://travis-ci.org/r-dbi/RPostgres) [![AppVeyor Build Status](https://ci.appveyor.com/api/projects/status/github/r-dbi/RPostgres?branch=master&svg=true)](https://ci.appveyor.com/project/r-dbi/RPostgres) [![codecov](https://codecov.io/gh/r-dbi/RPostgres/branch/master/graph/badge.svg)](https://codecov.io/gh/r-dbi/RPostgres)\n\nRPostgres is an DBI-compliant interface to the postgres database. It's a ground-up rewrite using C++ and Rcpp. Compared to RPostgresSQL, it:\n\n* Has full support for parameterised queries via `dbSendQuery()`, and `dbBind()`.\n\n* Automatically cleans up open connections and result sets, ensuring that you\n don't need to worry about leaking connections or memory.\n\n* Is a little faster, saving ~5 ms per query. (For reference, it takes around 5ms\n to retrive a 1000 x 25 result set from a local database, so this is \n decent speed up for smaller queries.)\n\n* A simplified build process that relies on system libpq.\n\n## Installation\n```R\n# Install the latest RPostgres release from CRAN:\ninstall.packages(\"RPostgres\")\n\n# Or the the development version from GitHub:\n# install.packages(\"remotes\")\nremotes::install_github(\"r-dbi/RPostgres\")\n```\n\n## Basic usage\n\n```R\nlibrary(DBI)\n# Connect to the default postgres database\ncon <- dbConnect(RPostgres::Postgres())\n\ndbListTables(con)\ndbWriteTable(con, \"mtcars\", mtcars)\ndbListTables(con)\n\ndbListFields(con, \"mtcars\")\ndbReadTable(con, \"mtcars\")\n\n# You can fetch all results:\nres <- dbSendQuery(con, \"SELECT * FROM mtcars WHERE cyl = 4\")\ndbFetch(res)\ndbClearResult(res)\n\n# Or a chunk at a time\nres <- dbSendQuery(con, \"SELECT * FROM mtcars WHERE cyl = 4\")\nwhile(!dbHasCompleted(res)){\n chunk <- dbFetch(res, n = 5)\n print(nrow(chunk))\n}\n# Clear the result\ndbClearResult(res)\n\n# Disconnect from the database\ndbDisconnect(con)\n```\n## Connecting to a specific Postgres instance\n\n```R\nlibrary(DBI)\n# Connect to a specific postgres database i.e. Heroku\ncon <- dbConnect(RPostgres::Postgres(),dbname = 'DATABASE_NAME', \n host = 'HOST', # i.e. 'ec2-54-83-201-96.compute-1.amazonaws.com'\n port = 5432, # or any other port specified by your DBA\n user = 'USERNAME',\n password = 'PASSWORD')\n\n```\n\n## Design notes\n\nThe original DBI design imagined that each package could instantiate X drivers, with each driver having Y connections and each connection having Z results. This turns out to be too general: a driver has no real state, for PostgreSQL each connection can only have one result set. In the RPostgres package there's only one class on the C side: a connection, which optionally contains a result set. On the R side, the driver class is just a dummy class with no contents (used only for dispatch), and both the connection and result objects point to the same external pointer.","jobInfo":{"package":"RPostgres","version":"1.1.1","parsingStatus":"success","parserVersion":1,"parsedAt":"2019-12-03T13:30:20+0000"}}

Description

Usage

Arguments