SQL Editor

Live Version 🔴

It's a web-based application capable of running SQL queries and displaying the results of said query.

Requirements

• npm

Libraries and Dependencies Used

• React

• Styled-Components

  npm install --save styled components
  

• React-Ace

  npm install react-ace ace-builds
  

• React-Icons

  npm install react-icons
  

• Redux

  npm install react-redux
  npm install @reduxjs/toolkit
  

• Firebase

  npm install firebase
  npm install -g firebase-tools   
  

How to run:

1. Clone the Repository.

2. Run npm install to install the project dependencies.

3. Run npm start to run the app in development mode.

4. App can be seen at: http://localhost:3000/

Page Load Time

Page Load TIme has been calculated by using the Lighthouse Tool.

Steps taken to Optimize

1. There was render blocking javascript for google font causing delay, used method mentioned here to overcome the problem.

2. Only importing used Module in a component from library rather than importing whole library.

3. Prevent browser from recording the cache memory using

   <meta http-equiv='cache-control' content='no-cache'>
   <meta http-equiv='expires' content='0'>
   <meta http-equiv='pragma' content='no-cache'>
   

create-react-app

This project was bootstrapped with Create React App. You can find more information on how to perform common tasks here.