Web app to interact with Redshift, MySQL and MongoDB

The project is an implementation of a web app which accepts an SQL query as input, and display the result as output. It was done as part of the project for the Rutgers course, CS 527 - Database System For Data Science.

You can find more details in this presentation.

You can also view the following videos to get a better idea:

• Explaining the dataset
• Demo of the app with Redshift and MySQL

Features

Here are some features of this implementation:

• Retrieves data from MySQL, Redshift and MongoDB using SQL queries.
• Handles error cases gracefully by displaying the error message and code.
• Able to execute DDL statements and Stored procedures as well.
• Auto complete the query beign typed using suggestions.
• Download result as HTML, CSV or JSON.

Steps:

1. Create an AWS account
2. Launch an EC2 micro instance
3. Create a S3 Bucket
4. Upload Instacart data to S3
5. Start a RDS (MySQL/ORACLE/SQL Server) Instance
6. Export data from S3 to MySQL
7. Start a Redshift Instance
8. Export data from S3 to Redshift
9. Start a MongoDB Instance
10. Import data into MongoDB

Contributors

• Jacob Celestine
• Anirudh Negi
• Rahul Dev Ellezhuthil
• Rasika Hasamnis

Screenshots