NotesViewer
About
NotesViewer is an interactive Shiny web application for exploring PostgreSQL tables. It provides a flexible UI for connecting to a database, selecting tables, applying server‑side filters, and visualising rows as cards, tables, or profiling summaries. The app is designed for quick ad‑hoc data inspection without writing SQL manually.
Access Package
# Clone the repository (if not already present)
git clone https://github.com/yourorg/NotesViewer.git
# Change to the project directory
setwd("NotesViewer")
# Install required packages
install.packages(c( "shiny", "bslib", "DBI", "RPostgres", "DT", "shinyjs", "shinycssloaders", "jsonlite", "srcr" ))Provenance
Developer Affiliation(s)
Description
NotesViewer lets you connect to any PostgreSQL database (the connection is resolved via the srcr package) and explore tables in a responsive, searchable UI. It is especially handy for:
- Inspecting raw rows from large tables.
- Applying ad‑hoc filters before loading data to minimise network traffic.
- Quickly locating records using plain‑text or PCRE regex searches.
- Exporting filtered results to CSV for downstream analysis.
Clinical Subject Headings
Creative Commons license
Except where otherwised noted, this item's license is described as a CC-BY Attribution 4.0 license.
This license applies to the metadata and documentation of this digital package. The source code and software components may be governed by different licensing terms. Please refer to the GitHub repository link for specific software licensing information.
This license applies to the metadata and documentation of this digital package. The source code and software components may be governed by different licensing terms. Please refer to the GitHub repository link for specific software licensing information.
Cite this Code
Master, S. (2025, December). NotesViewer. [Code]. PEDSpace Knowledge Bank. https://hdl.handle.net/20.500.14642/1658

