{"Encoding":"UTF-8","Package":"RPostgres","Version":"1.0-4","Date":"2017-12-20","Title":"'Rcpp' Interface to 'PostgreSQL'","Authors@R":"c(\nperson(\"Hadley\", \"Wickham\", role = \"aut\"),\nperson(\"Jeroen\", \"Ooms\", role = \"aut\"),\nperson(\"Kirill\", \"Mller\", role = \"cre\", email = \"krlmlr+r@mailbox.org\"),\nperson(\"RStudio\", role = \"cph\"),\nperson(\"R Consortium\", role = \"cph\"),\nperson(\"Tomoaki\", \"Nishiyama\", role = \"ctb\",\ncomment = \"Code for encoding vectors into strings derived from RPostgreSQL\"),\nperson(\"Kungliga Tekniska Hgskolan\", role = \"ctb\", comment = \"Source code for timegm\")\n)","Description":"\nFully 'DBI'-compliant 'Rcpp'-backed interface to 'PostgreSQL' ,\nan open-source relational database.","URL":"https://github.com/r-dbi/RPostgres","BugReports":"https://github.com/r-dbi/RPostgres/issues","SystemRequirements":"libpq >= 9.0: libpq-dev (deb) or postgresql-devel\n(rpm)","License":"GPL-2","LazyLoad":"true","Depends":"R (>= 3.1.0)","Imports":"bit64, blob, DBI (>= 0.7), hms, methods, Rcpp (>= 0.11.4.2),\nwithr","Suggests":"DBItest, testthat","LinkingTo":"BH, plogr, Rcpp","Collate":"'PqDriver.R' 'PqConnection.R' 'PqResult.R' 'RPostgres-pkg.R'\n'RcppExports.R' 'default.R' 'quote.R' 'tables.R'\n'transactions.R' 'utils.R'","RoxygenNote":"6.0.1","NeedsCompilation":"yes","Packaged":"2017-12-20 13:58:34 UTC; muelleki","Author":"Hadley Wickham [aut],\nJeroen Ooms [aut],\nKirill Mller [cre],\nRStudio [cph],\nR Consortium [cph],\nTomoaki Nishiyama [ctb] (Code for encoding vectors into strings derived\nfrom RPostgreSQL),\nKungliga Tekniska Hgskolan [ctb] (Source code for timegm)","Maintainer":"Kirill Mller ","Repository":"CRAN","Date/Publication":"2017-12-20 15:50:56 UTC","repoType":"cran","tarballUrl":"ftp://cran.r-project.org/pub/R/src/contrib/RPostgres_1.0-4.tar.gz","jsonAuthors":[{"name":"Hadley Wickham","email":null,"maintainer":false},{"name":"Jeroen Ooms","email":null,"maintainer":false},{"name":"Kirill Mller","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},{"name":"Kungliga Tekniska Hgskolan ","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 PostgresSQL, 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.0-4","parsingStatus":"success","parserVersion":1,"parsedAt":"2018-04-06T11:30:15+0000"}}

Description

Usage

Arguments