{
  "_id": "6a2afef67b7a29ca6005a4fa",
  "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-06-11 15:08:52 UTC",
  "RemoteUrl": "https://github.com/sgl-projects/rsgl",
  "RemoteRef": "HEAD",
  "RemoteSha": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-06-11 18:23:39 UTC",
    "User": "root"
  },
  "Author": "Jon Chapman [aut, cre, cph],\nFree Software Foundation, Inc. [cph] (Bison parser skeleton)",
  "Maintainer": "Jon Chapman <jochapjo@icloud.com>",
  "MD5sum": "e45c12df940550f6a8c04d5228a0de26",
  "_user": "sgl-projects",
  "_type": "src",
  "_file": "rsgl_0.1.0.9000.tar.gz",
  "_fileid": "720200c79a2b15c84ee51ccf21c3f55613c70293bfa0a3fb07a18e0be9585e42",
  "_filesize": 2371515,
  "_sha256": "720200c79a2b15c84ee51ccf21c3f55613c70293bfa0a3fb07a18e0be9585e42",
  "_created": "2026-06-11T18:23:39.000Z",
  "_published": "2026-06-11T18:31:18.499Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 80874105969,
      "time": 155,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7573315628"
    },
    {
      "job": 80874106080,
      "time": 332,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7573382762"
    },
    {
      "job": 80874106062,
      "time": 164,
      "config": "linux-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7573318536"
    },
    {
      "job": 80874106033,
      "time": 166,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7573320118"
    },
    {
      "job": 80874106000,
      "time": 123,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7573302320"
    },
    {
      "job": 80874106152,
      "time": 409,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7573412491"
    },
    {
      "job": 80874105952,
      "time": 130,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7573305074"
    },
    {
      "job": 80874106010,
      "time": 295,
      "config": "macos-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7573370060"
    },
    {
      "job": 80873386941,
      "time": 216,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7573253594"
    },
    {
      "job": 80874105961,
      "time": 124,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7573303181"
    },
    {
      "job": 80874106115,
      "time": 176,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7573323513"
    },
    {
      "job": 80874105939,
      "time": 154,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7573314969"
    },
    {
      "job": 80874106140,
      "time": 202,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7573333939"
    }
  ],
  "_buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/27368237736",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/sgl-projects/rsgl",
  "_commit": {
    "id": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
    "author": "chapman-jon <jochapjo@icloud.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #69 from sgl-projects/reject-duplicate-aes-titles\n\nReject duplicate TITLE entries for the same aesthetic",
    "time": 1781190532
  },
  "_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": "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": 11
    }
  ],
  "_tags": [
    {
      "name": "v0.1.0",
      "date": "2026-06-02"
    }
  ],
  "_topics": [
    "sgl",
    "visualization",
    "cpp"
  ],
  "_stars": 1,
  "_contributors": [
    {
      "user": "chapman-jon",
      "count": 151,
      "uuid": 212455899
    }
  ],
  "_userbio": {
    "uuid": 262215135,
    "type": "organization",
    "name": "sgl-projects"
  },
  "_downloads": {
    "count": 66,
    "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.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"
  ],
  "_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"
      ]
    }
  ],
  "_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": "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-05-04 20:28:03",
      "modified": "2026-06-08 18:55:57",
      "commits": 7
    },
    {
      "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": 4.698970004336019,
  "_indexed": true,
  "_nocasepkg": "rsgl",
  "_universes": [
    "sgl-projects",
    "chapman-jon"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.0.9000",
      "date": "2026-06-11T18:26:01.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
      "fileid": "8994a929a21233fcea201767b034e8f42ad3528db9ad94c3868d22e8315609e6",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/27368237736"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.0.9000",
      "date": "2026-06-11T18:28:47.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
      "fileid": "4a57b4ffabb1e1dc5809de747d80ef7d2247ccf4be6c0780d387de3f6075a790",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/27368237736"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.1.0.9000",
      "date": "2026-06-11T18:26:05.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
      "fileid": "1bf68700471332b1446e8312f5556f12e5e0927ed7e880faf54d7ce357c7ce7c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/27368237736"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.1.0.9000",
      "date": "2026-06-11T18:26:05.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
      "fileid": "ee5d489fb4148091ea7e76b0bfd2111abf791e888f5484377b2d76f20fd1696e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/27368237736"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0.9000",
      "date": "2026-06-11T18:25:28.000Z",
      "arch": "aarch64",
      "commit": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
      "fileid": "7dd4462434ce8d7a24a21a917d9f4f28659a11e98785a8070781a70377fc52a2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/27368237736"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0.9000",
      "date": "2026-06-11T18:28:35.000Z",
      "arch": "x86_64",
      "commit": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
      "fileid": "96d74b328aabd093ac2380ce3bf897c98009be6d7fbd8c748c502a241e568400",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/27368237736"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.1.0.9000",
      "date": "2026-06-11T18:25:37.000Z",
      "arch": "aarch64",
      "commit": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
      "fileid": "e6fea0e9b7d6a2fee81455a0f38a98ec311c029b90aaa62b086df2c98736979f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/27368237736"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.1.0.9000",
      "date": "2026-06-11T18:26:48.000Z",
      "arch": "x86_64",
      "commit": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
      "fileid": "e415a008c48833256306b361f8b54d9c007d3a551af941acc97a2c8c9a38a328",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/27368237736"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0.9000",
      "date": "2026-06-11T18:26:03.000Z",
      "arch": "emscripten",
      "commit": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
      "fileid": "2ca02aec7acd9cc0fecc2dffe0005c044db878fa649c8bcfdff3b81486fd17fa",
      "status": "success",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/27368237736"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0.9000",
      "date": "2026-06-11T18:25:05.000Z",
      "arch": "x86_64",
      "commit": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
      "fileid": "2030bf7af13c8ac7b1ec3ee163c48dd267a0c1cd082b1ff923a4b0271204d545",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/27368237736"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.0.9000",
      "date": "2026-06-11T18:25:13.000Z",
      "arch": "x86_64",
      "commit": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
      "fileid": "d1be6568a50fca63bd9b3344a040c015846b8e81b723a357d5fdef989df5525c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/27368237736"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.1.0.9000",
      "date": "2026-06-11T18:25:11.000Z",
      "arch": "x86_64",
      "commit": "ca01ffd43f73b20aa602f0064b355d6d4933806d",
      "fileid": "aa1eeaed902eb5c56292dfb9ba44c63c89548ffac2506248b6a94d9ad3ad7f27",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sgl-projects/actions/runs/27368237736"
    }
  ]
}