{
  "_id": "6ac8c5c3de46216d5edd6e72",
  "Package": "dbplot",
  "Version": "0.4.0",
  "Title": "Simplifies Plotting Data Inside Databases",
  "Description": "Leverages 'dplyr' to process the calculations of a plot\ninside a database. This package provides helper functions that\nabstract the work at three levels: outputs a 'ggplot', outputs\nthe calculations, outputs the formula needed to calculate bins.",
  "Authors@R": "person(\"Edgar\", \"Ruiz\", email = \"edgararuiz@gmail.com\", role = c(\"aut\", \"cre\"))",
  "License": "MIT + file LICENSE",
  "URL": "https://github.com/edgararuiz/dbplot",
  "BugReports": "https://github.com/edgararuiz/dbplot/issues",
  "RoxygenNote": "7.3.3",
  "Encoding": "UTF-8",
  "Config/testthat/edition": "3",
  "Repository": "https://edgararuiz.r-universe.dev",
  "Date/Publication": "2026-03-13 16:57:18 UTC",
  "RemoteUrl": "https://github.com/edgararuiz/dbplot",
  "RemoteRef": "HEAD",
  "RemoteSha": "2b14d024d4476463329c9fc1d8d525745fb4a783",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-09 10:07:01 UTC",
    "User": "root"
  },
  "Author": "Edgar Ruiz [aut, cre]",
  "Maintainer": "Edgar Ruiz <edgararuiz@gmail.com>",
  "_user": "edgararuiz",
  "_type": "src",
  "_file": "dbplot_0.4.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/c290368dc87256e75ee197eefda8718defb2958abb64236e9ca47b9260ec1ebf",
  "_filesize": 634546,
  "_sha256": "c290368dc87256e75ee197eefda8718defb2958abb64236e9ca47b9260ec1ebf",
  "_expires": "2027-01-17T10:45:21.000Z",
  "_created": "2026-10-09T10:07:01.000Z",
  "_published": "2026-10-09T10:45:23.703Z",
  "_buildurl": "https://github.com/r-universe/edgararuiz/actions/runs/37915158128",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 113770973861,
      "time": 118,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11609712765"
    },
    {
      "job": 113770973850,
      "time": 127,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11609403001"
    },
    {
      "job": 113770973839,
      "time": 116,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11610278838"
    },
    {
      "job": 113770973911,
      "time": 97,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11610973783"
    },
    {
      "job": 113769543552,
      "time": 246,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11608463396"
    },
    {
      "job": 113770973838,
      "time": 91,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11608993408"
    },
    {
      "job": 113770973848,
      "time": 92,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11609488264"
    },
    {
      "job": 113770973823,
      "time": 81,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11609447760"
    },
    {
      "job": 113770973865,
      "time": 81,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11609822532"
    }
  ],
  "_upstream": "https://github.com/edgararuiz/dbplot",
  "_commit": {
    "id": "2b14d024d4476463329c9fc1d8d525745fb4a783",
    "author": "Edgar Ruiz <77294576+edgararuiz@users.noreply.github.com>",
    "committer": "Edgar Ruiz <77294576+edgararuiz@users.noreply.github.com>",
    "message": "Adds cran submission\n",
    "time": 1773421038
  },
  "_maintainer": {
    "name": "Edgar Ruiz",
    "email": "edgararuiz@gmail.com",
    "login": "edgararuiz",
    "bluesky": "@theotheredgar.bsky.social",
    "linkedin": "in/edgararuiz",
    "description": "",
    "uuid": 77294576
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "dplyr",
      "version": ">= 1.0.0",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "version": ">= 1.0.0",
      "role": "Imports"
    },
    {
      "package": "ggplot2",
      "version": ">= 3.3.0",
      "role": "Imports"
    },
    {
      "package": "purrr",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "version": ">= 2.0.0",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "tidyr",
      "role": "Suggests"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "lifecycle",
      "role": "Suggests"
    },
    {
      "package": "duckdb",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    },
    {
      "package": "nycflights13",
      "role": "Suggests"
    }
  ],
  "_owner": "edgararuiz",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-11",
      "n": 20
    }
  ],
  "_tags": [
    {
      "name": "v0.4.0",
      "date": "2026-03-13"
    }
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "edgararuiz",
      "count": 138,
      "uuid": 77294576
    },
    {
      "user": "edgararuiz-zz",
      "count": 25,
      "uuid": 7875923
    },
    {
      "user": "dominickg",
      "count": 1,
      "uuid": 23463148
    },
    {
      "user": "lionel-",
      "count": 1,
      "uuid": 4465050
    }
  ],
  "_userbio": {
    "uuid": 77294576,
    "type": "user",
    "name": "Edgar Ruiz",
    "followers": 99
  },
  "_downloads": {
    "count": 1391,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dbplot"
  },
  "_devurl": "https://github.com/edgararuiz/dbplot",
  "_searchresults": 203,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/dbplot.html",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/edgararuiz/dbplot",
  "_realowner": "edgararuiz",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2017-11-21"
    },
    {
      "version": "0.1.1",
      "date": "2017-11-28"
    },
    {
      "version": "0.2.0",
      "date": "2018-01-05"
    },
    {
      "version": "0.2.1",
      "date": "2018-03-11"
    },
    {
      "version": "0.3.0",
      "date": "2018-05-06"
    },
    {
      "version": "0.3.1",
      "date": "2019-03-04"
    },
    {
      "version": "0.3.2",
      "date": "2019-07-02"
    },
    {
      "version": "0.3.3",
      "date": "2020-02-07"
    },
    {
      "version": "0.4.0",
      "date": "2026-03-13"
    }
  ],
  "_exports": [
    "db_bin",
    "db_compute_bins",
    "db_compute_boxplot",
    "db_compute_count",
    "db_compute_raster",
    "db_compute_raster2",
    "dbplot_bar",
    "dbplot_boxplot",
    "dbplot_histogram",
    "dbplot_line",
    "dbplot_raster"
  ],
  "_help": [
    {
      "page": "db_bin",
      "title": "Bin formula",
      "topics": [
        "db_bin"
      ]
    },
    {
      "page": "db_compute_bins",
      "title": "Calculate histogram bins",
      "topics": [
        "db_compute_bins"
      ]
    },
    {
      "page": "db_compute_boxplot",
      "title": "Returns a dataframe with boxplot calculations",
      "topics": [
        "db_compute_boxplot"
      ]
    },
    {
      "page": "db_compute_count",
      "title": "Aggregates over a discrete field",
      "topics": [
        "db_compute_count"
      ]
    },
    {
      "page": "db_compute_raster",
      "title": "Aggregates intersections of two variables",
      "topics": [
        "db_compute_raster",
        "db_compute_raster2"
      ]
    },
    {
      "page": "dbplot_bar",
      "title": "Bar plot",
      "topics": [
        "dbplot_bar"
      ]
    },
    {
      "page": "dbplot_boxplot",
      "title": "Boxplot",
      "topics": [
        "dbplot_boxplot"
      ]
    },
    {
      "page": "dbplot_histogram",
      "title": "Histogram",
      "topics": [
        "dbplot_histogram"
      ]
    },
    {
      "page": "dbplot_line",
      "title": "Line plot",
      "topics": [
        "dbplot_line"
      ]
    },
    {
      "page": "dbplot_raster",
      "title": "Raster plot",
      "topics": [
        "dbplot_raster"
      ]
    }
  ],
  "_pkglogo": "https://github.com/edgararuiz/dbplot/raw/HEAD/man/figures/logo.svg",
  "_readme": "https://github.com/edgararuiz/dbplot/raw/HEAD/README.md",
  "_rundeps": [
    "cli",
    "cpp11",
    "dplyr",
    "farver",
    "generics",
    "ggplot2",
    "glue",
    "gtable",
    "isoband",
    "labeling",
    "lifecycle",
    "magrittr",
    "pillar",
    "pkgconfig",
    "purrr",
    "R6",
    "RColorBrewer",
    "rlang",
    "S7",
    "scales",
    "tibble",
    "tidyselect",
    "utf8",
    "vctrs",
    "viridisLite",
    "withr"
  ],
  "_score": 4.6269144269609415,
  "_indexed": true,
  "_nocasepkg": "dbplot",
  "_universes": [
    "edgararuiz"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.4.0",
      "date": "2026-10-09T10:08:57.000Z",
      "distro": "resolute",
      "commit": "2b14d024d4476463329c9fc1d8d525745fb4a783",
      "fileid": "https://r2.ropensci.org/9673995917d4e068d73439659a9127a68cd14759f4298294ee755fca0e334931",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/edgararuiz/actions/runs/37915158128"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.4.0",
      "date": "2026-10-09T10:09:00.000Z",
      "distro": "resolute",
      "commit": "2b14d024d4476463329c9fc1d8d525745fb4a783",
      "fileid": "https://r2.ropensci.org/67e9ef5cfb3daf2fb921108385359d9774be2c1f64241aff5e216714789df770",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/edgararuiz/actions/runs/37915158128"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.4.0",
      "date": "2026-10-09T10:44:24.000Z",
      "commit": "2b14d024d4476463329c9fc1d8d525745fb4a783",
      "fileid": "https://r2.ropensci.org/421a1e7abea2f3eb67292e5203d351afb95b2b0a8e96ea3bc4b9a3361c3555e6",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/edgararuiz/actions/runs/37915158128"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.4.0",
      "date": "2026-10-09T10:41:29.000Z",
      "commit": "2b14d024d4476463329c9fc1d8d525745fb4a783",
      "fileid": "https://r2.ropensci.org/cb3d6f20db5a4e2da843d9e6f1bf4f36f6fcde0564f97f87fc1a7e69f33b34b5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/edgararuiz/actions/runs/37915158128"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.4.0",
      "date": "2026-10-09T10:08:53.000Z",
      "commit": "2b14d024d4476463329c9fc1d8d525745fb4a783",
      "fileid": "https://r2.ropensci.org/bdd03f073c3883e5bfb62a257e3aa160b04aee1d7475143388f1b5e0faa4d5b6",
      "status": "success",
      "buildurl": "https://github.com/r-universe/edgararuiz/actions/runs/37915158128"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.4.0",
      "date": "2026-10-09T10:08:16.000Z",
      "commit": "2b14d024d4476463329c9fc1d8d525745fb4a783",
      "fileid": "https://r2.ropensci.org/1aebf1730d1075c076d4f70b7cb3cb4be4d718dd30a1b38f072f241bc26acb29",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/edgararuiz/actions/runs/37915158128"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.4.0",
      "date": "2026-10-09T10:08:09.000Z",
      "commit": "2b14d024d4476463329c9fc1d8d525745fb4a783",
      "fileid": "https://r2.ropensci.org/753c50a2f1f1d75c6fbd9851ac26adeca1557710947b2135d8200376f47d88c1",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/edgararuiz/actions/runs/37915158128"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.4.0",
      "date": "2026-10-09T10:08:08.000Z",
      "commit": "2b14d024d4476463329c9fc1d8d525745fb4a783",
      "fileid": "https://r2.ropensci.org/43fd95babc97c2f0018294535eb12d1edb7ea8df0cf8bb5bd54329533925ed6e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/edgararuiz/actions/runs/37915158128"
    }
  ]
}