A GUI to Manage SQLite Databases

A comprehensive tool written in R Shiny to explore, manage and update SQLite Databases.

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.

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()

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