Learn R Programming

dbProject

The goal of dbProject is to manage dbData objects and database connections in the dbverse ecosystem.

Installation

You can install the development version of dbProject like so:

pak::pak("dbverse-org/dbproject-r")

Example

This is a basic example which shows you how to solve a common problem:

library(dbProject)

project_dir <- tempfile("dbproject_demo")
project <- dbProject$new(path = project_dir)
con <- project$get_conn()

DBI::dbWriteTable(con, "mtcars", mtcars)
DBI::dbReadTable(con, "mtcars")

project$disconnect()
unlink(project_dir, recursive = TRUE)

Copy Link

Version

Install

install.packages('dbProject')

Version

0.1.0

License

MIT + file LICENSE

Issues

Pull Requests

Stars

Forks

Maintainer

Edward C. Ruiz

Last Published

May 7th, 2026

Functions in dbProject (0.1.0)

unique_table_name

Generate unique table names
.check_con

Validate database connection
.check_tbl

Validate dplyr tbl object
.check_overwrite

Validate overwrite parameter and handle existing objects
.check_name

Validate table name
write_pin_conn

Write Pin Connection Generic
write_pin_conn.dbMatrix

Write a dbMatrix object to a pins board
dbLoad

Load a dbverse object from the database
dbData-connection-accessors

Connection accessor methods for dbData objects
connection_pin_read

Read a pinned dbMatrix object from a board
dbList

List remote tables, temporary tables, and views
dbReconnect

Reconnect database connection for dbData objects
dbList,DBIConnection-method

List remote tables, temporary tables, and views
dbData-extract

Extract and replace methods for dbData objects
dbverse-generics

Generic Function Definitions for dbverse
dbProject

dbProject: database connection and table management
dbData-class

Virtual Base Class for Database-Backed Data Objects
read_pin_conn.conn_matrix_table

Read a pinned dbMatrix from pins board
to_view

Convert lazy table to named view
read_pin_conn

Read Pin Connection Generic
read_pin_conn.conn_spatial_table

Read a pinned dbSpatial object from a pins board
write_pin_conn.default

Default method for write_pin_conn
to_view,ANY-method

Convert lazy table to named VIEW
.db_registry

Registry to track live connections
is_view

Check if a database object is a VIEW
write_pin_conn.dbSpatial

Write a dbSpatial object to a pins board