jsta/schemer

Visualize SQLite structure with R :neckbeard:

schemeR

The goal of schemeR is to visualize SQLite databases.

Installation

You can install schemeR from github with:

# install.packages("devtools")
devtools::install_github("jsta/schemeR")

Usage

This is a basic example:

SQLite

library(schemeR)

db <- dplyr::lahman_sqlite()
res <- schemeR::render_sqlite(db)
schemeR::export_svg(res, "images/sqlite_example.png")

data.frame

df <- data.frame(
          "name" = 1:4,
          "people" = c("bob", "jim", "beatrice", "ann"))

res <- schemeR::render_df(df)
schemeR::export_svg(res, "images/df_example.png")

References

http://graphviz.org/content/datastruct

https://rich-iannone.github.io/DiagrammeR/graphviz_and_mermaid.html

rich-iannone/DiagrammeR#133