Student Project: SimpleQL

Channel:

Fullstack Academy

Subscribers:

58,000

Published on August 29, 2017 2:42:27 AM ● Video Link: https://www.youtube.com/watch?v=0BrDHeQ5hxw

Duration: 5:56

523 views

5

SimpleQL enables users to visualize the database schema, download the sql script for their database schema, and upload and visualize the data. SimpleQL uses Amazon RDS to create user databases. User can create tables, rename tables or fields, create associations and drop tables. User can use the same database for production application through API endpoints.


SimpleQL guards against SQL injections by cleaning the user inputs for any malicious query. User query in validated before making a request to Amazon RDS. SimpleQL provides api endpoints for developers to interact with their database. SimpleQL provides devID and api key for the user through the web interface. User can make requests to SimpleQL by hashing the api key with current time. SimpleQL verifies the user hashed key by finding the api key through dev ID and hashing it.

----
Fullstack Academy was recently ranked the #1 coding bootcamp in the U.S. Learn more at https://www.fullstackacademy.com