{ "_id": "6acac644fe5cc25786e8c0e1", "Package": "trama.sql", "Title": "SQL Queries for trama Data Flows", "Version": "0.1.0", "Authors@R": "person(\"Pedro\", \"Mambelli Fernandes\", , \"pedromambelli@gmail.com\", role = c(\"aut\", \"cre\"))", "Description": "Query local files and databases with SQL and return tables\nto trama flows.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Config/testthat/edition": "3", "Config/trama/requires": "trama.data", "Config/roxygen2/version": "8.0.0", "Config/pak/sysreqs": "cmake make libuv1-dev libssl-dev xz-utils\nzlib1g-dev", "Repository": "https://uaipedro.r-universe.dev", "Date/Publication": "2026-10-09 16:23:25 UTC", "RemoteUrl": "https://github.com/uaipedro/trama", "RemoteRef": "HEAD", "RemoteSha": "1bdeb4f693df836f77e762f2642cc18a3956f8b1", "RemoteSubdir": "collections/trama.sql", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-10 22:53:12 UTC", "User": "root" }, "Author": "Pedro Mambelli Fernandes [aut, cre]", "Maintainer": "Pedro Mambelli Fernandes ", "_user": "uaipedro", "_type": "src", "_file": "trama.sql_0.1.0.tar.gz", "_fileid": "https://r2.ropensci.org/f8184e996738766824480dc823807d89a0cb07c53b4dff3576b898b8b196d6d7", "_filesize": 384511, "_sha256": "f8184e996738766824480dc823807d89a0cb07c53b4dff3576b898b8b196d6d7", "_expires": "2027-01-18T23:12:02.000Z", "_created": "2026-10-10T22:53:12.000Z", "_published": "2026-10-10T23:12:04.453Z", "_buildurl": "https://github.com/r-universe/uaipedro/actions/runs/38092802872", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 114333341188, "time": 121, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "11684668849" }, { "job": 114333341184, "time": 108, "config": "linux-release-x86_64", "r": "4.6.1", "check": "WARNING", "artifact": "11684588755" }, { "job": 114333341042, "time": 85, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "WARNING", "artifact": "11685955105" }, { "job": 114333341133, "time": 114, "config": "macos-release-arm64", "r": "4.6.1", "check": "WARNING", "artifact": "11685800495" }, { "job": 114332582452, "time": 261, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11684089901" }, { "job": 114333341768, "time": 96, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11685295060" }, { "job": 114333341105, "time": 69, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "11685101031" }, { "job": 114333341131, "time": 77, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "WARNING", "artifact": "11684409049" }, { "job": 114333341076, "time": 77, "config": "windows-release-x86_64", "r": "4.6.1", "check": "WARNING", "artifact": "11684453876" } ], "_upstream": "https://github.com/uaipedro/trama", "_commit": { "id": "1bdeb4f693df836f77e762f2642cc18a3956f8b1", "author": "uaipedro ", "committer": "uaipedro ", "message": "feat(models): normalidade dos resíduos quantílicos do GLM com p mediano calibrado\n\nmodels/shapiro_residuals (versão 2) testa os resíduos quantílicos randomizados\nno GLM: p mediano do Shapiro-Wilk em 'sorteios' realizações como estatística,\np-valor por Monte Carlo com 'reamostras' respostas simuladas do ajuste. Tipo I\nmedido: 4,5 a 5,5% (o p mediano cru dava 0 a 2%). Resíduo quantílico finito na\ncauda de cima. trama.models 0.6.9.\n\nCo-Authored-By: Claude Opus 5.5 \n", "time": 1791563005 }, "_maintainer": { "name": "Pedro Mambelli Fernandes", "email": "pedromambelli@gmail.com", "login": "uaipedro", "description": "Estudante de Estatística (UFLA) com background em desenvolvimento e gestão.", "uuid": 44395968 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1", "role": "Depends" }, { "package": "trama", "version": ">= 0.5.3", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "duckdb", "role": "Imports" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "pkgload", "role": "Suggests" }, { "package": "arrow", "role": "Suggests" } ], "_owner": "uaipedro", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-38", "n": 144 }, { "week": "2026-39", "n": 225 }, { "week": "2026-40", "n": 46 }, { "week": "2026-41", "n": 71 } ], "_tags": [ { "name": "v0.1.0", "date": "2026-09-15" }, { "name": "launcher-v0.1.0", "date": "2026-09-18" }, { "name": "launcher-v0.1.1", "date": "2026-09-18" }, { "name": "launcher-v0.1.2", "date": "2026-09-18" }, { "name": "launcher-v0.1.3", "date": "2026-09-18" }, { "name": "launcher-v0.1.4", "date": "2026-09-18" }, { "name": "launcher-v0.1.6", "date": "2026-09-19" }, { "name": "trama-2026.10", "date": "2026-09-24" }, { "name": "v0.1.1", "date": "2026-09-24" }, { "name": "v0.1.2", "date": "2026-09-26" }, { "name": "v0.1.3", "date": "2026-09-27" }, { "name": "v0.1.10", "date": "2026-10-08" }, { "name": "v0.1.8", "date": "2026-10-08" }, { "name": "v0.1.9", "date": "2026-10-08" }, { "name": "v0.1.11", "date": "2026-10-09" }, { "name": "v0.1.12", "date": "2026-10-09" }, { "name": "v0.1.13", "date": "2026-10-09" } ], "_stars": 1, "_contributors": [ { "user": "uaipedro", "count": 837, "uuid": 44395968 }, { "user": "bonijoao", "count": 18, "uuid": 87396526 } ], "_userbio": { "uuid": 44395968, "type": "user", "name": "Pedro Mambelli Fernandes", "followers": 5, "description": "Estudante de Estatística (UFLA) com background em desenvolvimento e gestão." }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/trama.sql" }, "_devurl": "https://github.com/uaipedro/trama", "_searchresults": 1, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/readme.html", "extra/readme.md", "extra/trama.sql.html", "LICENSE" ], "_cranurl": false, "_exports": [ "tr_sql_query", "tr_sql_source", "trama_collection" ], "_help": [ { "page": "tr_sql_query", "title": "Executa uma consulta somente de leitura.", "topics": [ "tr_sql_query" ] }, { "page": "tr_sql_source", "title": "Abre uma fonte local de dados consultável por SQL.", "topics": [ "tr_sql_source" ] }, { "page": "trama_collection", "title": "Coleção SQL.", "topics": [ "trama_collection" ] } ], "_readme": "https://github.com/uaipedro/trama/raw/HEAD/collections/trama.sql/README.md", "_rundeps": [ "base64enc", "bslib", "cachem", "cli", "commonmark", "cpp11", "curl", "DBI", "digest", "dplyr", "duckdb", "fastmap", "fontawesome", "fs", "generics", "glue", "htmltools", "httpuv", "jquerylib", "jsonlite", "later", "lifecycle", "lubridate", "magrittr", "memoise", "mime", "otel", "pillar", "pkgconfig", "promises", "R6", "rappdirs", "Rcpp", "rlang", "sass", "shiny", "sourcetools", "tibble", "tidyselect", "timechange", "trama", "utf8", "vctrs", "withr", "xtable" ], "_score": 2.3010299956639813, "_indexed": true, "_nocasepkg": "trama.sql", "_universes": [ "uaipedro" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-10-10T22:55:17.000Z", "distro": "resolute", "commit": "1bdeb4f693df836f77e762f2642cc18a3956f8b1", "fileid": "https://r2.ropensci.org/b4e5ff763fcd10238ba1d60c082787dcea43f220834ecc2f6d77e2f5047418a9", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/uaipedro/actions/runs/38092802872" }, { "r": "4.6.1", "os": "linux", "version": "0.1.0", "date": "2026-10-10T22:55:06.000Z", "distro": "resolute", "commit": "1bdeb4f693df836f77e762f2642cc18a3956f8b1", "fileid": "https://r2.ropensci.org/9043ce92a1d5d7af536decc4cbc379da4d720d937a7865e3a0941b1e83cf220d", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/uaipedro/actions/runs/38092802872" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-10-10T23:11:01.000Z", "commit": "1bdeb4f693df836f77e762f2642cc18a3956f8b1", "fileid": "https://r2.ropensci.org/8ec10327cd042b09f4eb052b1fec870826ef108b08d55fbb34faa155cfed7ce8", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/uaipedro/actions/runs/38092802872" }, { "r": "4.6.1", "os": "mac", "version": "0.1.0", "date": "2026-10-10T23:11:27.000Z", "commit": "1bdeb4f693df836f77e762f2642cc18a3956f8b1", "fileid": "https://r2.ropensci.org/07a35e127fdc25e745d8e95a8ecea29974b2d9ca7f51430c68e3ba8110013771", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/uaipedro/actions/runs/38092802872" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-10-10T22:55:05.000Z", "commit": "1bdeb4f693df836f77e762f2642cc18a3956f8b1", "fileid": "https://r2.ropensci.org/305199d7f7039940655ba539d481bf21b332716885a723f8560dc8a0f9f83689", "status": "success", "buildurl": "https://github.com/r-universe/uaipedro/actions/runs/38092802872" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-10-10T22:54:20.000Z", "commit": "1bdeb4f693df836f77e762f2642cc18a3956f8b1", "fileid": "https://r2.ropensci.org/a2d1427881d2feeb1e0c1cd067871296752aba62d1a7b46b37156e726d8deefc", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/uaipedro/actions/runs/38092802872" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-10-10T22:54:30.000Z", "commit": "1bdeb4f693df836f77e762f2642cc18a3956f8b1", "fileid": "https://r2.ropensci.org/77eb5bb62344af19f4bd60f71804d722b2a0c5ce7ee2d507ff060e03343aa990", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/uaipedro/actions/runs/38092802872" }, { "r": "4.6.1", "os": "win", "version": "0.1.0", "date": "2026-10-10T22:54:30.000Z", "commit": "1bdeb4f693df836f77e762f2642cc18a3956f8b1", "fileid": "https://r2.ropensci.org/c7fa7caf70b6011d464ec1e76e86552a3675804ca5a4ec4987d9879b018645a6", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/uaipedro/actions/runs/38092802872" } ] }