{"repo":"r-dbi/RPostgres","free":true,"listed":false,"github":"https://github.com/r-dbi/RPostgres","clone":"git clone https://github.com/r-dbi/RPostgres.git","description":"A DBI-compliant interface to PostgreSQL","language":"R","stars":341,"topics":["r","database","postgres","postgresql"],"license":null,"category":"databases-storage","readme_excerpt":"RPostgres RPostgres is an DBI-compliant interface to the postgres database. It's a ground-up rewrite using C++ and cpp11. Compared to RPostgreSQL, it: Has full support for parameterised queries via dbSendQuery() , and dbBind() . Automatically cleans up open connections and result sets, ensuring that you don't need to worry about leaking connections or memory. Is a little faster, saving 5 ms per query. (For reference, it takes around 5ms to retrieve a 1000 x 25 result set from a local database, so this is decent speed up for smaller queries.) A simplified build process that relies on system libpq. Installation Discussions associated with DBI and related database packages take place on R-SIG-DB. The website Databases using R describes the tools and best practices in this ecosystem. Basic usage Connecting to a specific Postgres instance Design notes The 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. --- Please note that the 'RPostgres' project is released with a Contr","default_branch":null,"files":null,"tree":[],"storefront":"/r/r-dbi","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/r-dbi/RPostgres/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}