r-dbi/RPostgres

View on GitHub

A DBI-compliant interface to PostgreSQL

Stars: 343
Forks: 82
Open beginner issues: 0
Indexed issues: 27
Avg merge: 11h 26m
Merged PRs (30d): 9

Dominant language: R
License: No license data
Last GitHub push: Sep 15, 2026
Latest indexed: Sep 20, 2026
Contributing guide: Contributing guide
Code of conduct: Code of conduct
Beginner labels: help wanted

Beginner friendly Everything

Open All

27 open issues indexed

Expose SQLSTATE (and other diagnostic fields) on error conditions Open

Difficulty 4/5 3-5 days Newbie friendliness 52/100

r-dbi/RPostgres#579 · 2 comments · Opened Jun 3, 2026
Error in dbConnect(): linux socket location moved Open

Difficulty 3/5 1-2 days Newbie friendliness 55/100

r-dbi/RPostgres#564 · Opened Apr 8, 2026
Align `postgresDefault()` with other Postgres libraries Open

r-dbi/RPostgres#552 · 1 reaction · 2 assignees · Opened Feb 21, 2026
Support for OAuth Authorization Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

r-dbi/RPostgres#528 · Opened Oct 20, 2025
pgpass not used? Open

Difficulty 4/5 3-5 days Newbie friendliness 30/100

r-dbi/RPostgres#527 · 1 comment · Opened Oct 10, 2025
"! Multiple queries must use the same column names." when issuing a query against a Postgres server running with the pg_duckdb extension Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

r-dbi/RPostgres#526 · 2 comments · Opened Sep 30, 2025
User defined ENUM types are `NA` Open

bug help wanted

Difficulty 4/5 3-5 days Newbie friendliness 42/100

r-dbi/RPostgres#509 · 2 comments · Opened May 23, 2025
Support for QuestDB - SAVEPOINT exclusion Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

r-dbi/RPostgres#482 · 2 comments · Opened Dec 10, 2024
I'm trying to connect to a Neon DB hosted behind a Replit deployment, result: "Error:" Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

r-dbi/RPostgres#476 · 3 comments · Opened Dec 3, 2024
dbGetQuery failing due to stale Redshift OIDs Open

help wanted

Difficulty 4/5 3-5 days Newbie friendliness 35/100

r-dbi/RPostgres#469 · 6 comments · Opened Jul 16, 2024
Configuration failed because libpq was not found. Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

r-dbi/RPostgres#468 · 7 comments · Opened Jun 5, 2024
Option to convert "enum" types to factor or character? Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

r-dbi/RPostgres#455 · 11 comments · Opened Jan 18, 2024
RPostgres should respect system timezone rather than default to UTC Open

Difficulty 4/5 3-5 days Newbie friendliness 30/100

r-dbi/RPostgres#452 · 9 comments · Opened Dec 8, 2023
vendoring cpp11 headers Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

r-dbi/RPostgres#450 · 1 comment · Opened Nov 8, 2023
How to deal with `pq__varchar` columns Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

r-dbi/RPostgres#444 · 15 comments · Opened Oct 10, 2023
Something wrong with the 1.4.5 Mac binary on CRAN with Redshift Open

help wanted

Difficulty 4/5 3-5 days Newbie friendliness 30/100

r-dbi/RPostgres#441 · 33 comments · 2 reactions · Opened Sep 1, 2023
Schema with DBI::Id appears not to work with `dbListTables` Open

bug help wanted

Difficulty 4/5 3-5 days Newbie friendliness 30/100

r-dbi/RPostgres#432 · 4 comments · Opened Mar 29, 2023
Curious bug with transaction and `dbSendQuery()` Open

bug reprex

Difficulty 4/5 3-5 days Newbie friendliness 25/100

r-dbi/RPostgres#424 · 6 comments · Opened Mar 9, 2023
using databases.pacha.dev for testing Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

r-dbi/RPostgres#422 · 4 comments · Opened Jan 30, 2023
Unable to create table with logical column Open

docs help wanted

Difficulty 3/5 1-2 days Newbie friendliness 48/100

r-dbi/RPostgres#430 · 4 comments · Opened Jan 13, 2023
List tables in schema with dbListTables Open

docs help wanted

Difficulty 2/5 1-3 hours Newbie friendliness 55/100

r-dbi/RPostgres#399 · 4 comments · Opened Jul 8, 2022
Are limitations of select() hurting us? Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

r-dbi/RPostgres#397 · 1 comment · Opened May 6, 2022
INSERT with placeholders via dbExecute does not work Open

docs help wanted

Difficulty 3/5 1-2 days Newbie friendliness 42/100

r-dbi/RPostgres#391 · 4 comments · Opened Jan 31, 2022
`dbListObjects()` does not list empty schemata Open

Difficulty 3/5 1-2 days Newbie friendliness 48/100

r-dbi/RPostgres#388 · 4 comments · Opened Dec 30, 2021
Connection attempt to arcadedb (supports the Postgres wire format for connection and queries) fails with "received invalid response to GSSAPI negotiation: R" Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

r-dbi/RPostgres#363 · 17 comments · Opened Dec 2, 2021
Non-blocking queries Open

feature help wanted

Difficulty 5/5 Over a week Newbie friendliness 25/100

r-dbi/RPostgres#299 · 27 comments · 1 reaction · Opened Apr 5, 2021
materialized views in dbListTables() Open

feature

Difficulty 3/5 1-2 days Newbie friendliness 35/100

r-dbi/RPostgres#251 · 7 comments · Opened Aug 17, 2020

r-dbi/RPostgres

Get new issues in your inbox