Web App to Run SQL Query and get results
→ Built using React.Js
→ Styling : Material-UI
→ Form : Formik
→ Client takes in the query from user and send request to Server using Axios
→ Server sends back the response which is rendered on the client-side in the form of Data-Grid/Alert
→ Validation has been handled on frontend
→ Built using Node.Js, Express.Js
→ Database : MySQL hosted on Clever-Cloud
→ Middleware : morgan, cors
→ Server accepts the SQL query coming from client & forwards it to mysql plugin that processes & returns the response in JSON format
→ The JSON response is then sent to front-end
React.Js → React is a free and open-source front-end JavaScript library for building user interfaces based on UI components
Material-UI → Material-UI offers comprehensive range of production-ready UI components which gives great styling options to the application
Formik → Build forms in React, with ease
Axios → Promise based http client for web applications and node js development. It makes fetch requests easier to handle
express → Minimal and flexible Node.js web application framework that provides a robust set of features for web and mobile applications. t is designed for building web applications and APIs
mysql → A node.js driver for mysql
Frontend → https://sql-workbench.netlify.app/
Server → https://sql-workbench-server.herokuapp.com/
Frontend → https://github.com/saikatXshrey/sql-workbench/tree/master
Server → https://github.com/saikatXshrey/sql-workbench/tree/server
Mobile → 91/100
Desktop → 78/100