{ "_id": "6a102a38acfb0bcc41c91e33", "Package": "csdb", "Title": "An Abstracted System for Easily Working with Databases with\nLarge Datasets", "Version": "2026.5.13", "Authors@R": "c(\nperson(c(\"Richard\",\"Aubrey\"), \"White\", email = \"hello@rwhite.no\", role = c(\"aut\", \"cre\"), comment = c(ORCID = \"0000-0002-6747-1726\")),\nperson(c(\"August\", \"Sørli\"), \"Mathisen\", email = \"august.sorli.mathisen@fhi.no\", role = c(\"aut\"))\n)", "Description": "Provides object-oriented database management tools for\nworking with large datasets across multiple database systems.\nFeatures include robust connection management for 'PostgreSQL'\ndatabases, advanced table operations with bulk data loading and\nupsert functionality, comprehensive data validation through\ncustomizable field type and content validators, efficient index\nmanagement, and cross-database compatibility. Designed for\nhigh-performance data operations in surveillance systems and\nlarge-scale data processing workflows.", "License": "MIT + file LICENSE", "URL": "https://niphr.github.io/csdb/, https://github.com/niphr/csdb", "BugReports": "https://github.com/niphr/csdb/issues", "Encoding": "UTF-8", "LazyData": "true", "RoxygenNote": "7.3.3", "VignetteBuilder": "knitr", "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev unixodbc-dev", "Repository": "https://niphr.r-universe.dev", "Date/Publication": "2026-05-13 04:31:58 UTC", "RemoteUrl": "https://github.com/niphr/csdb", "RemoteRef": "HEAD", "RemoteSha": "b7be7fac67e02ffbafeca8b3ca53e8b5d8622345", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-13 07:02:00 UTC", "User": "root" }, "Author": "Richard Aubrey White [aut, cre] (ORCID:\n),\nAugust Sørli Mathisen [aut]", "Maintainer": "Richard Aubrey White ", "MD5sum": "9b967e9b4c74e91ff7225818d6e43abb", "_user": "niphr", "_type": "src", "_file": "csdb_2026.5.13.tar.gz", "_fileid": "4276f5cfe4d3b7ab509e970c0cc0044b702f973c427fc011fa5265193134a760", "_filesize": 282522, "_sha256": "4276f5cfe4d3b7ab509e970c0cc0044b702f973c427fc011fa5265193134a760", "_created": "2026-05-13T07:02:00.000Z", "_published": "2026-05-22T10:04:40.285Z", "_distro": "noble", "_jobs": [ { "job": 77358223336, "time": 148, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "6963644155" }, { "job": 77358223703, "time": 165, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "6963648974" }, { "job": 77358224007, "time": 155, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "6963805339" }, { "job": 77358224073, "time": 240, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "6963727114" }, { "job": 77358222925, "time": 200, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "6963600360" }, { "job": 77358222811, "time": 114, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7157922645" }, { "job": 77358223913, "time": 129, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "6963637172" }, { "job": 77358223311, "time": 114, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "6963633228" }, { "job": 77358223818, "time": 142, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "6963640730" } ], "_buildurl": "https://github.com/r-universe/niphr/actions/runs/25783632299", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/niphr/csdb", "_commit": { "id": "b7be7fac67e02ffbafeca8b3ca53e8b5d8622345", "author": "Richard Aubrey White ", "committer": "GitHub ", "message": "Merge pull request #4 from niphr/fix/quote-set-role-identifier\n\nQuote role identifier in PostgreSQL SET ROLE statements", "time": 1778646718 }, "_maintainer": { "name": "Richard Aubrey White", "email": "hello@rwhite.no", "login": "raubreywhite", "orcid": "0000-0002-6747-1726", "twitter": "@raubreywhite", "uuid": 1532091 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "csutil", "role": "Imports" }, { "package": "data.table", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "fs", "role": "Imports" }, { "package": "ggplot2", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "odbc", "role": "Imports" }, { "package": "R6", "role": "Imports" }, { "package": "S7", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "uuid", "role": "Imports" }, { "package": "testthat", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "rstudioapi", "role": "Suggests" }, { "package": "digest", "role": "Suggests" }, { "package": "crayon", "role": "Suggests" } ], "_owner": "niphr", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-29", "n": 11 }, { "week": "2025-31", "n": 2 }, { "week": "2025-34", "n": 2 }, { "week": "2025-52", "n": 4 }, { "week": "2026-05", "n": 2 }, { "week": "2026-06", "n": 2 }, { "week": "2026-14", "n": 1 }, { "week": "2026-20", "n": 1 } ], "_tags": [], "_topics": [ "csverse" ], "_stars": 1, "_contributors": [ { "user": "raubreywhite", "count": 126, "uuid": 1532091 }, { "user": "augustmathisen", "count": 2, "uuid": 160852733 } ], "_userbio": { "uuid": 244534951, "type": "organization", "name": "Norwegian Institute of Public Health - R codebases", "description": "The Norwegian Institute of Public Health is a government agency under the Ministry of Health and Care Services." }, "_downloads": { "count": 504, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/csdb" }, "_devurl": "https://github.com/niphr/csdb", "_pkgdown": "https://niphr.github.io/csdb/", "_searchresults": 0, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/csdb.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/niphr/csdb", "_realowner": "niphr", "_cranurl": true, "_releases": [ { "version": "2025.7.30", "date": "2025-08-18" }, { "version": "2026.2.2", "date": "2026-03-31" }, { "version": "2026.5.13", "date": "2026-05-13" } ], "_exports": [ "csdb_get_auth_hook", "csdb_set_auth_hook", "DBConnection_v9", "DBTable_v9", "get_table_names_and_info", "validator_field_contents_blank", "validator_field_contents_csfmt_rts_data_v1", "validator_field_contents_csfmt_rts_data_v2", "validator_field_types_blank", "validator_field_types_csfmt_rts_data_v1", "validator_field_types_csfmt_rts_data_v2" ], "_datasets": [ { "name": "nor_covid19_cases_by_time_location", "title": "Covid-19 data for PCR-confirmed cases in Norway (nation and county)", "object": "nor_covid19_cases_by_time_location", "class": [ "data.table", "data.frame" ], "fields": [ "granularity_time", "granularity_geo", "country_iso3", "location_code", "border", "age", "sex", "isoyear", "isoweek", "isoyearweek", "season", "seasonweek", "calyear", "calmonth", "calyearmonth", "date", "covid19_cases_testdate_n", "covid19_cases_testdate_pr100000" ], "rows": 11028, "table": true, "tojson": true } ], "_help": [ { "page": "csdb_get_auth_hook", "title": "Get the current authentication hook", "topics": [ "csdb_get_auth_hook" ] }, { "page": "csdb_set_auth_hook", "title": "Set authentication hook for database connections", "topics": [ "csdb_set_auth_hook" ] }, { "page": "DBConnection_v9", "title": "R6 Class representing a database connection", "topics": [ "DBConnection_v9" ] }, { "page": "DBTable_v9", "title": "R6 Class representing a database table with advanced data management capabilities", "topics": [ "DBTable_v9" ] }, { "page": "get_table_names_and_info", "title": "Get table names, number of rows, and size information", "topics": [ "get_table_names_and_info" ] }, { "page": "nor_covid19_cases_by_time_location", "title": "Covid-19 data for PCR-confirmed cases in Norway (nation and county)", "topics": [ "nor_covid19_cases_by_time_location" ] }, { "page": "validator_field_contents_blank", "title": "Blank data contents validator", "topics": [ "validator_field_contents_blank" ] }, { "page": "validator_field_contents_csfmt_rts_data_v1", "title": "Field contents validator for csfmt_rts_data_v1 schema", "topics": [ "validator_field_contents_csfmt_rts_data_v1" ] }, { "page": "validator_field_contents_csfmt_rts_data_v2", "title": "Field contents validator for csfmt_rts_data_v2 schema", "topics": [ "validator_field_contents_csfmt_rts_data_v2" ] }, { "page": "validator_field_types_blank", "title": "Blank field types validator", "topics": [ "validator_field_types_blank" ] }, { "page": "validator_field_types_csfmt_rts_data_v1", "title": "Field types validator for csfmt_rts_data_v1 schema", "topics": [ "validator_field_types_csfmt_rts_data_v1" ] }, { "page": "validator_field_types_csfmt_rts_data_v2", "title": "Field types validator for csfmt_rts_data_v2 schema", "topics": [ "validator_field_types_csfmt_rts_data_v2" ] } ], "_pkglogo": "https://github.com/niphr/csdb/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/niphr/csdb/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cli", "cpp11", "csutil", "data.table", "DBI", "dplyr", "farver", "fs", "generics", "ggplot2", "glue", "gtable", "hms", "isoband", "labeling", "lifecycle", "magrittr", "odbc", "pillar", "pkgconfig", "R6", "RColorBrewer", "Rcpp", "rlang", "S7", "scales", "stringi", "stringr", "tibble", "tidyselect", "utf8", "uuid", "vctrs", "viridisLite", "withr" ], "_vignettes": [ { "source": "csdb.Rmd", "filename": "csdb.html", "title": "Introduction to csdb", "author": "Richard Aubrey White", "engine": "knitr::rmarkdown", "headings": [ "Concept" ], "created": "2023-03-03 03:21:20", "modified": "2025-07-19 18:11:14", "commits": 6 } ], "_score": 4.6020599913279625, "_indexed": true, "_nocasepkg": "csdb", "_universes": [ "niphr", "raubreywhite" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "2026.5.13", "date": "2026-05-13T07:04:25.000Z", "distro": "noble", "commit": "b7be7fac67e02ffbafeca8b3ca53e8b5d8622345", "fileid": "b301b3705d868c8010898b056d72e99dced76a0dd44a1721d5e35e676a03047c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/niphr/actions/runs/25783632299" }, { "r": "4.6.0", "os": "linux", "version": "2026.5.13", "date": "2026-05-13T07:04:41.000Z", "distro": "noble", "commit": "b7be7fac67e02ffbafeca8b3ca53e8b5d8622345", "fileid": "76f45ca3c1c5fef6ca6ec5627b5211559742ec2393c188a6b31ae4c3360792b1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/niphr/actions/runs/25783632299" }, { "r": "4.5.3", "os": "mac", "version": "2026.5.13", "date": "2026-05-13T07:13:46.000Z", "commit": "b7be7fac67e02ffbafeca8b3ca53e8b5d8622345", "fileid": "541d598d3640db757eecafd73f90cfd95ee7d44daff0a4007f3b5690e5d3ccd6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/niphr/actions/runs/25783632299" }, { "r": "4.6.0", "os": "mac", "version": "2026.5.13", "date": "2026-05-13T07:09:11.000Z", "commit": "b7be7fac67e02ffbafeca8b3ca53e8b5d8622345", "fileid": "6cf11dd2834f3370ad69ded851bb14e39070281a868e58cfc4a4cb896e04b37b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/niphr/actions/runs/25783632299" }, { "r": "4.7.0", "os": "win", "version": "2026.5.13", "date": "2026-05-13T07:03:33.000Z", "commit": "b7be7fac67e02ffbafeca8b3ca53e8b5d8622345", "fileid": "9268777ad29f62fb38b27f8daf5dcc2b61e45d8aa6e14ad62d62ee10df9420bb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/niphr/actions/runs/25783632299" }, { "r": "4.5.3", "os": "win", "version": "2026.5.13", "date": "2026-05-13T07:03:39.000Z", "commit": "b7be7fac67e02ffbafeca8b3ca53e8b5d8622345", "fileid": "73deecd2bf01aeb00b4c4aece29873b3fc3ec95b3204b1a787ea6ad36af1c2b2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/niphr/actions/runs/25783632299" }, { "r": "4.6.0", "os": "win", "version": "2026.5.13", "date": "2026-05-13T07:04:08.000Z", "commit": "b7be7fac67e02ffbafeca8b3ca53e8b5d8622345", "fileid": "791091eee649af52b2c977a17e77df4cbc4d63424a62ed4664b600edbe300136", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/niphr/actions/runs/25783632299" }, { "r": "4.6.0", "os": "wasm", "version": "2026.5.13", "date": "2026-05-22T10:04:24.000Z", "commit": "b7be7fac67e02ffbafeca8b3ca53e8b5d8622345", "fileid": "71ce47ec967a0cf739405ea10e0451062180ba3529704ddf40eab103593f6311", "status": "success", "buildurl": "https://github.com/r-universe/niphr/actions/runs/25783632299" } ] }