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
Package: dbVisuals 0.1.0
Edward C. Ruiz
dbVisuals: Database-Powered Visualizations for Tabular Data
Interactive, linked visualizations of tabular data held in 'DuckDB' databases and data files, including spatial data such as 'GiottoDB' spatial omics datasets. A browser workspace built on 'SQL Rooms' creates and links maps, tables and charts without code, and an 'htmlwidgets' viewer combines 'Mosaic' views and 'deck.gl' layers over one 'DuckDB-WASM' instance and one selection, so a brush in any view filters the others. Results of queries on a 'DuckDB' connection reach the browser as 'Arrow' data written by 'DuckDB', without materialising the rows in R. Complements the 'rDeckgl' and 'rMosaic' packages. Both browser components load 'DuckDB-WASM' from a public content delivery network, so using them requires internet access.
Authors:
dbVisuals_0.1.0.tar.gz
dbVisuals_0.1.0.zip(r-4.7-any)dbVisuals_0.1.0.zip(r-4.6-any)dbVisuals_0.1.0.zip(r-4.5-any)
dbVisuals_0.1.0.tgz(r-4.6-any)dbVisuals_0.1.0.tgz(r-4.5-any)
dbVisuals_0.1.0.tar.gz(r-4.7-any)dbVisuals_0.1.0.tar.gz(r-4.6-any)
dbVisuals_0.1.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
dbVisuals/json (API)
| # Install 'dbVisuals' in R: |
| install.packages('dbVisuals', repos = c('https://dbverse-org.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/dbverse-org/dbvisuals/issues
Pkgdown/docs site:https://dbverse-org.github.io
Last updated from:d831000ab6. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel | OK | 320 | ||
| source / vignettes | OK | 236 | ||
| linux-release | OK | 134 | ||
| macos-release | OK | 114 | ||
| macos-oldrel | OK | 2457 | ||
| windows-devel | OK | 71 | ||
| windows-release | OK | 96 | ||
| windows-oldrel | OK | 100 | ||
| wasm-release | OK | 206 |
Exports:dbvisuals_export_htmlwidgetexport_htmlwidgetinstall_dbvisuals_depslaunchBrowsermgl_datamgl_deckglmgl_specmosaic_glmosaic_glOutputrenderMosaic_glsqlrooms_export_tablesqlrooms_registerstop_sqlrooms
Dependencies:askpassbase64encbslibcachemcallrcliDBIdigestevaluatefastmapfontawesomefshighrhtmltoolshtmlwidgetshttpuvjquerylibjsonliteknitrlaterlifecyclemagrittrmemoisemimeopensslotelprocessxpromisespsR6rappdirsRcpprlangrmarkdownsasssystinytexxfunyaml
Getting Started with dbVisuals
Last update: 2026-10-28
Started: 2026-06-16
Linked visualization examples
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
Last update: 2026-10-27
Started: 2026-10-27
Reproducing the Application Note figures
Install | Reproducing the published figures | See also
Last update: 2026-10-27
Started: 2026-10-27
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Export a dbVisuals spec as an htmlwidget | dbvisuals_export_htmlwidget export_htmlwidget |
| Install Complete dbVisuals Dependencies | install_dbvisuals_deps |
| Launch the dbVisuals browser | launchBrowser |
| Declare a data source for a viewer spec | mgl_data |
| Build a deck.gl input node for a Mosaic spec | mgl_deckgl |
| Construct a top-level Mosaic spec for the viewer | mgl_spec |
| Render a linked Mosaic + deck.gl visualization | mosaic_gl |
| Shiny output binding for the Mosaic + deck.gl viewer | mosaic_glOutput |
| Shiny render expression for the Mosaic + deck.gl viewer | renderMosaic_gl |
| Export Table to SQL Rooms | sqlrooms_export_table |
| Register a lazy tbl or dbMatrix/dbSpatial as a VIEW in the SQL Rooms database | sqlrooms_register |
| Stop SQL Rooms Processes | stop_sqlrooms |