R Observatory: Metrics for RPostgres version 1.4.10

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

RPostgres

1.4.10Package record

C++ Interface to PostgreSQL

27packages dependsuggested by 54

589.8Kdownloads / year

7.3%test coverage

13/13flavors OK

Overview

About

Maintained by Kirill MüllerCRAN page ↗GitHub ↗Website ↗Issues ↗Declared funder: R Consortium

Fully DBI-compliant C++-backed interface to PostgreSQL https://www.postgresql.org/, an open-source relational database.

Changes in 1.4.10

Bug fixes

Fix compilation on Alpine Linux and other variants.

From NEWS.md in the release

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)

install.packages("RPostgres", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("r-dbi/RPostgres")

Development version from r-dbi/RPostgres. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-rpostgres

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled. We list this channel from recorded r2u download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-RPostgres

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

Health

CRAN checks

13OK

CRAN check page ↗

Slowest check: 9.8 min · r-devel-windows-x86_64

Status changes

OK13 OK2026-09-08
ERROR12 OK, 1 ERROR2026-09-07
OK13 OK2026-08-05
NOTE12 OK, 1 NOTE2026-08-01
OK13 OK2026-05-02

Show 1 earlier changeHide 1 earlier change

NOTE11 OK, 3 NOTE2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 1.4.10

READMEYes · 277 wordsVignettesYes · 1 · dynamicNEWSYes · 100% structured · mentions 1.4.10Citation fileNoWebsiteYes · pkgdown

Help pages: 17 (5 internal)includes a package overview page
Examples that run: 78%7 run in a plain check (6 of them under a condition) · 2 never run
Exported functions with examples: 63%
Documented parameters: 100%
Return-value docs: 50%
Help pages citing references: 0%

Vignettes (1)

Implementing a Work Queue using RPostgres HTML

How these are measured

Downloads

589.8K

CRAN downloads in the past year

Rank #505 · ~1.6K/day · ~49.2K/mo

Releases R versions

Daily download trend is not available in this view yet.

51.8K30 days

145.5K90 days

589.8K1 year

Compare downloads with other packages →

Also on12.4K r2u17.6K conda_forge205 c2d4u

How downloads are counted

Repository

r-dbi/rpostgres ↗Organization: r-dbi

344Stars

81Forks

27Open issues

12Open PRs

23Releases

1,961Commits

46Commit identities

rdatabasepostgrespostgresql

1,961 commits · Last activity 2026-10-11 · +0.3% stars, 30d · Default branch at 1.4.10.9020, ahead of CRAN 1.4.10 (checked 2026-10-11)

Responsiveness

How these are sampled

PRs merged (all time): 81%
Median days to close, 50 most recently updated closed issues: 61
Median days to close, 50 most recently updated closed PRs: 0

Stars over time

2025-10-05 · 3352026-09-25 · 344

How these are measured

PracticesBeta

14 development-tooling and community-health practices detected across 7 families in the upstream repository

Checks run against github.com/r-dbi/rpostgres on 2026-10-11.

Continuous integration (2)

GitHub ActionsR CMD check workflow

The R CMD check workflow runs on Linux and Windows

Governance and community (3)

Code of conductContributing guideIssue templates

Docs source (3)

pkgdown

GitHub Pages site last deployed 2026-09-27 · The repository has a site deploy workflow

pkgdown site last built 2026-02-15, before release 1.4.10 (2026-02-16)

Coverage (1)

Coverage reporting (Codecov)

Show all practicesHide 3 practices

Reproducibility and dev environment (2)

DockerfileGitpod

CRAN release process (1)

cran-comments.md

Lint, format, editor (2)

AirRStudio project

How this is detected·Detection ruleset v3 (2026-09-26)

AI coding toolsBeta

This repository shows signs of AI coding tools.

GitHub Copilotfirst seen 2025-09-13
Seen in the repository: .github/copilot-instructions.md
Pull request: opened by its own account
Commits: 2 by its own account · at least 2 crediting it in the message
Claude Codefirst seen on or before 2026-05-16
Pull request it wrote: opened by a project member
Commits: 4 by its own account · at least 42 crediting it in the message

Models named in its commits

Claude Opus 513 commits · Aug to Sep 2026
Claude Opus 5.53 commits · Sep 2026
Claude Fable 51 commit · Aug 2026

Counts are commits, not lines of code. Commits by a tool's accounts count once across all of its accounts. Commits crediting it are the largest count among its credit lines, a minimum.How this is detected·Detection ruleset v4 (updated 2026-09-27)

Dependencies

Declared dependencies

14 external dependencies (excludes base and recommended)

Installing RPostgres adds 16 packages (8 with compiled code, 4.8 MB of source tarballs). Heaviest: vctrs 1.0 MB, rlang 766 KB, DBI 727 KB.

Depends (1)

R >= 3.1.0

Imports (7)

bit64 blob DBI hms lubridatemethodswithr

LinkingTo (1)

cpp11

Suggests (7)

callr covr DBItest knitr rlang rmarkdown testthat

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

27direct

8indirect

Imports 27

Suggested by 54

Show the 48 most downloaded packagesHide the 48 most downloaded packages

Depends, Imports or LinkingTo, most downloaded first

Suggests, most downloaded first

and 33 more packages that suggest it on CRAN ↗

How these are counted

Code & Tests

People & History

People (6)

Kirill Müller

Author, Maintainer since 1.0-3 (2017)

Jeroen Ooms

Author

Hadley Wickham

Author

Tomoaki Nishiyama

Contributor

Code for encoding vectors into strings derived from RPostgreSQL

RStudio

Copyright holder

R Consortium

Funder

Listed in earlier versions (1)

Kungliga Tekniska Högskolan

no longer listed · 1.0-3 to 1.0-4

Releases (23)

Pick two releases to compare their code metrics.

R
R 4.6.0 released · 2026-04-24
1.4.10Latest
record
2026-02-16 · current release · diff ↗
1.4.9
record
2026-02-06 · diff ↗ ·
added 1 export
postgresExportLargeObject
R
R 4.5.0 released · 2025-04-11
1.4.8
record
2025-02-25 · diff ↗ ·
added 1 export
postgresImportLargeObject
1.4.7
record
2024-05-27 · diff ↗
R
R 4.4.0 released · 2024-04-24
1.4.6
record
2023-10-22 · diff ↗
R
R 4.3.0 released · 2023-04-21
1.4.5
record
2023-01-20 · diff ↗
1.4.4
record
2022-05-02 · diff ↗
R
R 4.2.0 released · 2022-04-22
1.4.3
record
2021-12-20 · diff ↗ ·
added 1 export
postgresIsTransacting
1.4.2
record
2021-12-05 · diff ↗
1.4.1
record
2021-09-27 · diff ↗
1.4.0
record
2021-09-26 · diff ↗

Show 17 earlier eventsHide 17 earlier events

1.3.3
record
2021-07-05 · diff ↗
R
R 4.1.0 released · 2021-05-18
1.3.2
record
2021-04-12 · diff ↗
1.3.1
record
2021-01-19 · diff ↗
1.3.0
record
2021-01-07 · diff ↗ ·
added 1 export
postgresWaitForNotify
1.2.1
record
2020-09-28 · diff ↗ ·
added 1 export
Redshift
R
R 4.0.0 released · 2020-04-24
1.2.0
record
2019-12-18 · diff ↗
1.1.3
record
2019-12-07 · diff ↗
1.1.2
record
2019-12-03 · diff ↗
R
R 3.6.0 released · 2019-04-26
1.1.1
record
2018-05-06 · diff ↗ ·
added 1 export
Id
R
R 3.5.0 released · 2018-04-23
1.1.0
record
2018-04-06 · diff ↗
1.0-4
record
2017-12-20 · diff ↗
1.0-3
record
2017-12-06
R
R 3.4.0 released · 2017-04-21

Package metadata

First published: 2017-12-06
Total releases: 23 / 9 yrs
License: MIT + file LICENSE OSI · relicensed from GPL-3 in 1.4.6
Minimum R: ≥ 3.1.0
Download size: 1.4 MB

Appears in task views

Databases with R

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("RPostgres")

Format

Müller, K., R Consortium, RStudio, Nishiyama, T., Ooms, J., & Wickham, H. (2026). RPostgres: C++ Interface to PostgreSQL (Version 1.4.10) [Computer software]. https://doi.org/10.32614/CRAN.package.RPostgres

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for RPostgres version 1.4.10 [Data set]. HJJB, LLC. Data release v2026-10-17. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-17, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →