{
  "_id": "6ac8c970de46216d5edd7367",
  "Package": "rsgl",
  "Title": "An Implementation of the 'SGL' Graphics Language",
  "Version": "0.1.0.9000",
  "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<doi:10.48550/arXiv.2505.14690>.",
  "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",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.3",
  "Config/testthat/edition": "3",
  "VignetteBuilder": "knitr, rmarkdown",
  "LazyData": "true",
  "Config/pak/sysreqs": "xz-utils",
  "Repository": "https://sgl-projects.r-universe.dev",
  "Date/Publication": "2026-08-10 15:52:39 UTC",
  "RemoteUrl": "https://github.com/sgl-projects/rsgl",
  "RemoteRef": "HEAD",
  "RemoteSha": "46829965e47f0964b725c7becb9647512a3c4e93",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-10-09 10:22:56 UTC",
    "User": "root"
  },
  "Author": "Jon Chapman [aut, cre, cph],\nFree Software Foundation, Inc. [cph] (Bison parser skeleton)",
  "Maintainer": "Jon Chapman <jochapjo@icloud.com>",
  "_user": "sgl-projects",
  "_type": "src",
  "_file": "rsgl_0.1.0.9000.tar.gz",
  "_fileid": "https://r2.ropensci.org/3afe804e922ddaf16cff124033912670e93afb2715dd4911109db77fb4d169e1",
  "_filesize": 2447590,
  "_sha256": "3afe804e922ddaf16cff124033912670e93afb2715dd4911109db77fb4d169e1",
  "_expires": "2027-01-17T11:01:02.000Z",
  "_created": "2026-10-09T10:22:56.000Z",
  "_published": "2026-10-09T11:01:04.038Z",
  "_buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 113776476490,
      "time": 138,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11610656131"
    },
    {
      "job": 113776476506,
      "time": 194,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11610826074"
    },
    {
      "job": 113776476653,
      "time": 122,
      "config": "linux-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11610731034"
    },
    {
      "job": 113776476492,
      "time": 157,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11610510966"
    },
    {
      "job": 113776476441,
      "time": 204,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11612275685"
    },
    {
      "job": 113776476660,
      "time": 545,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11611751829"
    },
    {
      "job": 113776476545,
      "time": 123,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11612580804"
    },
    {
      "job": 113776476606,
      "time": 431,
      "config": "macos-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11611382833"
    },
    {
      "job": 113774875861,
      "time": 279,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11611235199"
    },
    {
      "job": 113776476494,
      "time": 96,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11610740836"
    },
    {
      "job": 113776477307,
      "time": 430,
      "config": "windows-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11610531634"
    },
    {
      "job": 113776476447,
      "time": 137,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11610581545"
    },
    {
      "job": 113776476756,
      "time": 108,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11610770906"
    },
    {
      "job": 113776476623,
      "time": 390,
      "config": "windows-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11610211748"
    },
    {
      "job": 113776476675,
      "time": 160,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11610831095"
    }
  ],
  "_upstream": "https://github.com/sgl-projects/rsgl",
  "_commit": {
    "id": "46829965e47f0964b725c7becb9647512a3c4e93",
    "author": "chapman-jon <jochapjo@icloud.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #90 from sgl-projects/limit-one-scale-per-aes\n\nRaise error for multiple scales on a single aesthetic",
    "time": 1786377159
  },
  "_maintainer": {
    "name": "Jon Chapman",
    "email": "jochapjo@icloud.com",
    "login": "chapman-jon",
    "description": "",
    "uuid": 212455899
  },
  "_distro": "resolute",
  "_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": "sgl-projects",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-19",
      "n": 17
    },
    {
      "week": "2026-20",
      "n": 10
    },
    {
      "week": "2026-21",
      "n": 21
    },
    {
      "week": "2026-22",
      "n": 9
    },
    {
      "week": "2026-24",
      "n": 13
    },
    {
      "week": "2026-25",
      "n": 4
    },
    {
      "week": "2026-27",
      "n": 2
    },
    {
      "week": "2026-28",
      "n": 1
    },
    {
      "week": "2026-29",
      "n": 2
    },
    {
      "week": "2026-30",
      "n": 4
    },
    {
      "week": "2026-31",
      "n": 2
    },
    {
      "week": "2026-32",
      "n": 3
    },
    {
      "week": "2026-33",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "v0.1.0",
      "date": "2026-06-02"
    }
  ],
  "_topics": [
    "sgl",
    "visualization",
    "cpp"
  ],
  "_stars": 2,
  "_contributors": [
    {
      "user": "chapman-jon",
      "count": 193,
      "uuid": 212455899
    }
  ],
  "_userbio": {
    "uuid": 262215135,
    "type": "organization",
    "name": "sgl-projects",
    "followers": 0
  },
  "_downloads": {
    "count": 244,
    "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,
  "_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/rsgl.html",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/sgl-projects/rsgl",
  "_realowner": "sgl-projects",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2026-06-08"
    }
  ],
  "_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"
      ]
    },
    {
      "page": "violins",
      "title": "Violins",
      "topics": [
        "violins"
      ]
    }
  ],
  "_readme": "https://github.com/sgl-projects/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": "16-20260322-1ubuntu1",
      "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-05-04 20:28:03",
      "modified": "2026-06-12 19:23:25",
      "commits": 8
    },
    {
      "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-05-04 20:28:03",
      "modified": "2026-06-08 18:55:57",
      "commits": 7
    }
  ],
  "_score": 5.414973347970818,
  "_indexed": true,
  "_nocasepkg": "rsgl",
  "_universes": [
    "sgl-projects",
    "chapman-jon"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:24:57.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/00a5498ee6e8e9bf19529ea1fc165a91316aa9c8be5d479c89c1c6c258c3934d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:25:40.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/69f724021db1511a017f500796df11543de5f3108978ccf2939aa4c099a3a1b4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:24:49.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/de8c29b5236dfb27a0b91f5d25dc915d0402e96134254f28cb46e51595ec05bc",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:25:08.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/619f1ac65af73d4faba0a37e152da2ee5f80485035ac8f4dee8f19060a82ebfd",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:56:02.000Z",
      "arch": "aarch64",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/d1d13bfde1c38cf3d4fcb3682c9a29ac9fc0da0a55294e33a4df9775db1a7fc6",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:56:45.000Z",
      "arch": "x86_64",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/485fd49d437bf511c7f83e9cce6066bea6a60905c493fde02274e0ab6e3acb63",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:58:39.000Z",
      "arch": "aarch64",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/2627eb236244fca1e5cdb4a7579dddc71a26eea6c752b356e07baa0fa7f74021",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:53:52.000Z",
      "arch": "x86_64",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/04d01442239957aeb122fac978339ed19ef42e76f42843cd1818a4e72b4ee5db",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:24:53.000Z",
      "arch": "emscripten",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/cbcb03752bd2a61030e67918b3b828e0c08f34f38fb52593503f6cc6128a2880",
      "status": "success",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:28:36.000Z",
      "arch": "aarch64",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/afbc68d4219a5b79ae9dc445b3e158dd80f6a5a1ea896a4003def57fb364a2bc",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:24:11.000Z",
      "arch": "x86_64",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/735aeddac9d115ca9789389973c261821bbc38d7d11f5ed219ade05924f036c8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:24:05.000Z",
      "arch": "x86_64",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/9f78aeeaefb14404f14cf4f2061c1e07c7eeb7b9f2f6070e40b580466870cc2a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:28:00.000Z",
      "arch": "aarch64",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/2921747248f907b544a4753c74867ae5b638e9e34761ca71799b8c28c0165c9d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.0.9000",
      "date": "2026-10-09T10:24:12.000Z",
      "arch": "x86_64",
      "commit": "46829965e47f0964b725c7becb9647512a3c4e93",
      "fileid": "https://r2.ropensci.org/b7628d5a9a5da2522107594cab0b1501c4d1f07b10b11cbbe5e765e8ea15e1c9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/37916765760"
    }
  ]
}