{ "_id": "6a29aa4313270861ca8250c8", "Package": "dbi.table", "Type": "Package", "Title": "Database Queries Using 'data.table' Syntax", "Version": "1.0.8", "Description": "Query database tables over a 'DBI' connection using\n'data.table' syntax. Attach database schemas to the search\npath. Automatically merge using foreign key constraints.", "License": "MPL-2.0", "URL": "https://github.com/kjellpk/dbi.table", "BugReports": "https://github.com/kjellpk/dbi.table/issues", "VignetteBuilder": "knitr", "Encoding": "UTF-8", "Authors@R": "c(\nperson(given = c(\"Kjell\", \"P.\"),\nfamily = \"Konis\",\nrole = c(\"aut\", \"cre\"),\nemail = \"kjellk@gmail.com\"),\nperson(given = \"Luis\",\nfamily = \"Rocha\",\nrole = \"ctb\",\ncomment = \"Chinook Database - see example_files/LICENSE\")\n)", "Config/testthat/edition": "3", "Config/roxygen2/version": "8.0.0", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://kjellpk.r-universe.dev", "Date/Publication": "2026-06-10 18:01:13 UTC", "RemoteUrl": "https://github.com/kjellpk/dbi.table", "RemoteRef": "HEAD", "RemoteSha": "802b17fd001f6f049b031d328065737fe03662d5", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-10 18:13:48 UTC", "User": "root" }, "Author": "Kjell P. Konis [aut, cre],\nLuis Rocha [ctb] (Chinook Database - see example_files/LICENSE)", "Maintainer": "Kjell P. Konis ", "MD5sum": "ea07a2fa725751f4b9a763305004cd13", "_user": "kjellpk", "_type": "src", "_file": "dbi.table_1.0.8.tar.gz", "_fileid": "fd61777f64c92d0fa090db4a2cdf1c8b854b33f52430c102c13e5de2f561595d", "_filesize": 359556, "_sha256": "fd61777f64c92d0fa090db4a2cdf1c8b854b33f52430c102c13e5de2f561595d", "_created": "2026-06-10T18:13:48.000Z", "_published": "2026-06-10T18:17:39.698Z", "_distro": "noble", "_jobs": [ { "job": 80630631621, "time": 177, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7544292946" }, { "job": 80630631547, "time": 161, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7544286582" }, { "job": 80630631556, "time": 195, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7544300355" }, { "job": 80630631607, "time": 125, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7544271402" }, { "job": 80629858133, "time": 225, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7544219950" }, { "job": 80630631550, "time": 112, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7544266633" }, { "job": 80630631631, "time": 118, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7544268846" }, { "job": 80630631665, "time": 176, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7544293198" }, { "job": 80630631604, "time": 152, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7544283595" } ], "_buildurl": "https://github.com/r-universe/kjellpk/actions/runs/27296309231", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/kjellpk/dbi.table", "_commit": { "id": "802b17fd001f6f049b031d328065737fe03662d5", "author": "Kjell Konis ", "committer": "Kjell Konis ", "message": "Detach by name rather than position.\n", "time": 1781114473 }, "_maintainer": { "name": "Kjell P. Konis", "email": "kjellk@gmail.com", "login": "kjellpk", "description": "", "uuid": 13562939 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.6.0", "role": "Depends" }, { "package": "DBI", "role": "Imports" }, { "package": "bit64", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "stringi", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "RMariaDB", "role": "Suggests" }, { "package": "RPostgres", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "data.table", "role": "Suggests" }, { "package": "duckdb", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "kjellpk", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-24", "n": 1 }, { "week": "2025-26", "n": 2 }, { "week": "2025-38", "n": 3 }, { "week": "2025-42", "n": 2 }, { "week": "2025-48", "n": 2 }, { "week": "2025-49", "n": 2 }, { "week": "2026-01", "n": 2 }, { "week": "2026-02", "n": 1 }, { "week": "2026-07", "n": 1 }, { "week": "2026-08", "n": 4 }, { "week": "2026-09", "n": 4 }, { "week": "2026-10", "n": 4 }, { "week": "2026-22", "n": 4 }, { "week": "2026-23", "n": 2 }, { "week": "2026-24", "n": 4 } ], "_tags": [ { "name": "v1.0.5", "date": "2025-09-19" }, { "name": "v1.0.6", "date": "2026-01-03" }, { "name": "v1.0.7", "date": "2026-03-01" } ], "_stars": 15, "_contributors": [ { "user": "kjellpk", "count": 427, "uuid": 13562939 }, { "user": "hadley", "count": 1, "uuid": 4196 }, { "user": "michaelchirico", "count": 1, "uuid": 7606389 } ], "_userbio": { "uuid": 13562939, "type": "user", "name": "Kjell Konis" }, "_downloads": { "count": 195, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dbi.table" }, "_devurl": "https://github.com/kjellpk/dbi.table", "_searchresults": 6, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dbi.table.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/kjellpk/dbi.table", "_realowner": "kjellpk", "_cranurl": true, "_releases": [ { "version": "1.0.1", "date": "2024-12-10" }, { "version": "1.0.3", "date": "2025-02-04" }, { "version": "1.0.4", "date": "2025-06-28" }, { "version": "1.0.5", "date": "2025-09-19" }, { "version": "1.0.6", "date": "2026-01-11" }, { "version": "1.0.7", "date": "2026-03-01" } ], "_exports": [ "as.dbi.table", "chinook.duckdb", "chinook.sqlite", "csql", "dbAppendTable", "dbCreateTable", "dbExecute", "dbGetInfo", "dbGetQuery", "dbi.attach", "dbi.catalog", "dbi.table", "dbListFields", "dbListObjects", "dbQuoteIdentifier", "dbQuoteLiteral", "dbQuoteString", "dbReadTable", "dbRemoveTable", "dbSendStatement", "dbWithTransaction", "dbWriteTable", "is.dbi.table", "reference.test", "sql.join" ], "_help": [ { "page": "dbi.table-package", "title": "DBI Table", "topics": [ "dbi.table-package", "dbi.table", "[.dbi.table" ] }, { "page": "as.data.frame", "title": "Coerce to a Data Frame", "topics": [ "as.data.frame", "as.data.frame.dbi.table" ] }, { "page": "as.dbi.table", "title": "Coerce to DBI Table", "topics": [ "as.dbi.table", "is.dbi.table" ] }, { "page": "csql", "title": "See SQL", "topics": [ "csql" ] }, { "page": "dbi.attach", "title": "Attach a Database Schema to the Search Path", "topics": [ "dbi.attach" ] }, { "page": "dbi.catalog", "title": "Create a 'dbi.catalog'", "topics": [ "dbi.catalog" ] }, { "page": "DBI-methods", "title": "DBI Methods for 'dbi.table's", "topics": [ "dbAppendTable,dbi.catalog-method", "dbAppendTable,dbi.schema-method", "dbAppendTable,dbi.table-method", "dbCreateTable,dbi.catalog-method", "dbCreateTable,dbi.schema-method", "dbCreateTable,dbi.table-method", "dbExecute,dbi.catalog,ANY-method", "dbExecute,dbi.catalog-method", "dbExecute,dbi.schema,ANY-method", "dbExecute,dbi.schema-method", "dbExecute,dbi.table,ANY-method", "dbExecute,dbi.table-method", "dbGetInfo,dbi.catalog-method", "dbGetInfo,dbi.schema-method", "dbGetInfo,dbi.table-method", "dbGetQuery,dbi.catalog,ANY-method", "dbGetQuery,dbi.catalog-method", "dbGetQuery,dbi.schema,ANY-method", "dbGetQuery,dbi.schema-method", "dbGetQuery,dbi.table,ANY-method", "dbGetQuery,dbi.table,missing-method", "dbGetQuery,dbi.table-method", "dbi.table.DBI", "dbListFields,dbi.catalog,ANY-method", "dbListFields,dbi.catalog-method", "dbListFields,dbi.schema,ANY-method", "dbListFields,dbi.schema-method", "dbListFields,dbi.table,ANY-method", "dbListFields,dbi.table-method", "dbListObjects,dbi.catalog-method", "dbListObjects,dbi.schema-method", "dbListObjects,dbi.table-method", "dbQuoteIdentifier,dbi.catalog,ANY-method", "dbQuoteIdentifier,dbi.catalog-method", "dbQuoteIdentifier,dbi.schema,ANY-method", "dbQuoteIdentifier,dbi.schema-method", "dbQuoteIdentifier,dbi.table,ANY-method", "dbQuoteIdentifier,dbi.table-method", "dbQuoteLiteral,dbi.catalog-method", "dbQuoteLiteral,dbi.schema-method", "dbQuoteLiteral,dbi.table-method", "dbQuoteString,dbi.catalog,ANY-method", "dbQuoteString,dbi.catalog-method", "dbQuoteString,dbi.schema,ANY-method", "dbQuoteString,dbi.schema-method", "dbQuoteString,dbi.table,ANY-method", "dbQuoteString,dbi.table-method", "dbReadTable,dbi.catalog,ANY-method", "dbReadTable,dbi.catalog-method", "dbReadTable,dbi.schema,ANY-method", "dbReadTable,dbi.schema-method", "dbReadTable,dbi.table,ANY-method", "dbReadTable,dbi.table-method", "dbRemoveTable,dbi.catalog,ANY-method", "dbRemoveTable,dbi.catalog-method", "dbRemoveTable,dbi.schema,ANY-method", "dbRemoveTable,dbi.schema-method", "dbRemoveTable,dbi.table,ANY-method", "dbRemoveTable,dbi.table-method", "dbSendStatement,dbi.catalog,ANY-method", "dbSendStatement,dbi.catalog-method", "dbSendStatement,dbi.schema,ANY-method", "dbSendStatement,dbi.schema-method", "dbSendStatement,dbi.table,ANY-method", "dbSendStatement,dbi.table,missing-method", "dbSendStatement,dbi.table-method", "dbWithTransaction,dbi.catalog-method", "dbWithTransaction,dbi.schema-method", "dbWithTransaction,dbi.table-method", "dbWriteTable,dbi.catalog,ANY-method", "dbWriteTable,dbi.catalog-method", "dbWriteTable,dbi.schema,ANY-method", "dbWriteTable,dbi.schema-method", "dbWriteTable,dbi.table,ANY-method", "dbWriteTable,dbi.table-method" ] }, { "page": "example_databases", "title": "Example Databases", "topics": [ "chinook.duckdb", "chinook.sqlite", "example_databases" ] }, { "page": "merge", "title": "Merge two dbi.tables", "topics": [ "merge", "merge.dbi.table" ] }, { "page": "reference.test", "title": "Test 'dbi.table' vs. Reference Implementation", "topics": [ "reference.test" ] }, { "page": "sql.join", "title": "Join 'dbi.table's", "topics": [ "sql.join" ] } ], "_readme": "https://github.com/kjellpk/dbi.table/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cli", "cpp11", "DBI", "dbplyr", "dplyr", "generics", "glue", "lifecycle", "magrittr", "pillar", "pkgconfig", "purrr", "R6", "rlang", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "utf8", "vctrs", "withr" ], "_vignettes": [ { "source": "introduction_to_dbi_table.Rmd", "filename": "introduction_to_dbi_table.html", "title": "Introduction to dbi.table", "engine": "knitr::rmarkdown", "headings": [ "Installation", "Getting Started", "Create a Single dbi.table", "Manipulate a dbi.table using data.table Syntax", "Attach a Schema to the Search Path", "Merging dbi.tables", "Load a Database Catalog", "Scope", "Cleaning Up", "Connection Management" ], "created": "2024-10-19 15:33:39", "modified": "2025-06-15 14:18:34", "commits": 9 } ], "_score": 6.352182518111363, "_indexed": true, "_nocasepkg": "dbi.table", "_universes": [ "kjellpk" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.8", "date": "2026-06-10T18:16:10.000Z", "distro": "noble", "commit": "802b17fd001f6f049b031d328065737fe03662d5", "fileid": "4bef0712a5a6727304fd4d1e1cb6980d43b0e3d3084ef93bdcff60061c4dbc9a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/kjellpk/actions/runs/27296309231" }, { "r": "4.6.0", "os": "linux", "version": "1.0.8", "date": "2026-06-10T18:15:59.000Z", "distro": "noble", "commit": "802b17fd001f6f049b031d328065737fe03662d5", "fileid": "5c329acc50d6c2178da35bb59b84cb5f969c90a5d45b791c170e9d47f8376165", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/kjellpk/actions/runs/27296309231" }, { "r": "4.5.3", "os": "mac", "version": "1.0.8", "date": "2026-06-10T18:15:43.000Z", "commit": "802b17fd001f6f049b031d328065737fe03662d5", "fileid": "b4f704548043ebc45cf024acbbc897a0c527fdd488c5b82a15ad3b717567d8dd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/kjellpk/actions/runs/27296309231" }, { "r": "4.6.0", "os": "mac", "version": "1.0.8", "date": "2026-06-10T18:15:28.000Z", "commit": "802b17fd001f6f049b031d328065737fe03662d5", "fileid": "05398f633bb77f989077db86eb2169b97d40230b97b6db90214a638d54c8c7e7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/kjellpk/actions/runs/27296309231" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.8", "date": "2026-06-10T18:15:56.000Z", "commit": "802b17fd001f6f049b031d328065737fe03662d5", "fileid": "cf29e161c45636960def7f1d44d60815f60f665f566ea722c3d41a8a9e798a54", "status": "success", "buildurl": "https://github.com/r-universe/kjellpk/actions/runs/27296309231" }, { "r": "4.7.0", "os": "win", "version": "1.0.8", "date": "2026-06-10T18:15:01.000Z", "commit": "802b17fd001f6f049b031d328065737fe03662d5", "fileid": "b1cc997fdcb2b85b7f3db80c3c0061d9a7b821d5bcfa29a8e465150b9e4ca91b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/kjellpk/actions/runs/27296309231" }, { "r": "4.5.3", "os": "win", "version": "1.0.8", "date": "2026-06-10T18:15:48.000Z", "commit": "802b17fd001f6f049b031d328065737fe03662d5", "fileid": "64b53f3710a1c025360c0ed6704f20aac50760881358553168add45227e13ca2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/kjellpk/actions/runs/27296309231" }, { "r": "4.6.0", "os": "win", "version": "1.0.8", "date": "2026-06-10T18:15:12.000Z", "commit": "802b17fd001f6f049b031d328065737fe03662d5", "fileid": "a343935063c99280a9275ce889daba627bda6355ae09721835a6af1fdc4f62d6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/kjellpk/actions/runs/27296309231" } ] }