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.
Install the package via:
install.packages("rsqliteadmin")
Install the development version via:
devtools::install_github("https://github.com/rsqliteadmin/rsqliteadmin")
Use this commmand to run the app:
rsqliteadmin::run_rsqliteadmin()
Note: This package was developed as a part of the Google Summer of Code 2020 program.