RSQLiteAdmin

About

RSQLiteAdmin is a comprehensive GUI tool written in R Shiny to explore, manage and update SQLite Databases. Its features include :

1. Creating/Deleting Databases.
2. Importing/Exporting data from delimited files.
3. Viewing/Editing data within tables.
4. Querying and Searching a database.
5. Filtering and summarizing a database.
6. Plotting charts for a database.

Note: This package was developed as a part of the Google Summer of Code 2020 & 2022 program.

Installation

Install the package via:

install.packages("rsqliteadmin")

Install the development version via:

devtools::install_github("https://github.com/rsqliteadmin/rsqliteadmin")

Running

Use this commmand to run the app:

rsqliteadmin::run_rsqliteadmin()

Mentors

Vijay Barve

Thiloshon Nagarajah

Narayani Barve

Marlon E. Cobos

Divyansh Chawla

Student Developer

Anushka Gupta