{
  "_id": "6ae199d0327abcdf86863d5c",
  "Package": "dbVisuals",
  "Type": "Package",
  "Title": "Database-Powered Visualizations for Tabular Data",
  "Version": "0.1.0",
  "Authors@R": "c(\nperson(\"Edward C.\", \"Ruiz\", , \"ecr7407@gmail.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-9174-5387\")),\nperson(\"Timur\", \"Rizvanov\", , \"timurr@bu.edu\", role = \"aut\"),\nperson(\"Ruben\", \"Dries\", , \"rubendries@gmail.com\", role = c(\"aut\", \"rev\")),\nperson(\"National Human Genome Research Institute\", role = \"fnd\",\ncomment = c(grant = \"1R01HG014487-01\"))\n)",
  "Description": "Interactive, linked visualizations of tabular data held in\n'DuckDB' databases and data files, including spatial data such\nas 'GiottoDB' spatial omics datasets. A browser workspace built\non 'SQL Rooms' creates and links maps, tables and charts\nwithout code, and an 'htmlwidgets' viewer combines 'Mosaic'\nviews and 'deck.gl' layers over one 'DuckDB-WASM' instance and\none selection, so a brush in any view filters the others.\nResults of queries on a 'DuckDB' connection reach the browser\nas 'Arrow' data written by 'DuckDB', without materialising the\nrows in R. Complements the 'rDeckgl' and 'rMosaic' packages.\nBoth browser components load 'DuckDB-WASM' from a public\ncontent delivery network, so using them requires internet\naccess.",
  "License": "MIT + file LICENSE",
  "Copyright": "See file inst/COPYRIGHTS for the bundled JavaScript\nlibraries.",
  "URL": "https://github.com/dbverse-org/dbVisuals,\nhttps://dbverse-org.github.io/dbVisuals/",
  "BugReports": "https://github.com/dbverse-org/dbVisuals/issues",
  "Encoding": "UTF-8",
  "Config/Needs/check": "testthat, knitr, rmarkdown, duckdb, dbplyr, dplyr,\narrow",
  "Config/Needs/check-light": "testthat, knitr, rmarkdown",
  "Config/Needs/website": "knitr, rmarkdown",
  "VignetteBuilder": "knitr",
  "Config/roxygen2/version": "8.1.0",
  "Config/pak/sysreqs": "cmake make libuv1-dev libssl-dev zlib1g-dev",
  "Repository": "https://dbverse-org.r-universe.dev",
  "Date/Publication": "2026-10-28 00:50:27 UTC",
  "RemoteUrl": "https://github.com/dbverse-org/dbVisuals",
  "RemoteRef": "HEAD",
  "RemoteSha": "d831000ab69ec67647d819c33231915161a67031",
  "RemoteSubdir": "r-package",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-28 06:02:44 UTC",
    "User": "root"
  },
  "Author": "Edward C. Ruiz [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-9174-5387>),\nTimur Rizvanov [aut],\nRuben Dries [aut, rev],\nNational Human Genome Research Institute [fnd] (grant: 1R01HG014487-01)",
  "Maintainer": "Edward C. Ruiz <ecr7407@gmail.com>",
  "_user": "dbverse-org",
  "_type": "src",
  "_file": "dbVisuals_0.1.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/2634da45d15a3f3a60cec304dbcc541481fb0acc2cdeb0440de6048874ab8850",
  "_filesize": 5068082,
  "_sha256": "2634da45d15a3f3a60cec304dbcc541481fb0acc2cdeb0440de6048874ab8850",
  "_expires": "2027-02-05T06:44:30.000Z",
  "_created": "2026-10-28T06:02:44.000Z",
  "_published": "2026-10-28T06:44:32.012Z",
  "_upstream": "https://github.com/dbverse-org/dbVisuals",
  "_status": "success",
  "_maintainer": {
    "name": "Edward C. Ruiz",
    "email": "ecr7407@gmail.com",
    "login": "ed2uiz",
    "bluesky": "@ed2uiz.bsky.social",
    "description": "omics x infra x ai",
    "uuid": 32622519,
    "orcid": "0000-0002-9174-5387"
  },
  "_jobs": [
    {
      "job": 122660543418,
      "time": 320,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12796340098"
    },
    {
      "job": 122660543222,
      "time": 134,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12795927296"
    },
    {
      "job": 122660543238,
      "time": 2457,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12797199253"
    },
    {
      "job": 122660543278,
      "time": 114,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12795302712"
    },
    {
      "job": 122659295934,
      "time": 236,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12795986691"
    },
    {
      "job": 122660543421,
      "time": 206,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "12795952435"
    },
    {
      "job": 122660543297,
      "time": 71,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12796210198"
    },
    {
      "job": 122660543263,
      "time": 100,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12794859915"
    },
    {
      "job": 122660543245,
      "time": 96,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12795437459"
    }
  ],
  "_buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40641103148",
  "_commit": {
    "id": "d831000ab69ec67647d819c33231915161a67031",
    "author": "Eddie Ruiz <32622519+Ed2uiz@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #15 from dbverse-org/docs/news-0.1.0\n\nNEWS: single entry for the first release",
    "time": 1793148627
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "callr",
      "version": ">= 3.7.0",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "version": ">= 1.1.0",
      "role": "Imports"
    },
    {
      "package": "httpuv",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "version": ">= 1.8.0",
      "role": "Imports"
    },
    {
      "package": "openssl",
      "role": "Imports"
    },
    {
      "package": "base64enc",
      "role": "Imports"
    },
    {
      "package": "htmlwidgets",
      "version": ">= 1.5.4",
      "role": "Imports"
    },
    {
      "package": "htmltools",
      "version": ">= 0.5.0",
      "role": "Imports"
    },
    {
      "package": "stats",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "duckdb",
      "version": ">= 0.8.0",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "role": "Suggests"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    },
    {
      "package": "arrow",
      "version": ">= 12.0.0",
      "role": "Suggests"
    },
    {
      "package": "shiny",
      "role": "Suggests"
    },
    {
      "package": "nanoarrow",
      "role": "Suggests"
    },
    {
      "package": "adbcdrivermanager",
      "role": "Suggests"
    },
    {
      "package": "rDeckgl",
      "role": "Suggests"
    },
    {
      "package": "rMosaic",
      "role": "Suggests"
    },
    {
      "package": "remotes",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    }
  ],
  "_owner": "dbverse-org",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-25",
      "n": 6
    },
    {
      "week": "2026-27",
      "n": 1
    },
    {
      "week": "2026-31",
      "n": 1
    },
    {
      "week": "2026-41",
      "n": 1
    },
    {
      "week": "2026-44",
      "n": 11
    }
  ],
  "_tags": [],
  "_stars": 0,
  "_contributors": [
    {
      "user": "ed2uiz",
      "count": 52,
      "uuid": 32622519
    },
    {
      "user": "tirizvanov",
      "count": 11,
      "uuid": 172280653
    }
  ],
  "_userbio": {
    "uuid": 210240781,
    "type": "organization",
    "name": "dbverse-org",
    "followers": 7
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dbVisuals"
  },
  "_devurl": "https://github.com/dbverse-org/dbvisuals",
  "_pkgdown": "https://dbverse-org.github.io/dbVisuals/",
  "_searchresults": 5,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/dbVisuals.html",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_cranurl": false,
  "_exports": [
    "dbvisuals_export_htmlwidget",
    "export_htmlwidget",
    "install_dbvisuals_deps",
    "launchBrowser",
    "mgl_data",
    "mgl_deckgl",
    "mgl_spec",
    "mosaic_gl",
    "mosaic_glOutput",
    "renderMosaic_gl",
    "sqlrooms_export_table",
    "sqlrooms_register",
    "stop_sqlrooms"
  ],
  "_help": [
    {
      "page": "dbvisuals_export_htmlwidget",
      "title": "Export a dbVisuals spec as an htmlwidget",
      "topics": [
        "dbvisuals_export_htmlwidget",
        "export_htmlwidget"
      ]
    },
    {
      "page": "install_dbvisuals_deps",
      "title": "Install Complete dbVisuals Dependencies",
      "topics": [
        "install_dbvisuals_deps"
      ]
    },
    {
      "page": "launchBrowser",
      "title": "Launch the dbVisuals browser",
      "topics": [
        "launchBrowser"
      ]
    },
    {
      "page": "mgl_data",
      "title": "Declare a data source for a viewer spec",
      "topics": [
        "mgl_data"
      ]
    },
    {
      "page": "mgl_deckgl",
      "title": "Build a deck.gl input node for a Mosaic spec",
      "topics": [
        "mgl_deckgl"
      ]
    },
    {
      "page": "mgl_spec",
      "title": "Construct a top-level Mosaic spec for the viewer",
      "topics": [
        "mgl_spec"
      ]
    },
    {
      "page": "mosaic_gl",
      "title": "Render a linked Mosaic + deck.gl visualization",
      "topics": [
        "mosaic_gl"
      ]
    },
    {
      "page": "mosaic_glOutput",
      "title": "Shiny output binding for the Mosaic + deck.gl viewer",
      "topics": [
        "mosaic_glOutput"
      ]
    },
    {
      "page": "renderMosaic_gl",
      "title": "Shiny render expression for the Mosaic + deck.gl viewer",
      "topics": [
        "renderMosaic_gl"
      ]
    },
    {
      "page": "sqlrooms_export_table",
      "title": "Export Table to SQL Rooms",
      "topics": [
        "sqlrooms_export_table"
      ]
    },
    {
      "page": "sqlrooms_register",
      "title": "Register a lazy tbl or dbMatrix/dbSpatial as a VIEW in the SQL Rooms database",
      "topics": [
        "sqlrooms_register"
      ]
    },
    {
      "page": "stop_sqlrooms",
      "title": "Stop SQL Rooms Processes",
      "topics": [
        "stop_sqlrooms"
      ]
    }
  ],
  "_readme": "https://github.com/dbverse-org/dbVisuals/raw/HEAD/r-package/README.md",
  "_rundeps": [
    "askpass",
    "base64enc",
    "bslib",
    "cachem",
    "callr",
    "cli",
    "DBI",
    "digest",
    "evaluate",
    "fastmap",
    "fontawesome",
    "fs",
    "highr",
    "htmltools",
    "htmlwidgets",
    "httpuv",
    "jquerylib",
    "jsonlite",
    "knitr",
    "later",
    "lifecycle",
    "magrittr",
    "memoise",
    "mime",
    "openssl",
    "otel",
    "processx",
    "promises",
    "ps",
    "R6",
    "rappdirs",
    "Rcpp",
    "rlang",
    "rmarkdown",
    "sass",
    "sys",
    "tinytex",
    "xfun",
    "yaml"
  ],
  "_vignettes": [
    {
      "source": "getting-started.Rmd",
      "filename": "getting-started.html",
      "title": "Getting Started with dbVisuals",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "Installation",
        "Web app or R?",
        "Quick Start",
        "Launch with In-Memory Database",
        "Launch with GiottoDB Database",
        "Cleanup",
        "Ports and running two databases",
        "Next Steps"
      ],
      "created": "2026-06-16 22:42:18",
      "modified": "2026-10-28 00:08:38",
      "commits": 8
    },
    {
      "source": "visualization-examples.Rmd",
      "filename": "visualization-examples.html",
      "title": "Linked visualization examples",
      "engine": "knitr::rmarkdown",
      "headings": [
        "The three pieces",
        "1. Cross-filtered scatter with a marginal histogram",
        "2. Dimension-reduction pairs linked to a categorical bar",
        "3. Keeping data in DuckDB, and drawing polygons",
        "In Shiny",
        "See also"
      ],
      "created": "2026-10-27 14:39:37",
      "modified": "2026-10-27 22:00:49",
      "commits": 3
    },
    {
      "source": "reproducing-paper-figures.Rmd",
      "filename": "reproducing-paper-figures.html",
      "title": "Reproducing the Application Note figures",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Install",
        "Reproducing the published figures",
        "See also"
      ],
      "created": "2026-10-27 14:39:37",
      "modified": "2026-10-27 22:00:49",
      "commits": 4
    }
  ],
  "_score": 3.8750612633917,
  "_indexed": true,
  "_nocasepkg": "dbvisuals",
  "_universes": [
    "dbverse-org",
    "ed2uiz"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-10-28T06:07:44.000Z",
      "distro": "resolute",
      "commit": "d831000ab69ec67647d819c33231915161a67031",
      "fileid": "https://r2.ropensci.org/afd6542675e672428841b8d80d0b00df27fee1011bb31a831bb98588c79ff0d0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40641103148"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-10-28T06:05:04.000Z",
      "distro": "resolute",
      "commit": "d831000ab69ec67647d819c33231915161a67031",
      "fileid": "https://r2.ropensci.org/108ad3a7d0df732b4bce6fd4b41ca83ff3d6deedfa2d6300f26a33cb7d60402e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40641103148"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-10-28T06:43:40.000Z",
      "commit": "d831000ab69ec67647d819c33231915161a67031",
      "fileid": "https://r2.ropensci.org/304661e741ed6a84e72a60e354e51260a95be4bb23425c12189440b07fd512da",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40641103148"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-10-28T06:04:47.000Z",
      "commit": "d831000ab69ec67647d819c33231915161a67031",
      "fileid": "https://r2.ropensci.org/771576e1293dbff9b0fd067e22b47cae8399af4e107a0cd1332ab40db34a02ae",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40641103148"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0",
      "date": "2026-10-28T06:06:33.000Z",
      "commit": "d831000ab69ec67647d819c33231915161a67031",
      "fileid": "https://r2.ropensci.org/f9ed769a39ad1ef2cbfa456c3965e8b7d1bbd075773fe1aba5b8f711cc2bd521",
      "status": "success",
      "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40641103148"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-28T06:03:57.000Z",
      "commit": "d831000ab69ec67647d819c33231915161a67031",
      "fileid": "https://r2.ropensci.org/90514b5088e18e807b0e985935929cdbe80f2ca9a3fc8598f4250bda7c24d4a5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40641103148"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-28T06:04:15.000Z",
      "commit": "d831000ab69ec67647d819c33231915161a67031",
      "fileid": "https://r2.ropensci.org/4211633d8ee241c188eca23fe5baae44efc76794d945301a1e96b24985547765",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40641103148"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-28T06:04:08.000Z",
      "commit": "d831000ab69ec67647d819c33231915161a67031",
      "fileid": "https://r2.ropensci.org/0c8a47f8f42a2cd8850f328de626e3066d55b9554475af1459362b639ce0e06e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40641103148"
    }
  ]
}