DbVieweR

Project
Package
R
DBMS
SQL
Author

David Munoz Tord

Published

February 12, 2024

DbVieweR an R package for database management

DbVieweR is a Shiny app that simulates a database management system, featuring functions like login/logout, save/create/delete tables, and add/rename columns.



Demo
Description

Highlights of this app:

- Back-end database: Utilizes SQLite or PostgreSQL for storing dummy data.
- Authorization: Incorporates the shinyauthr package to add an authentication layer to the app.


Features of the app:

- Save tables: Store sales summary tables in the database.
- Update existing tables: Rename tables or columns.
- Create new tables: Customize table and column names, with options for integer, float, varchar(255), and boolean columns.
- Create entries: Add entries to tables with customizable column types.
- Delete tables: Accessible only with specific authorization.
- Robustness: Defense mechanism prevents duplicates, invalid expressions, and conflicts with SQL keywords.


Check out the project on GitHub.