{ "_id": "6a2728af24555f66ed52c1ef", "Package": "rsgl", "Title": "An Implementation of the 'SGL' Graphics Language", "Version": "0.1.0", "Authors@R": "c(\nperson(\"Jon\", \"Chapman\", , \"jochapjo@icloud.com\",\nrole = c(\"aut\", \"cre\", \"cph\")),\nperson(\"Free Software Foundation, Inc.\", role = \"cph\",\ncomment = \"Bison parser skeleton\"))", "Description": "Generates plots from a database connection and a 'SGL'\nstatement. 'SGL' is a graphics language designed to look and\nfeel like 'SQL'. It is especially useful for those familiar\nwith 'SQL' who want to specify plots in a similar manner. The\n'SGL' language is described in Chapman (2025)\n.", "License": "MIT + file LICENSE", "URL": "https://github.com/sgl-projects/rsgl,\nhttps://sgl-projects.github.io/rsgl/,\nhttps://arxiv.org/abs/2505.14690", "BugReports": "https://github.com/sgl-projects/rsgl/issues", "Encoding": "UTF-8", "RoxygenNote": "7.3.3", "Config/testthat/edition": "3", "VignetteBuilder": "knitr, rmarkdown", "LazyData": "true", "NeedsCompilation": "yes", "Packaged": { "Date": "2026-06-08 20:36:11 UTC", "User": "root" }, "Author": "Jon Chapman [aut, cre, cph], Free Software Foundation, Inc.\n[cph] (Bison parser skeleton)", "Maintainer": "Jon Chapman ", "Repository": "https://cran.r-universe.dev", "Date/Publication": "2026-06-08 18:20:02 UTC", "RemoteUrl": "https://github.com/cran/rsgl", "RemoteRef": "HEAD", "RemoteSha": "01f7dddf554cb5af81b3653d5f7cd2cc0b0c1c9c", "MD5sum": "00ba5e92b31c32c43b8d36b9ee43706d", "_user": "cran", "_type": "src", "_file": "rsgl_0.1.0.tar.gz", "_fileid": "6c2376ba89a844ba78a13b1754a4ca79fd84db7422551baefcf85a113c8e5138", "_filesize": 2367269, "_sha256": "6c2376ba89a844ba78a13b1754a4ca79fd84db7422551baefcf85a113c8e5138", "_created": "2026-06-08T20:36:11.000Z", "_published": "2026-06-08T20:40:15.030Z", "_distro": "noble", "_jobs": [ { "job": 80191133173, "time": 204, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "7491851049" }, { "job": 80191133103, "time": 160, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7491834755" }, { "job": 80191133141, "time": 187, "config": "linux-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7491845430" }, { "job": 80191133125, "time": 153, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7491832445" }, { "job": 80190504480, "time": 202, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7491777151" }, { "job": 80191133052, "time": 118, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7491820121" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/27164727179", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/rsgl", "_commit": { "id": "01f7dddf554cb5af81b3653d5f7cd2cc0b0c1c9c", "author": "Jon Chapman ", "committer": "cran-robot ", "message": "version 0.1.0\n", "time": 1780942802 }, "_maintainer": { "name": "Jon Chapman", "email": "jochapjo@icloud.com", "login": "chapman-jon", "description": "", "uuid": 212455899 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1", "role": "Depends" }, { "package": "Rcpp", "role": "LinkingTo" }, { "package": "DBI", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "duckdb", "role": "Imports" }, { "package": "ggplot2", "role": "Imports" }, { "package": "purrr", "role": "Imports" }, { "package": "Rcpp", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "vdiffr", "role": "Suggests" }, { "package": "lubridate", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "patrick", "role": "Suggests" }, { "package": "tibble", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 0, "_updates": [ { "week": "2026-24", "n": 1 } ], "_tags": [ { "name": "0.1.0", "date": "2026-06-08" } ], "_stars": 0, "_contributors": [ { "user": "chapman-jon", "count": 1, "uuid": 212455899 } ], "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/rsgl" }, "_devurl": "https://github.com/sgl-projects/rsgl", "_pkgdown": "https://sgl-projects.github.io/rsgl/", "_searchresults": 5, "_topics": [ "cpp" ], "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/rsgl.html", "manual.pdf" ], "_cranurl": false, "_exports": [ "dbGetPlot", "type_classifications" ], "_datasets": [ { "name": "cars", "title": "Cars dataset", "object": "cars", "class": [ "data.frame" ], "fields": [ "car_id", "horsepower", "miles_per_gallon", "origin", "year" ], "rows": 406, "table": true, "tojson": true }, { "name": "trees", "title": "Trees dataset", "object": "trees", "class": [ "data.frame" ], "fields": [ "tree_id", "age", "circumference" ], "rows": 35, "table": true, "tojson": true } ], "_help": [ { "page": "avg", "title": "Average", "topics": [ "avg" ] }, { "page": "bars", "title": "Bars", "topics": [ "bars" ] }, { "page": "bin", "title": "Bin", "topics": [ "bin" ] }, { "page": "boxes", "title": "Boxes", "topics": [ "boxes" ] }, { "page": "cars", "title": "Cars dataset", "topics": [ "cars" ] }, { "page": "count", "title": "Count", "topics": [ "count" ] }, { "page": "dbGetPlot", "title": "Generate a plot from a SGL statement", "topics": [ "dbGetPlot" ] }, { "page": "linear", "title": "Linear", "topics": [ "linear" ] }, { "page": "lines", "title": "Lines", "topics": [ "lines" ] }, { "page": "ln", "title": "Natural Log", "topics": [ "ln" ] }, { "page": "log", "title": "Log", "topics": [ "log" ] }, { "page": "points", "title": "Points", "topics": [ "points" ] }, { "page": "trees", "title": "Trees dataset", "topics": [ "trees" ] }, { "page": "type_classifications", "title": "Get SGL type classifications for columns in a table", "topics": [ "type_classifications" ] } ], "_readme": "https://github.com/cran/rsgl/raw/HEAD/README.md", "_rundeps": [ "cli", "cpp11", "DBI", "dplyr", "duckdb", "farver", "generics", "ggplot2", "glue", "gtable", "isoband", "labeling", "lifecycle", "magrittr", "pillar", "pkgconfig", "purrr", "R6", "RColorBrewer", "Rcpp", "rlang", "S7", "scales", "tibble", "tidyselect", "utf8", "vctrs", "viridisLite", "withr" ], "_sysdeps": [ { "shlib": "libstdc++", "package": "libstdc++6", "source": "gcc", "version": "14.2.0-4ubuntu2~24.04.1", "name": "c++", "homepage": "http://gcc.gnu.org/", "description": "GNU Standard C++ Library v3" } ], "_vignettes": [ { "source": "example-gallery.Rmd", "filename": "example-gallery.html", "title": "Example gallery", "engine": "knitr::rmarkdown", "headings": [ "Database Setup", "Cars", "Setup", "Example Plots", "Trees" ], "created": "2026-06-08 18:20:02", "modified": "2026-06-08 18:20:02", "commits": 1 }, { "source": "rsgl.Rmd", "filename": "rsgl.html", "title": "Get started with rsgl", "engine": "knitr::rmarkdown", "headings": [ "Setup", "dbGetPlot", "The SGL Language", "The From Clause", "The Using Clause", "The Visualize Clause", "Column-Level Transformations and Aggregations", "The Collect By Clause", "Geom Qualifiers", "The Layer Operator", "The Scale By Clause", "Coordinate Systems", "The Facet By Clause", "The Title Clause", "Next steps" ], "created": "2026-06-08 18:20:02", "modified": "2026-06-08 18:20:02", "commits": 1 } ], "_score": 3, "_indexed": false, "_nocasepkg": "rsgl", "_universes": [ "cran", "chapman-jon", "sgl-projects" ], "_indexurl": "https://sgl-projects.r-universe.dev/rsgl", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-06-08T20:39:16.000Z", "distro": "noble", "arch": "aarch64", "commit": "01f7dddf554cb5af81b3653d5f7cd2cc0b0c1c9c", "fileid": "9852f7a468e359efd61aa8cb1c4be0323dac80ede63809563d86663d6229cbb3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27164727179" }, { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-06-08T20:38:26.000Z", "distro": "noble", "arch": "x86_64", "commit": "01f7dddf554cb5af81b3653d5f7cd2cc0b0c1c9c", "fileid": "f96f6bc5051bcc76820bb8113acc3d1f394f679d54b8d2fb1ada968a701b68b3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27164727179" }, { "r": "4.6.0", "os": "linux", "version": "0.1.0", "date": "2026-06-08T20:39:02.000Z", "distro": "noble", "arch": "aarch64", "commit": "01f7dddf554cb5af81b3653d5f7cd2cc0b0c1c9c", "fileid": "527daafbf4a44b0882c18493e3169c1f96dfc196a4b6dceadf98a3ba009ce451", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27164727179" }, { "r": "4.6.0", "os": "linux", "version": "0.1.0", "date": "2026-06-08T20:38:22.000Z", "distro": "noble", "arch": "x86_64", "commit": "01f7dddf554cb5af81b3653d5f7cd2cc0b0c1c9c", "fileid": "2714173e1ed27793c68a857c7658a319a6de87b8d6b39ed4c782221142df9cb5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27164727179" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-06-08T20:38:25.000Z", "arch": "emscripten", "commit": "01f7dddf554cb5af81b3653d5f7cd2cc0b0c1c9c", "fileid": "0cd28fc2d3aedf020d103d5525b045a5bf99f0f61aa25bae992df9e3b7527df9", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/27164727179" } ] }