RPostgres

Overview

About

Maintained by Kirill MüllerFirst published 2017-12-0623 releasesCRAN page ↗GitHub ↗

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

Install

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

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.

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

Health

CRAN checks

1NOTE12OK

Failing flavors

NOTE r-devel-linux-x86_64-debian-gcc

Slowest check: 9.5 min · r-oldrel-windows-x86_64

Code health

Yes

Tests · ratio 0.78

7.3%

Coverage · measured lines

100%

Documentation · exports

7

Dependencies · direct

Check history

NOTE2026-08-01
12 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-05-02
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
NOTE2026-03-10
11 OK · 3 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 277 wordsVignettesYes · dynamicpkgdown siteNoNEWSYes · 100% structuredCode of conductNoContributing guideNo

Examples that run: 78%
Documented parameters: 100%
Return-value docs: 50%
References docs: 0%

Downloads

593.5K

CRAN downloads in the past year

Rank #533 · ~1.6K/day · ~49.5K/mo

Releases R versions

Daily download trend is not available in this view yet.

36.9K30 days

140.7K90 days

593.5K1 year

Compare downloads with other packages →

Also on12K r2u16.5K conda_forge124 c2d4u

Repository

GitHub ↗ r-dbi/rpostgres

340Stars

83Forks

27Open issues

11Open PRs

23Releases

1,906Commits

44Contributors

rdatabasepostgrespostgresql

1,906 commits · Last activity 2026-07-29 · +0.3% stars, 30d

Stars over time

2025-03-30 · 3322026-08-04 · 340

Repository practices

Upstream repositoryBeta

8 development-tooling and community-health practices detected across 6 families in the upstream repository

Checks run against github.com/r-dbi/rpostgres on 2026-08-03.

Continuous integration (1)

GitHub Actions

Reproducibility and dev environment (2)

DockerfileGitpod

CRAN release process (1)

cran-comments.md

Lint, format, editor (2)

AirRStudio project

Show all practices

Coverage (1)

Codecov

Governance and community (1)

Issue templates

How this is detected·Detection ruleset v1 (2026-07-18)

Development tooling

AI-assisted toolingBeta

Uses AI-assisted development tooling (declared in repo)

Earliest detected marker: copilot on 2025-09-13

copilotclaude

Most recent: claude on 2026-05-16

Evidence

copilot: on 2025-09-13 · evidence A, D · sole bot-author seen
claude: on 2026-05-16 · evidence B

How this is detected·Detection ruleset v2 (updated 2026-07-29)

Dependencies

Declared dependencies

14 external dependencies (excludes base and recommended)

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 →

People & History

People (6)

Maintainer (1)

Kirill Müller

Author, Maintainer

Authors (3)

Kirill Müller

Author, Maintainer

Jeroen Ooms

Author

Hadley Wickham

Author

Contributors (1)

Tomoaki Nishiyama

Contributor

Copyright holders (1)

RStudio

Copyright holder

Funders (1)

R Consortium

Funder

Listed in earlier versions (2)

Kungliga Tekniska Högskolan

no longer listed · 1.0-3 to 1.0-4

Kirill M\u00fcller

no longer listed · 1.1.0 to 1.4.4

Package Timeline

23 releases. Pick two to compare their code metrics. R releases are shown for context.

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

Show 17 earlier events

1.3.3
2021-07-05 · diff ↗
R
R 4.1.0 released · 2021-05-18
1.3.2
2021-04-12 · diff ↗
1.3.1
2021-01-19 · diff ↗
1.3.0
2021-01-07 · diff ↗
1.2.1
2020-09-28 · diff ↗
R
R 4.0.0 released · 2020-04-24
1.2.0
2019-12-18 · diff ↗
1.1.3
2019-12-07 · diff ↗
1.1.2
2019-12-03 · diff ↗
R
R 3.6.0 released · 2019-04-26
1.1.1
2018-05-06 · diff ↗
R
R 3.5.0 released · 2018-04-23
1.1.0
2018-04-06 · diff ↗
1.0-4
2017-12-20 · diff ↗
1.0-3
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
Minimum R: ≥ 3.1.0
Download size: 1.4 MB
Installed size: not tracked yet
With dependencies: not tracked yet

Appears in task views

Databases with R