R Observatory: Metrics for RPostgreSQL version 0.7-8

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

RPostgreSQL

0.7-8Package record

R Interface to the 'PostgreSQL' Database System

9packages dependsuggested by 13

482.5Kdownloads / year

–test coverage

9/13flavors OK

Overview

About

Maintained by Tomoaki NishiyamaCRAN page ↗GitHub ↗Website ↗

Database interface and 'PostgreSQL' driver for 'R'. This package provides a Database Interface 'DBI' compliant driver for 'R' to access 'PostgreSQL' database systems. In order to build and install this package from source, 'PostgreSQL' itself must be present your system to provide 'PostgreSQL' functionality via its libraries and header files. These files are provided as 'postgresql-devel' package under some Linux distributions. On 'macOS' and 'Microsoft Windows' system the attached 'libpq' library source will be used.

Install

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

install.packages("RPostgreSQL", 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("tomoakin/RPostgreSQL")

Development version from tomoakin/RPostgreSQL. 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-rpostgresql

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-RPostgreSQL

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

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

Health

CRAN checks

4WARNING9OK

Check messages

WARNINGcompiled coder-oldrel-macos-arm64, r-oldrel-macos-x86_64, r-release-macos-arm64, r-release-macos-x86_64

File ‘RPostgreSQL/libs/RPostgreSQL.so’:
  Found ‘___sprintf_chk’, possibly from ‘sprintf’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘___stderrp’, possibly from ‘stderr’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘_abort’, possibly from ‘abort’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘_sprintf’, possibly from ‘sprintf’ (C)
    Object: ‘libpq/libpq.a’

Compiled code should not call entry points which might terminate R nor
write to stdout/stderr instead of to the console, nor use Fortran I/O
nor system RNGs nor [v]sprintf.

See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual.

Additional issues

rchk

CRAN check page ↗

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

Status changes

WARNING9 OK, 4 WARNING2026-09-08
ERROR8 OK, 4 WARNING, 1 ERROR2026-09-07
WARNING8 OK, 4 WARNING2026-04-25
ERROR10 OK, 2 WARNING, 2 ERROR2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 0.7-8

READMENoVignettesNoNEWSYes · 67% structuredCitation fileNoWebsiteYes

Help pages: 26 (1 internal)
Examples that run: 0%21 never run · 1 hold no code
Exported functions with examples: 60%
Documented parameters: 100%
Return-value docs: 100%
Help pages citing references: 69%

How these are measured

Downloads

482.5K

CRAN downloads in the past year

Rank #628 · ~1.3K/day · ~40.2K/mo

Releases R versions

Daily download trend is not available in this view yet.

36.6K30 days

93.2K90 days

482.5K1 year

Compare downloads with other packages →

Also on6.5K r2u9.9K conda_forge286 c2d4u

How downloads are counted

Repository

tomoakin/rpostgresql ↗Account: tomoakin

67Stars

22Forks

44Open issues

4Open PRs

0Releases

339Commits

7Commit identities

339 commits · Last activity 2025-03-28 · +1.5% stars, 30d

Responsiveness

How these are sampled

PRs merged (all time): 9%
Median days to close, 50 most recently updated closed issues: 22
Median days to close, 50 most recently updated closed PRs: 360

Stars over time

2025-03-27 · 662026-10-07 · 67

How these are measured

PracticesBeta

1 development-tooling and community-health practice detected across 1 family in the upstream repository

Checks run against github.com/tomoakin/rpostgresql on 2026-10-21.

Continuous integration (1)

Travis CI (config file)

How this is detected·Detection ruleset v4 (2026-10-20)

Dependencies

Declared dependencies

1 external dependency (excludes base and recommended)

Installing RPostgreSQL adds 1 package (0 with compiled code, 727 KB of source tarballs). Heaviest: DBI 727 KB.

Depends (3)

R >= 3.4.0methodsDBI

Imports (0)

none

LinkingTo (0)

none

Suggests (0)

none

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

9direct

5indirect

Depends 3 · Imports 6

Suggested by 13

Show all 22 packagesHide all 22 packages

Depends, Imports or LinkingTo, most downloaded first

BIEN rpostgis occCite birdscanR sejmRP RuHere obm clintrialx OpenRange

Suggests, most downloaded first

dbplyr sf spacetime sqldf nngeo NetSimR ProjectTemplate shiny.telemetry dbx dittodb geoflow hyd1d rdataretriever

How these are counted

Code & Tests

People & History

People (5)

Tomoaki Nishiyama

Author, Maintainer since 0.2-0 (2011) · added in 0.1-7

Joe Conway

Author · added in 0.1-6

Dirk Eddelbuettel

Author · added in 0.1-7

Sameer Kumar Prayaga

Author · added in 0.1-6

during 2008

Neil Tiffin

Author · added in 0.1-6

Previously maintained by Dirk Eddelbuettel (0.1-0 to 0.1-7).

Listed in earlier versions (2)

Sameer Kumar Prayaga with mentor Dirk Eddelbuettel

no longer listed · 0.1-0 to 0.1-5

Prayaga

no longer listed · 0.7-7 to 0.7-8

Releases (25)

Pick two releases to compare their code metrics.

R
R 4.6.0 released · 2026-04-24
R
R 4.5.0 released · 2025-04-11
0.7-8Latest
record
2025-03-28 · current release · diff ↗
0.7-7
record
2024-09-30 · diff ↗
R
R 4.4.0 released · 2024-04-24
0.7-6
record
2024-01-11 · diff ↗ ·
removed 1 export
.PostgreSQLKeywords
R
R 4.3.0 released · 2023-04-21
0.7-5
record
2023-02-10 · diff ↗
0.7-4
record
2022-08-09 · diff ↗
R
R 4.2.0 released · 2022-04-22
0.7-3
record
2021-10-22 · diff ↗
0.7-2
record
2021-10-06 · diff ↗
0.7
record
2021-07-27 · diff ↗
R
R 4.1.0 released · 2021-05-18
R
R 4.0.0 released · 2020-04-24
R
R 3.6.0 released · 2019-04-26

Show 32 earlier eventsHide 32 earlier events

R
R 3.5.0 released · 2018-04-23
0.6-2
record
2017-06-24 · diff ↗ ·
added 2 exports
postgresqlEscapeBytea, postgresqlUnescapeBytea
R
R 3.4.0 released · 2017-04-21
0.4-1
record
2016-05-08 · diff ↗
R
R 3.3.0 released · 2016-05-03
R
R 3.2.0 released · 2015-04-16
R
R 3.1.0 released · 2014-04-10
R
R 3.0.0 released · 2013-04-03
0.4
record
2013-03-27 · diff ↗
0.3-3
record
2012-10-05 · diff ↗
R
R 2.15.0 released · 2012-03-30
0.3-2
record
2012-01-29 · diff ↗
0.3-1
record
2012-01-03 · diff ↗
0.3-0
record
2011-12-30 · diff ↗ ·
removed 3 exports
dbBuildTableDefinition, isIdCurrent, safe.write

added 2 exports
postgresqlBuildTableDefinition, isPostgresqlIdCurrent
0.2-1
record
2011-11-17 · diff ↗
R
R 2.14.0 released · 2011-10-31
0.2-0
record
2011-10-04 · diff ↗ ·
added 5 exports
postgresqlpqExec, postgresqlCopyInDataframe, postgresqlgetResult, postgresqlQuoteId, postgresqlTableRef
R
R 2.13.0 released · 2011-04-13
0.1-7
record
2010-10-17 · diff ↗ ·
added 2 exports
postgresqlCopyIn, postgresqlEscapeStrings
R
R 2.12.0 released · 2010-10-15
R
R 2.11.0 released · 2010-04-22
R
R 2.10.0 released · 2009-10-26
0.1-6
record
2009-10-20 · diff ↗
0.1-5
record
2009-10-14 · diff ↗
R
R 2.9.0 released · 2009-04-17
0.1-4
record
2009-01-28 · diff ↗
0.1-3
record
2008-12-14 · diff ↗
0.1-2
record
2008-11-03 · diff ↗
0.1-1
record
2008-10-29 · diff ↗
R
R 2.8.0 released · 2008-10-20
0.1-0
record
2008-10-13
R
R 2.7.0 released · 2008-04-22

Package metadata

First published: 2008-10-13
Total releases: 25 / 18 yrs
License: GPL-3 | file LICENSE OSI
Copyright: Authors listed above, PostgreSQL Global Development Group, and The Regents of the University of California
Minimum R: ≥ 3.4.0
Download size: 552 KB

Appears in task views

Databases with R Analysis of Spatial Data

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("RPostgreSQL")

Format

Nishiyama, T., Conway, J., Eddelbuettel, D., Prayaga, S. K., & Tiffin, N. (2025). RPostgreSQL: R Interface to the 'PostgreSQL' Database System (Version 0.7-8) [Computer software]. https://doi.org/10.32614/CRAN.package.RPostgreSQL

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 RPostgreSQL version 0.7-8 [Data set]. HJJB, LLC. Data release v2026-10-23. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-23, 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 →