{ "_id": "6ad1f073a6a61792ed76c1bc", "Package": "RTrino", "Title": "'DBI' Backend for 'Trino'", "Version": "0.1.0", "Authors@R": "person(\"Luis A\", \"Casas Ballestas\", email = \"luisangelcasasbl@gmail.com\",\nrole = c(\"aut\", \"cre\", \"cph\"))", "Description": "A 'DBI' compliant backend for 'Trino' ,\nthe distributed SQL query engine (successor of 'PrestoSQL').\nConnects to a 'Trino' cluster over its HTTP REST API, executes\nqueries with automatic pagination, maps 'Trino' types to R\ntypes, and integrates with 'dplyr' through 'dbplyr' SQL\ndialects. Supports basic, JSON Web Token (JWT) bearer and\nOAuth2 client credentials authentication, as well as custom\ncertificate authorities.", "License": "BSD_3_clause + file LICENSE", "Encoding": "UTF-8", "Language": "en-GB", "URL": "https://angelcasasbl.github.io/RTrino/,\nhttps://github.com/AngelCasasbl/RTrino", "BugReports": "https://github.com/AngelCasasbl/RTrino/issues", "Roxygen": "list(markdown = TRUE)", "VignetteBuilder": "knitr", "Config/testthat/edition": "3", "Collate": "'RTrino-package.R' 'TrinoDriver.R' 'TrinoConnection.R'\n'TrinoResult.R' 'utils.R' 'request_headers.R' 'auth.R' 'ssl.R'\n'dbConnect.R' 'dbDisconnect.R' 'dbIsValid.R' 'type_map.R'\n'paginate.R' 'dbSendQuery.R' 'dbFetch.R' 'dbGetQuery.R'\n'dbHasCompleted.R' 'dbClearResult.R' 'table_name.R'\n'dbListTables.R' 'dbExistsTable.R' 'dbListFields.R'\n'dbGetInfo.R' 'dbQuote.R' 'dbDataType.R' 'dbRemoveTable.R'\n'dbRenameTable.R' 'dbCreateTable.R' 'dbAppendTable.R'\n'dbWriteTable.R' 'dbBegin.R' 'dbplyr-dialect.R' 'dbplyr-db.R'\n'dbplyr-simulate.R' 'zzz.R'", "Config/roxygen2/version": "8.1.0", "Config/pak/sysreqs": "libssl-dev", "Repository": "https://angelcasasbl.r-universe.dev", "Date/Publication": "2026-10-02 21:29:16 UTC", "RemoteUrl": "https://github.com/angelcasasbl/rtrino", "RemoteRef": "HEAD", "RemoteSha": "3421e6f508a83f77f6e28d12a70048cd838d8b02", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-16 09:06:12 UTC", "User": "root" }, "Author": "Luis A Casas Ballestas [aut, cre, cph]", "Maintainer": "Luis A Casas Ballestas ", "_user": "angelcasasbl", "_type": "src", "_file": "RTrino_0.1.0.tar.gz", "_fileid": "https://r2.ropensci.org/145ca61e3a5358e7e5526155dcff7e3f1417ecd1bebbb4fdd493eb73a37ef1b3", "_filesize": 265934, "_sha256": "145ca61e3a5358e7e5526155dcff7e3f1417ecd1bebbb4fdd493eb73a37ef1b3", "_expires": "2027-01-24T09:37:54.000Z", "_created": "2026-10-16T09:06:12.000Z", "_published": "2026-10-16T09:37:55.811Z", "_buildurl": "https://github.com/r-universe/angelcasasbl/actions/runs/38877836073", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 116898210717, "time": 167, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12035999499" }, { "job": 116898210822, "time": 159, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12036726092" }, { "job": 116898210836, "time": 193, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "12038410028" }, { "job": 116898210613, "time": 190, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12037727036" }, { "job": 116897179888, "time": 163, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12036396263" }, { "job": 116898210698, "time": 111, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12036028421" }, { "job": 116898210747, "time": 80, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12036312084" }, { "job": 116898210640, "time": 94, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "12036292331" }, { "job": 116898210835, "time": 97, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12036805518" } ], "_upstream": "https://github.com/angelcasasbl/rtrino", "_commit": { "id": "3421e6f508a83f77f6e28d12a70048cd838d8b02", "author": "Luis Angel Casas ", "committer": "Luis A Casas Ballestas ", "message": "Record the final builder results and ignore CRAN-SUBMISSION\n\ncran-comments.md lists the win-builder, macOS builder and GitHub Actions\nenvironments. submit_cran() adds CRAN-SUBMISSION to .Rbuildignore so the\nbookkeeping file stays out of the built package.\n", "time": 1790976556 }, "_maintainer": { "name": "Luis A Casas Ballestas", "email": "luisangelcasasbl@gmail.com", "login": "jumpingsunsub", "description": "", "uuid": 125944109 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "bit64", "role": "Imports" }, { "package": "DBI", "version": ">= 1.2.0", "role": "Imports" }, { "package": "httr2", "version": ">= 1.0.0", "role": "Imports" }, { "package": "jsonlite", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "dbplyr", "version": ">= 2.6.0", "role": "Suggests" }, { "package": "dplyr", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "webfakes", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "angelcasasbl", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-38", "n": 11 }, { "week": "2026-40", "n": 17 } ], "_tags": [], "_topics": [ "backend", "trino" ], "_stars": 1, "_contributors": [ { "user": "angelcasasbl", "count": 28, "uuid": 89464812 } ], "_userbio": { "uuid": 89464812, "type": "user", "name": "Luis A Casas Ballestas", "followers": 1 }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RTrino" }, "_devurl": "https://github.com/angelcasasbl/rtrino", "_pkgdown": "https://angelcasasbl.github.io/RTrino/", "_searchresults": 5, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/RTrino.html", "LICENSE" ], "_homeurl": "https://github.com/angelcasasbl/rtrino", "_realowner": "angelcasasbl", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2026-10-15" } ], "_exports": [ "dbAppendTable", "dbBegin", "dbBind", "dbClearResult", "dbColumnInfo", "dbCommit", "dbConnect", "dbCreateTable", "dbDataType", "dbDisconnect", "dbExecute", "dbExistsTable", "dbFetch", "dbGetInfo", "dbGetQuery", "dbGetRowCount", "dbGetRowsAffected", "dbGetStatement", "dbHasCompleted", "dbIsValid", "dbListFields", "dbListTables", "dbQuoteIdentifier", "dbQuoteLiteral", "dbQuoteString", "dbRemoveTable", "dbRenameTable", "dbRollback", "dbSendQuery", "dbSendStatement", "dbUnloadDriver", "dbWriteTable", "show", "simulate_trino", "Trino", "trino_auth_basic", "trino_auth_jwt", "trino_auth_oauth2", "trino_ssl", "trino_type_to_r" ], "_help": [ { "page": "dbAppendTable-TrinoConnection-method", "title": "Insert rows into an existing table", "topics": [ "dbAppendTable,TrinoConnection-method" ] }, { "page": "dbBegin-TrinoConnection-method", "title": "Start, commit and roll back a transaction", "topics": [ "dbBegin,TrinoConnection-method", "dbCommit,TrinoConnection-method", "dbRollback,TrinoConnection-method" ] }, { "page": "dbBind-TrinoResult-method", "title": "Parameters are not supported", "topics": [ "dbBind,TrinoResult-method" ] }, { "page": "dbClearResult-TrinoResult-method", "title": "Release a Trino result", "topics": [ "dbClearResult,TrinoResult-method" ] }, { "page": "dbConnect-TrinoDriver-method", "title": "Connect to a Trino cluster", "topics": [ "dbConnect,TrinoDriver-method" ] }, { "page": "dbCreateTable-TrinoConnection-method", "title": "Create a table", "topics": [ "dbCreateTable,TrinoConnection-method" ] }, { "page": "dbDataType-TrinoConnection-method", "title": "Map an R type to a Trino type", "topics": [ "dbDataType,TrinoConnection-method" ] }, { "page": "dbDisconnect-TrinoConnection-method", "title": "Disconnect from Trino", "topics": [ "dbDisconnect,TrinoConnection-method" ] }, { "page": "dbExecute-TrinoConnection-character-method", "title": "Execute a statement that returns no rows", "topics": [ "dbExecute,TrinoConnection,character-method" ] }, { "page": "dbExistsTable-TrinoConnection-character-method", "title": "Does a table exist?", "topics": [ "dbExistsTable,TrinoConnection,ANY-method", "dbExistsTable,TrinoConnection,character-method", "dbExistsTable,TrinoConnection,Id-method" ] }, { "page": "dbFetch-TrinoResult-method", "title": "Fetch rows from a Trino result", "topics": [ "dbFetch,TrinoResult-method" ] }, { "page": "dbGetInfo-TrinoConnection-method", "title": "Metadata about a Trino connection", "topics": [ "dbGetInfo,TrinoConnection-method" ] }, { "page": "dbGetQuery-TrinoConnection-character-method", "title": "Run a query and return all of its rows", "topics": [ "dbGetQuery,TrinoConnection,character-method" ] }, { "page": "dbHasCompleted-TrinoResult-method", "title": "Have all rows of a result been consumed?", "topics": [ "dbHasCompleted,TrinoResult-method" ] }, { "page": "dbIsValid-TrinoConnection-method", "title": "Is this connection or result still usable?", "topics": [ "dbIsValid,TrinoConnection-method", "dbIsValid,TrinoResult-method" ] }, { "page": "dbListFields-TrinoConnection-character-method", "title": "List a table's columns", "topics": [ "dbListFields,TrinoConnection,ANY-method", "dbListFields,TrinoConnection,character-method", "dbListFields,TrinoConnection,Id-method" ] }, { "page": "dbListTables-TrinoConnection-method", "title": "List the tables in the connection's schema", "topics": [ "dbListTables,TrinoConnection-method" ] }, { "page": "dbQuoteIdentifier-TrinoConnection-character-method", "title": "Quote identifiers and strings for Trino", "topics": [ "dbQuoteIdentifier,TrinoConnection,character-method", "dbQuoteIdentifier,TrinoConnection,SQL-method", "dbQuoteString,TrinoConnection,character-method", "dbQuoteString,TrinoConnection,SQL-method" ] }, { "page": "dbQuoteLiteral-TrinoConnection-method", "title": "Quote R values as Trino literals", "topics": [ "dbQuoteLiteral,TrinoConnection-method" ] }, { "page": "dbRemoveTable-TrinoConnection-character-method", "title": "Drop a table", "topics": [ "dbRemoveTable,TrinoConnection,ANY-method", "dbRemoveTable,TrinoConnection,character-method", "dbRemoveTable,TrinoConnection,Id-method" ] }, { "page": "dbRenameTable", "title": "Rename a table", "topics": [ "dbRenameTable", "dbRenameTable,TrinoConnection-method" ] }, { "page": "dbSendQuery-TrinoConnection-character-method", "title": "Submit a statement to Trino", "topics": [ "dbSendQuery,TrinoConnection,character-method" ] }, { "page": "dbSendStatement-TrinoConnection-character-method", "title": "Submit a statement that changes something", "topics": [ "dbSendStatement,TrinoConnection,character-method" ] }, { "page": "dbWriteTable-TrinoConnection-ANY-method", "title": "Write a table", "topics": [ "dbWriteTable,TrinoConnection,ANY-method", "dbWriteTable,TrinoConnection,Id-method" ] }, { "page": "Trino", "title": "Instantiate the Trino driver", "topics": [ "Trino" ] }, { "page": "trino_auth", "title": "Authentication methods for Trino", "topics": [ "trino_auth", "trino_auth_basic", "trino_auth_jwt", "trino_auth_oauth2" ] }, { "page": "trino_ssl", "title": "TLS options for a Trino connection", "topics": [ "trino_ssl" ] }, { "page": "trino_type_to_r", "title": "Map a Trino type to the name of an R type", "topics": [ "trino_type_to_r" ] } ], "_readme": "https://github.com/angelcasasbl/rtrino/raw/HEAD/README.md", "_rundeps": [ "askpass", "bit", "bit64", "cli", "curl", "DBI", "glue", "httr2", "jsonlite", "lifecycle", "magrittr", "openssl", "pillar", "pkgconfig", "R6", "rlang", "sys", "tibble", "utf8", "vctrs", "withr" ], "_vignettes": [ { "source": "getting-started.Rmd", "filename": "getting-started.html", "title": "Getting started with RTrino", "engine": "knitr::rmarkdown", "headings": [ "Connecting", "Authentication", "Basic — LDAP or a password file", "JWT — service accounts and pipelines", "OAuth2 client credentials — corporate SSO", "Internal certificate authorities", "Querying", "Statements", "Writing data", "Transactions", "Timeouts", "Big integers and precision", "dplyr", "Introspection", "Session properties and other headers", "Disconnecting" ], "created": "2026-09-17 17:42:18", "modified": "2026-10-02 19:32:22", "commits": 5 } ], "_score": 4, "_indexed": true, "_nocasepkg": "rtrino", "_universes": [ "angelcasasbl", "jumpingsunsub" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-10-16T09:09:09.000Z", "distro": "resolute", "commit": "3421e6f508a83f77f6e28d12a70048cd838d8b02", "fileid": "https://r2.ropensci.org/9997e7bf2b2550019cb50d079d4ef3f48acba891e71300c2a1a3558402adb818", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/angelcasasbl/actions/runs/38877836073" }, { "r": "4.6.1", "os": "linux", "version": "0.1.0", "date": "2026-10-16T09:08:39.000Z", "distro": "resolute", "commit": "3421e6f508a83f77f6e28d12a70048cd838d8b02", "fileid": "https://r2.ropensci.org/19e3c80ec065af1ec2473dff81c77a5b0c50c4c5eedabc595730383798985878", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/angelcasasbl/actions/runs/38877836073" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-10-16T09:36:29.000Z", "commit": "3421e6f508a83f77f6e28d12a70048cd838d8b02", "fileid": "https://r2.ropensci.org/fa77f8dd193cfb19a85be4e1dee995735d025a077e657f0bff534e9f1e27516c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/angelcasasbl/actions/runs/38877836073" }, { "r": "4.6.1", "os": "mac", "version": "0.1.0", "date": "2026-10-16T09:35:10.000Z", "commit": "3421e6f508a83f77f6e28d12a70048cd838d8b02", "fileid": "https://r2.ropensci.org/498a269493d4b9205200a440404d46d4c94dbaf75cfd863056a387284da524a1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/angelcasasbl/actions/runs/38877836073" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-10-16T09:09:12.000Z", "commit": "3421e6f508a83f77f6e28d12a70048cd838d8b02", "fileid": "https://r2.ropensci.org/049d241054aa714832a5f83af48e88b61a5975f97eaadadbf428a0eb7fbb4ba8", "status": "success", "buildurl": "https://github.com/r-universe/angelcasasbl/actions/runs/38877836073" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-10-16T09:07:13.000Z", "commit": "3421e6f508a83f77f6e28d12a70048cd838d8b02", "fileid": "https://r2.ropensci.org/03dc54b97d3bbadef25ae111ce0c4b86c270f53734d037e0f3ef8a7f5b9358db", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/angelcasasbl/actions/runs/38877836073" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-10-16T09:07:18.000Z", "commit": "3421e6f508a83f77f6e28d12a70048cd838d8b02", "fileid": "https://r2.ropensci.org/ad894ad2451b41ba594367c31f5d3be30c8f59579e6aed92047469794c5a2185", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/angelcasasbl/actions/runs/38877836073" }, { "r": "4.6.1", "os": "win", "version": "0.1.0", "date": "2026-10-16T09:07:22.000Z", "commit": "3421e6f508a83f77f6e28d12a70048cd838d8b02", "fileid": "https://r2.ropensci.org/64408db4129e4b185a349acbe93997b10f0bae6df8cef07cbd07723ead763ccf", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/angelcasasbl/actions/runs/38877836073" } ] }