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.