RPostgreSQL

0.7-8

R Interface to the 'PostgreSQL' Database System

22packages depend

599.1Kdownloads / year

–test coverage

9/13checks pass

Overview

About

Maintained by Tomoaki NishiyamaFirst published 2008-10-1325 releasesCRAN page ↗GitHub ↗

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.

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

Failing flavors

WARNING r-oldrel-macos-arm64
WARNING r-oldrel-macos-x86_64
WARNING r-release-macos-arm64
WARNING r-release-macos-x86_64

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

Code health

Yes

Tests · ratio 0.00

not tracked

Coverage

100%

Documentation · exports

Dependencies · direct

Check history

WARNING2026-04-25
8 OK · 0 NOTE · 4 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-03-10
10 OK · 0 NOTE · 2 WARNING · 2 ERROR · 0 FAILURE

Documentation

READMENoVignettesNopkgdown siteNoNEWSNoCode of conductNoContributing guideNo

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

Downloads

599.1K

CRAN downloads in the past year

Rank #636 · ~1.6K/day · ~49.9K/mo

Releases R versions

Daily download trend is not available in this view yet.

30.5K30 days

102.4K90 days

599.1K1 year

Compare downloads with other packages →

Also on5K r2u9.3K conda_forge60 c2d4u

Repository

GitHub ↗ tomoakin/rpostgresql

66Stars

22Forks

45Open issues

4Open PRs

0Releases

339Commits

7Contributors

339 commits · Last activity 2025-03-28

Stars over time

2025-03-27 · 662026-07-07 · 66

Repository practices

Upstream repositoryBeta

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

Checks run against github.com/tomoakin/rpostgresql on 2026-07-19.

Continuous integration (1)

Travis CI

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

Dependencies

Declared dependencies

1 external dependency (excludes base and recommended)

Depends (3)

R >= 3.4.0methodsDBI

Imports (0)

none

LinkingTo (0)

none

Suggests (0)

none

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

22direct

6indirect

BIEN OpenRange rpostgis NetSimR birdscanR clintrialx lucas obm occCite sejmRP ProjectTemplate dbplyr dbx dittodb geoflow hyd1d nngeo rdataretriever sf shiny.telemetry spacetime sqldf

Code & Tests

Code Composition

C 39,922 (93%)Rd 1,973 (5%)R 1,258 (3%)

Code characteristics

Object systems

S4 class5S4 generic2S4 method48

Cyclomatic complexity: 3.0 median / 20 max

Test coverage

Line coverage

–

Expression

–

Tests / Examples

–

Functions

645 33 exported

Complexity

4.4 avg / 20 max

Call network

645 nodes / 1348 edges

Call graph

Open call graph →

Loading call graph…

Lowest coverage

Per-function coverage is not measured for this package yet.

People & History

People (5)

Maintainer (1)

Tomoaki Nishiyama

Author, Maintainer · added in 0.1-7

Authors (5)

Tomoaki Nishiyama

Author, Maintainer · 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

Neil Tiffin

Author · added in 0.1-7

Listed in earlier versions (4)

Sameer Kumar Prayaga with mentor Dirk Eddelbuettel <edd@debian.org>

no longer listed · 0.1-0 to 0.1-5

Sameer Kumar Prayaga (during 2008)

no longer listed · 0.1-6 to 0.7-6

Dirk Eddelbuettel with contributions by Neil Tiffin

no longer listed · 0.1-6

Prayaga

no longer listed · 0.7-7 to 0.7-8

Package Timeline

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

R
R 4.6.0 released · 2026-04-24
R
R 4.5.0 released · 2025-04-11
0.7-8Latest
2025-03-28 · current release · diff ↗
0.7-7
2024-09-30 · diff ↗
R
R 4.4.0 released · 2024-04-24
0.7-6
2024-01-11 · diff ↗
R
R 4.3.0 released · 2023-04-21
0.7-5
2023-02-10 · diff ↗
0.7-4
2022-08-09 · diff ↗
R
R 4.2.0 released · 2022-04-22
0.7-3
2021-10-22 · diff ↗
0.7-2
2021-10-06 · diff ↗
0.7
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 events

R
R 3.5.0 released · 2018-04-23
0.6-2
2017-06-24 · diff ↗
R
R 3.4.0 released · 2017-04-21
0.4-1
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
2013-03-27 · diff ↗
0.3-3
2012-10-05 · diff ↗
R
R 2.15.0 released · 2012-03-30
0.3-2
2012-01-29 · diff ↗
0.3-1
2012-01-03 · diff ↗
0.3-0
2011-12-30 · diff ↗
0.2-1
2011-11-17 · diff ↗
R
R 2.14.0 released · 2011-10-31
0.2-0
2011-10-04 · diff ↗
R
R 2.13.0 released · 2011-04-13
0.1-7
2010-10-17 · diff ↗
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
2009-10-20 · diff ↗
0.1-5
2009-10-14 · diff ↗
R
R 2.9.0 released · 2009-04-17
0.1-4
2009-01-28 · diff ↗
0.1-3
2008-12-14 · diff ↗
0.1-2
2008-11-03 · diff ↗
0.1-1
2008-10-29 · diff ↗
R
R 2.8.0 released · 2008-10-20
0.1-0
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
Minimum R: ≥ 3.4.0
Download size: 552 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Appears in task views

Databases with R Analysis of Spatial Data

Report a problem with this page →