{ "_id": "6ad10baba6a61792ed76aeea", "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", "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", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-15 17:18:39 UTC", "User": "root" }, "Author": "Luis A Casas Ballestas [aut, cre, cph]", "Maintainer": "Luis A Casas Ballestas ", "Repository": "https://cran.r-universe.dev", "Date/Publication": "2026-10-15 10:00:02 UTC", "RemoteUrl": "https://github.com/cran/RTrino", "RemoteRef": "HEAD", "RemoteSha": "3e3deb835484d6722ec37017c6fe93e249e08021", "_user": "cran", "_type": "src", "_file": "RTrino_0.1.0.tar.gz", "_fileid": "https://r2.ropensci.org/f30293006a2f78727f94fb73692f4ee434e1d436acb71cbcffff144aa20f9f07", "_filesize": 268009, "_sha256": "f30293006a2f78727f94fb73692f4ee434e1d436acb71cbcffff144aa20f9f07", "_expires": "2027-01-23T17:21:45.000Z", "_created": "2026-10-15T17:18:39.000Z", "_published": "2026-10-15T17:21:47.676Z", "_buildurl": "https://github.com/r-universe/cran/actions/runs/38775816590", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 116564736418, "time": 137, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11994216328" }, { "job": 116564736493, "time": 127, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11994266231" }, { "job": 116563222848, "time": 184, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11993457165" }, { "job": 116564736419, "time": 103, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11994241206" }, { "job": 116564736562, "time": 84, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11993507354" }, { "job": 116564736529, "time": 92, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11994755231" } ], "_upstream": "https://github.com/cran/RTrino", "_commit": { "id": "3e3deb835484d6722ec37017c6fe93e249e08021", "author": "Luis A Casas Ballestas ", "committer": "cran-robot ", "message": "version 0.1.0\n", "time": 1792058402 }, "_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": "cran", "_selfowned": false, "_usedby": 0, "_updates": [ { "week": "2026-42", "n": 1 } ], "_tags": [ { "name": "0.1.0", "date": "2026-10-15" } ], "_stars": 0, "_contributors": [ { "user": "jumpingsunsub", "count": 1, "uuid": 125944109 } ], "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "followers": 631, "description": "Unofficial read-only mirror of all CRAN R packages" }, "_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" ], "_cranurl": false, "_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/cran/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-10-15 10:00:02", "modified": "2026-10-15 10:00:02", "commits": 1 } ], "_score": 2.6989700043360187, "_indexed": false, "_nocasepkg": "rtrino", "_universes": [ "cran", "jumpingsunsub", "angelcasasbl" ], "_indexurl": "https://angelcasasbl.r-universe.dev/RTrino", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-10-15T17:20:43.000Z", "distro": "resolute", "commit": "3e3deb835484d6722ec37017c6fe93e249e08021", "fileid": "https://r2.ropensci.org/bd9ae267905d3effb002c4bdcf1613f54a6887abdc46b1358108380dc0e945d6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/38775816590" }, { "r": "4.6.1", "os": "linux", "version": "0.1.0", "date": "2026-10-15T17:20:39.000Z", "distro": "resolute", "commit": "3e3deb835484d6722ec37017c6fe93e249e08021", "fileid": "https://r2.ropensci.org/add014699cc7bfd74d6d775a06c6a99e4791efdf8ac7577c7ef29664f03a870c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/38775816590" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-10-15T17:20:42.000Z", "commit": "3e3deb835484d6722ec37017c6fe93e249e08021", "fileid": "https://r2.ropensci.org/cf4344af7e7b7528279e60b5fca99bf57b6912520bde978336a54ef0155c5ad0", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/38775816590" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-10-15T17:19:48.000Z", "commit": "3e3deb835484d6722ec37017c6fe93e249e08021", "fileid": "https://r2.ropensci.org/464e661d0356c0f51a35b676e46766239c3aad37d530fe89f329cb98dc5b5715", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/38775816590" }, { "r": "4.6.1", "os": "win", "version": "0.1.0", "date": "2026-10-15T17:19:57.000Z", "commit": "3e3deb835484d6722ec37017c6fe93e249e08021", "fileid": "https://r2.ropensci.org/c49a3af6e349ed0d99cc0812ae27ab6a0619112062b13db585aff653d1035109", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/38775816590" } ] }