Skip to contents

Getting Started with dbVisuals

Source: vignettes/getting-started.Rmd
getting-started.Rmd

Introduction

dbVisuals is a visualization workspace built on SQLRooms for interactive exploration of tabular and database-backed data, from DuckDB databases, dbverse objects and data files. With it you can:

  • open DuckDB databases and CSV, TSV, Parquet, JSON or Arrow files;
  • build linked maps, charts and tables, where a brush in one view filters the others;
  • launch the workspace from R, or combine Mosaic views and deck.gl layers in R with mosaic_gl().

Installation 

install.packages("dbVisuals")

# development version
install.packages("dbVisuals",
                 repos = c("https://dbverse-org.r-universe.dev",
                           "https://cloud.r-project.org"))

# Optional: Install all recommended dependencies
library(dbVisuals)
install_dbvisuals_deps()

dbVisuals works with two companion packages on CRAN:

  • rDeckgl - R interface to deck.gl for WebGL visualizations
  • rMosaic - R interface to Mosaic for interactive linked views

Web app or R?

The same workspace runs in two places.

  • The web app at dbvisuals.pages.dev runs entirely in your browser on DuckDB-WASM. Open DuckDB, CSV, TSV, Parquet, JSON or Arrow files from your computer; they are read in the browser and never uploaded. Nothing needs to be installed, and the data you can explore is limited by the browser’s memory.
  • launchBrowser() in R serves the workspace from your own machine. Called with no database, it works like the web app. Called with db_path (or an open DuckDB connection), a background R process runs native DuckDB on that database file and the workspace queries it there, so you can explore databases larger than the browser could hold. The local server listens only on 127.0.0.1 and uses a per-session token.

Either way, files you open in the browser stay in the browser; they are not copied into your R session.

Quick Start

Launch with In-Memory Database

Without a database file, the workspace runs on DuckDB-WASM in the browser, with the bundled demonstration tables.

library(dbVisuals)

# Launch the standalone browser workspace
dashboard <- launchBrowser()

Launch with GiottoDB Database

For spatial data, open a GiottoDB database.

library(dbVisuals)
library(GiottoDB)
library(GiottoData)
library(duckdb)

# Create a GiottoDB database
gobject <- loadGiottoMini("visium")
con <- dbConnect(duckdb(), dbdir = "my_spatial_data.duckdb")
gobject_db <- as_giottodb(gobject, con = con, temporary = FALSE)
dbDisconnect(con, shutdown = TRUE)

# Launch dbVisuals
dashboard <- launchBrowser(db_path = "my_spatial_data.duckdb")

Close every connection that writes to a database before opening it with launchBrowser(). To change the database from R, stop the workspace first, make your changes, close the connection and launch again.

Cleanup

When you’re done, clean up the background processes:

stop_sqlrooms(dashboard)

Ports and running two databases

The workspace uses ports 3001 (R server) and 5173 (browser app). If either is in use, choose others:

dashboard <- launchBrowser(db_path = "my_data.duckdb",
                           port = 3002, frontend_port = 5174)

Only one workspace runs per R session: a second launchBrowser() replaces the first, even on different ports. To work with two databases at once, use two R sessions.

Next Steps