r-dbi.org valid

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:

For agents: Reference docs for RPostgres, a DBI-compliant R interface to PostgreSQL built in C++, with functions for connecting and querying.

r packagepostgresqldbi interfacerpostgres

Their llms.txt

The beginning of the file, from our validated copy saved 2026-10-23T19:47:22.386Z. Cached copy · Source on r-dbi.org

# RPostgres

RPostgres is an DBI-compliant interface to the postgres database. It’s a
ground-up rewrite using C++ and [cpp11](https://github.com/r-lib/cpp11).
Compared to RPostgreSQL, it:

- Has full support for parameterised queries via
  [`dbSendQuery()`](https://dbi.r-dbi.org/reference/dbSendQuery.html),
  and [`dbBind()`](https://dbi.r-dbi.org/reference/dbBind.html).

- 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

``` r
# Install the latest RPostgres release from CRAN:
install.packages("RPostgres")

# Or the the development version from GitHub:
# install.packages("remotes")
remotes::install_github("r-dbi/RPostgres")
```

Discussions associated with DBI and related database packages take place
on [R-SIG-DB](https://stat.ethz.ch/mailman/listinfo/r-sig-db). The
website [Databases using R](https://db.rstudio.com/) describes the tools
and best practices in this ecosystem.

## Basic usage

``` r
library(DBI)
# Connect to the default postgres database
con <- dbConnect(RPostgres::Postgres())

dbListTables(con)
dbWriteTable(con, "mtcars", mtcars)
dbListTables(con)

dbListFields(con, "mtcars")
dbReadTable(con, "mtcars")

# You can fetch all results:
res <- dbSendQuery(con, "SELECT * FROM mtcars WHERE cyl = 4")
dbFetch(res)
dbClearResult(res)

# Or a chunk at a time
res <- dbSendQuery(con, "SELECT * FROM mtcars WHERE cyl = 4")
while(!dbHasCompleted(res)){
  chunk <- dbFetch(res, n = 5)
  print(nrow(chunk))
}
…

Related sites

Find similar publishers by meaning →

Other listed sites in Databases. See the whole category →

Machine-readable: GET /v1/resolve?q=r-dbi.org · GET /v1/domain/r-dbi.org · this page as Accept: application/json or text/markdown · MCP lookup_domain

Automatically discovered from public files. Inclusion does not imply endorsement or publisher participation.

Claim my listing on Agent Web Map for r-dbi.org:
1. POST https://agentwebmap.com/v1/sites/r-dbi.org/claims and keep claim_id and claim_secret private.
2. Publish the proof: add the line "AgentWebMap ownership: <token>" (token from step 1) to https://r-dbi.org/llms.txt, or use the DNS, meta-tag or well-known method the response describes.
3. POST https://agentwebmap.com/v1/sites/r-dbi.org/verify with {"claim_id": "...", "claim_secret": "..."}.
4. Save the api_key from the answer; it manages the listing (PATCH https://agentwebmap.com/v1/sites/r-dbi.org).
MCP equivalent: tools begin_ownership_claim, then verify_domain, at https://agentwebmap.com/mcp. Docs: https://agentwebmap.com/docs#verify

Corrections or removal requests: contact the directory.