Package: dbProject 0.1.1

Edward C. Ruiz

dbProject: Database Connection Management and Utilities for 'dbverse'

Provides an R6-based project container for managing 'DuckDB' connections, reconnecting lazy database tables after session restarts, and storing metadata for database-backed objects used by packages in the 'dbverse'. The package supplies S4 base classes and generics for database-backed data, helpers for validating 'DuckDB' connections and table names, utilities for creating persistent database views, and methods for writing and restoring pinned lazy tables through the 'pins' package. These tools help package authors and analysts keep database paths, cached connections, and table references synchronized across interactive sessions and project directories.

Authors:Edward C. Ruiz [aut, cre], Jiaji George Chen [aut], Ruben Dries [aut]

dbProject_0.1.1.tar.gz
dbProject_0.1.1.zip(r-4.7)dbProject_0.1.1.zip(r-4.6)dbProject_0.1.1.zip(r-4.5)
dbProject_0.1.1.tgz(r-4.6-any)dbProject_0.1.1.tgz(r-4.5-any)
dbProject_0.1.1.tar.gz(r-4.7-any)dbProject_0.1.1.tar.gz(r-4.6-any)
dbProject_0.1.1.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
dbProject/json (API)

# Install 'dbProject' in R:
install.packages('dbProject', repos = c('https://dbverse-org.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/dbverse-org/dbproject-r/issues

Pkgdown/docs site:https://dbverse-org.github.io

On CRAN:

Conda:

6.26 score 1 stars 4 packages 5 scripts 439 downloads 16 exports 40 dependencies

Last updated from:2098396e74. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK157
source / vignettesOK220
linux-release-x86_64OK152
macos-release-arm64OK102
macos-oldrel-arm64OK106
windows-develOK87
windows-releaseOK107
windows-oldrelOK80
wasm-releaseOK156

Exports:.check_con.check_name.check_overwrite.check_tblconnconn<-connection_pin_readdbListdbLoaddbProjectdbReconnectis_viewread_pin_connto_viewunique_table_namewrite_pin_conn

Dependencies:askpassblobcliconnectionscpp11curlDBIdbplyrdigestdplyrduckdbfsgenericsgluehttrjsonlitelifecyclemagrittrmimeopensslpillarpinspkgconfigpurrrR6rappdirsrlangrscontractstringistringrsystibbletidyrtidyselectutf8uuidvctrswhiskerwithryaml

Connection Management
The Problem | dbProject's Solution | DBI Compatibility | Convenience Features | Core Concepts | Mutable State (R6) | Centralized Management | Automatic Reconnection | Working with Pins
Rendered fromconnection-management.Rmdusingknitr::rmarkdown

Last update: 2026-05-07
Started: 2025-12-29

Troubleshooting & FAQ
Database Lock Errors | Error: "Could not set lock on file" | Connection Issues | Error: "No active or cached connection available" | Objects showing "Error: Column references ..." after restart | Memory Issues | Large datasets causing R to crash | Package-Specific Issues | dbMatrix: Slow operations after many transformations | Getting Help
Rendered fromtroubleshooting.Rmdusingknitr::rmarkdown

Last update: 2026-05-07
Started: 2026-01-12

Getting Started
Introduction | Creating a dbProject | Working with Data | Pinning Tables | Disconnecting and Reconnecting | Reading Pinned Tables | Cleanup
Rendered fromgetting_started.Rmdusingknitr::rmarkdown

Last update: 2026-01-12
Started: 2025-02-28

Readme and manuals

Help Manual

Help pageTopics
Read a pinned dbMatrix object from a boardconnection_pin_read
Virtual Base Class for Database-Backed Data ObjectsdbData-class
Connection accessor methods for dbData objectsconn conn,dbData-method conn<- conn<-,dbData-method dbData-connection-accessors
Extract and replace methods for dbData objectsdbData-extract [ [,dbData-method [<-,dbData-method
List remote tables, temporary tables, and viewsdbList
List remote tables, temporary tables, and viewsdbList,DBIConnection-method
Load a dbverse object from the databasedbLoad
dbProject: database connection and table managementdbProject
Reconnect database connection for dbData objectsdbReconnect dbReconnect,connConnection-method dbReconnect,dbData-method dbReconnect,DBIConnection-method
Read Pin Connection Genericread_pin_conn
Read a pinned dbMatrix from pins boardread_pin_conn.conn_matrix_table
Read a pinned dbSpatial object from a pins boardread_pin_conn.conn_spatial_table
Convert lazy table to named viewto_view
Convert lazy table to named VIEWto_view,ANY-method
Write Pin Connection Genericwrite_pin_conn
Write a dbMatrix object to a pins boardwrite_pin_conn.dbMatrix
Write a dbSpatial object to a pins boardwrite_pin_conn.dbSpatial
Default method for write_pin_connwrite_pin_conn.default