{ "_id": "6a1ef3ddb401979e734156aa", "Package": "dbProject", "Title": "Database Connection Management and Utilities for 'dbverse'", "Version": "0.1.1", "Authors@R": "c(person(\"Edward C.\", \"Ruiz\", , \"ecr7407@gmail.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-9174-5387\")),\nperson(\"Jiaji\", \"George Chen\", email = \"jiajic@bu.edu\", role = c(\"aut\")),\nperson(\"Ruben\", \"Dries\", email = \"rubendries@gmail.com\", role = c(\"aut\")))", "Description": "Provides an R6-based project container for managing\n'DuckDB' connections, reconnecting lazy database tables after\nsession restarts, and storing metadata for database-backed\nobjects used by packages in the 'dbverse'. The package supplies\nS4 base classes and generics for database-backed data, helpers\nfor validating 'DuckDB' connections and table names, utilities\nfor creating persistent database views, and methods for writing\nand restoring pinned lazy tables through the 'pins' package.\nThese tools help package authors and analysts keep database\npaths, cached connections, and table references synchronized\nacross interactive sessions and project directories.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "URL": "https://github.com/dbverse-org/dbproject-r,\nhttps://dbverse-org.github.io/dbproject-r/", "BugReports": "https://github.com/dbverse-org/dbproject-r/issues", "VignetteBuilder": "knitr", "Config/testthat/edition": "3", "Collate": "'classes.R' 'table-reconnection.R' 'connection-registry.R'\n'generics.R' 'connection-methods.R' 'dbList.R' 'dbMatrix-pin.R'\n'dbProject-R6.R' 'dbSpatial-pin.R' 'extract.R' 'imports.R'\n'input-validation.R' 'path-utils.R' 'to_view.R'\n'unique_table_name.R'", "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev libssl-dev\nxz-utils", "Repository": "https://dbverse-org.r-universe.dev", "Date/Publication": "2026-06-02 14:55:57 UTC", "RemoteUrl": "https://github.com/dbverse-org/dbproject-r", "RemoteRef": "HEAD", "RemoteSha": "2098396e74ae5a9907c2038e26831bb44ed09e9b", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-02 15:12:27 UTC", "User": "root" }, "Author": "Edward C. Ruiz [aut, cre] (ORCID:\n),\nJiaji George Chen [aut],\nRuben Dries [aut]", "Maintainer": "Edward C. Ruiz ", "MD5sum": "8475a9c5e4411d00b95adba3be55ae59", "_user": "dbverse-org", "_type": "src", "_file": "dbProject_0.1.1.tar.gz", "_fileid": "2999bfeb39951dbfc124b43423668e38833a04305a061a2587d9f287d91c9c0a", "_filesize": 164449, "_sha256": "2999bfeb39951dbfc124b43423668e38833a04305a061a2587d9f287d91c9c0a", "_created": "2026-06-02T15:12:27.000Z", "_published": "2026-06-02T15:16:45.569Z", "_distro": "noble", "_jobs": [ { "job": 79105148883, "time": 167, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7361911406" }, { "job": 79105148873, "time": 162, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7361909618" }, { "job": 79105148863, "time": 90, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7361932364" }, { "job": 79105148933, "time": 90, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7361934221" }, { "job": 79104382060, "time": 208, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7361832114" }, { "job": 79105148965, "time": 122, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7361891577" }, { "job": 79105149351, "time": 94, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7361878181" }, { "job": 79105148876, "time": 122, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7361894302" }, { "job": 79105149431, "time": 124, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7361891606" } ], "_buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/26828915090", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/dbverse-org/dbproject-r", "_commit": { "id": "2098396e74ae5a9907c2038e26831bb44ed09e9b", "author": "Ed2uiz ", "committer": "Ed2uiz ", "message": "docs: update dbProject CRAN comments\n", "time": 1780412157 }, "_maintainer": { "name": "Edward C. Ruiz", "email": "ecr7407@gmail.com", "login": "ed2uiz", "bluesky": "@ed2uiz.bsky.social", "description": "Open source, spatial omics.", "uuid": 32622519, "orcid": "0000-0002-9174-5387" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "dplyr", "role": "Imports" }, { "package": "duckdb", "version": ">= 1.4.0", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "pins", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "cli", "role": "Imports" }, { "package": "R6", "role": "Imports" }, { "package": "connections", "role": "Imports" }, { "package": "yaml", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "withr", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "dbMatrix", "role": "Suggests" } ], "_owner": "dbverse-org", "_selfowned": true, "_usedby": 5, "_updates": [ { "week": "2025-40", "n": 5 }, { "week": "2025-42", "n": 6 }, { "week": "2026-01", "n": 17 }, { "week": "2026-03", "n": 12 }, { "week": "2026-04", "n": 4 }, { "week": "2026-06", "n": 1 }, { "week": "2026-07", "n": 10 }, { "week": "2026-19", "n": 2 }, { "week": "2026-22", "n": 2 }, { "week": "2026-23", "n": 1 } ], "_tags": [ { "name": "v0.0.0.9001", "date": "2026-01-13" }, { "name": "v0.1.0", "date": "2026-05-04" } ], "_stars": 1, "_contributors": [ { "user": "ed2uiz", "count": 69, "uuid": 32622519 } ], "_userbio": { "uuid": 210240781, "type": "organization", "name": "dbverse-org" }, "_downloads": { "count": 294, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dbProject" }, "_devurl": "https://github.com/dbverse-org/dbproject-r", "_pkgdown": "https://dbverse-org.github.io/dbproject-r/", "_searchresults": 5, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dbProject.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/dbverse-org/dbproject-r", "_realowner": "dbverse-org", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2026-05-07" } ], "_exports": [ ".check_con", ".check_name", ".check_overwrite", ".check_tbl", "conn", "conn<-", "connection_pin_read", "dbList", "dbLoad", "dbProject", "dbReconnect", "is_view", "read_pin_conn", "to_view", "unique_table_name", "write_pin_conn" ], "_help": [ { "page": "connection_pin_read", "title": "Read a pinned dbMatrix object from a board", "topics": [ "connection_pin_read" ] }, { "page": "dbData-class", "title": "Virtual Base Class for Database-Backed Data Objects", "topics": [ "dbData-class" ] }, { "page": "dbData-connection-accessors", "title": "Connection accessor methods for dbData objects", "topics": [ "conn", "conn,dbData-method", "conn<-", "conn<-,dbData-method", "dbData-connection-accessors" ] }, { "page": "dbData-extract", "title": "Extract and replace methods for dbData objects", "topics": [ "dbData-extract", "[", "[,dbData-method", "[<-,dbData-method" ] }, { "page": "dbList", "title": "List remote tables, temporary tables, and views", "topics": [ "dbList" ] }, { "page": "dbList-DBIConnection-method", "title": "List remote tables, temporary tables, and views", "concept": [ "dbData" ], "topics": [ "dbList,DBIConnection-method" ] }, { "page": "dbLoad", "title": "Load a dbverse object from the database", "topics": [ "dbLoad" ] }, { "page": "dbProject", "title": "dbProject: database connection and table management", "topics": [ "dbProject" ] }, { "page": "dbReconnect", "title": "Reconnect database connection for dbData objects", "topics": [ "dbReconnect", "dbReconnect,connConnection-method", "dbReconnect,dbData-method", "dbReconnect,DBIConnection-method" ] }, { "page": "read_pin_conn", "title": "Read Pin Connection Generic", "topics": [ "read_pin_conn" ] }, { "page": "read_pin_conn.conn_matrix_table", "title": "Read a pinned dbMatrix from pins board", "topics": [ "read_pin_conn.conn_matrix_table" ] }, { "page": "read_pin_conn.conn_spatial_table", "title": "Read a pinned dbSpatial object from a pins board", "topics": [ "read_pin_conn.conn_spatial_table" ] }, { "page": "to_view", "title": "Convert lazy table to named view", "topics": [ "to_view" ] }, { "page": "to_view-ANY-method", "title": "Convert lazy table to named VIEW", "concept": [ "dbData" ], "topics": [ "to_view,ANY-method" ] }, { "page": "write_pin_conn", "title": "Write Pin Connection Generic", "topics": [ "write_pin_conn" ] }, { "page": "write_pin_conn.dbMatrix", "title": "Write a dbMatrix object to a pins board", "topics": [ "write_pin_conn.dbMatrix" ] }, { "page": "write_pin_conn.dbSpatial", "title": "Write a dbSpatial object to a pins board", "topics": [ "write_pin_conn.dbSpatial" ] }, { "page": "write_pin_conn.default", "title": "Default method for write_pin_conn", "topics": [ "write_pin_conn.default" ] } ], "_readme": "https://github.com/dbverse-org/dbproject-r/raw/HEAD/README.md", "_rundeps": [ "askpass", "blob", "cli", "connections", "cpp11", "curl", "DBI", "dbplyr", "digest", "dplyr", "duckdb", "fs", "generics", "glue", "httr", "jsonlite", "lifecycle", "magrittr", "mime", "openssl", "pillar", "pins", "pkgconfig", "purrr", "R6", "rappdirs", "rlang", "rscontract", "stringi", "stringr", "sys", "tibble", "tidyr", "tidyselect", "utf8", "uuid", "vctrs", "whisker", "withr", "yaml" ], "_vignettes": [ { "source": "connection-management.Rmd", "filename": "connection-management.html", "title": "Connection Management", "engine": "knitr::rmarkdown", "headings": [ "The Problem", "dbProject's Solution", "DBI Compatibility", "Convenience Features", "Core Concepts", "Mutable State (R6)", "Centralized Management", "Automatic Reconnection", "Working with Pins" ], "created": "2025-12-29 21:19:14", "modified": "2026-05-07 17:11:33", "commits": 2 }, { "source": "getting_started.Rmd", "filename": "getting_started.html", "title": "Getting Started", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Creating a dbProject", "Working with Data", "Pinning Tables", "Disconnecting and Reconnecting", "Reading Pinned Tables", "Cleanup" ], "created": "2025-02-28 19:15:15", "modified": "2026-01-12 20:47:47", "commits": 5 }, { "source": "troubleshooting.Rmd", "filename": "troubleshooting.html", "title": "Troubleshooting & FAQ", "engine": "knitr::rmarkdown", "headings": [ "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" ], "created": "2026-01-12 20:47:52", "modified": "2026-05-07 17:11:33", "commits": 2 } ], "_score": 6.352182518111363, "_indexed": true, "_nocasepkg": "dbproject", "_universes": [ "dbverse-org", "ed2uiz" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.1", "date": "2026-06-02T15:15:12.000Z", "distro": "noble", "commit": "2098396e74ae5a9907c2038e26831bb44ed09e9b", "fileid": "7150ca93d5637609fe88785963f012f7ab3b85b87567f8d661217b4b2bf0379d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/26828915090" }, { "r": "4.6.0", "os": "linux", "version": "0.1.1", "date": "2026-06-02T15:15:10.000Z", "distro": "noble", "commit": "2098396e74ae5a9907c2038e26831bb44ed09e9b", "fileid": "fe34b2a9a8aac324d4e50ef5aad5c8965454ba2afbc1d966d2fc6b0c64cdcff8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/26828915090" }, { "r": "4.5.3", "os": "mac", "version": "0.1.1", "date": "2026-06-02T15:16:04.000Z", "commit": "2098396e74ae5a9907c2038e26831bb44ed09e9b", "fileid": "c80f91dc7b468029330f585586eed80ae36c7a4775bbcc5e8d66a1a5f9e85f0d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/26828915090" }, { "r": "4.6.0", "os": "mac", "version": "0.1.1", "date": "2026-06-02T15:16:11.000Z", "commit": "2098396e74ae5a9907c2038e26831bb44ed09e9b", "fileid": "7e65feab57522c6414b157318db15aa271abe7a3c2383afe860cde29a8a1036d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/26828915090" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.1", "date": "2026-06-02T15:14:52.000Z", "commit": "2098396e74ae5a9907c2038e26831bb44ed09e9b", "fileid": "66e59630205c8f59759c4014d8fe9c53a24d26f6945bd3be5fa0617fc0943d3c", "status": "success", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/26828915090" }, { "r": "4.7.0", "os": "win", "version": "0.1.1", "date": "2026-06-02T15:13:54.000Z", "commit": "2098396e74ae5a9907c2038e26831bb44ed09e9b", "fileid": "3d4aa5906dd7fc7d8848851722c5c208fdddd6f61f7fc99c28e3390e04aabb43", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/26828915090" }, { "r": "4.5.3", "os": "win", "version": "0.1.1", "date": "2026-06-02T15:14:24.000Z", "commit": "2098396e74ae5a9907c2038e26831bb44ed09e9b", "fileid": "551624cd3a371fb8e185446911cc2139fd3c562d6be861336b0caf60a8c09179", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/26828915090" }, { "r": "4.6.0", "os": "win", "version": "0.1.1", "date": "2026-06-02T15:14:24.000Z", "commit": "2098396e74ae5a9907c2038e26831bb44ed09e9b", "fileid": "e0d42e93ed3a787310eeaff181555cc4242ce8bb204f3f156c6ff1ec669f5123", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/26828915090" } ] }