react-sql-editor

KO | EN

gitlite — search

#python #react #python3 #reactjs #java #typescript #github-config #api #docker #deep-learning #machine-learning #javascript

react-sql-editor

★ 17 Open GitHub ↗

A web-based application capable of running SQL queries and displaying the results of said query.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# 💻 REACT SQL Editor

## 📚 Description

Create, design and implement a web-based application capable of running SQL queries and displaying the results of said query. The application must include a space which accepts SQL queries in the form of user inputs, then runs the given query, and displays the result within the application..

This is a REACT SQL Editor built using ReactJs and TailwindCSS.

## 👨‍💻 Live Demo

Try out the website : [REACT SQL Editor](https://react-sql-editor-beta.vercel.app/)

## 👨‍🔧 Tech Stack

![React](https://img.shields.io/badge/react-%2320232a.svg?style=for-the-badge&logo=react&logoColor=%2361DAFB)
![TailwindCSS](https://img.shields.io/badge/tailwindcss-%2338B2AC.svg?style=for-the-badge&logo=tailwind-css&logoColor=white)

## ⚙️ Dependencies

- **_react-ace_**
- **_react-csv_**
- **_react-hot-toast_**
- **_tailwind-scrollbar-hide_**

## 👨‍💻 Features

:white_check_mark: Users can get data of any of the predefined SQL queries on the left Sidebar menu.\
:white_check_mark: Users can view all the table column on Right Sidebar menu.\
:white_check_mark: Users can check all the table value on clicking Table name of Right Sidebar menu.\
:white_check_mark: Users can download the data in CSV Format in just one click.\
:white_check_mark: Users can see query runtime in milliseconds(ms).

## ✍️ Predefined SQL Queries

- `select * from customers;`
- `select * from suppliers;`
- `select * from products;`
- `select contact_name, address,city,postal_code, country from customers limit 18;`

## ⏱ Page Load Time

Page Load time of this website in desktop is in the range of 0.4 s to 0.6s.
we can check code spnappyness GTmetrix Grade.

![GTmetrix Grade Report](https://raw.githubusercontent.com/sambitos23/react-sql-editor/master/Screenshot/snapyness.PNG)

### [web.dev Report](https://pagespeed.web.dev/)

Laptop performance view

![web.dev Report](https://raw.githubusercontent.com/sambitos23/react-sql-editor/master/Screenshot/performance.PNG)

Mobile performance view

![web.dev Report](https://raw.githubusercontent.com/sambitos23/react-sql-editor/master/Screenshot/mobileperformance.PNG)

## 🪜 Steps I took to optimize the page load time

- Used Lighthouse DevTools Extension to find the performance issues and fix them using their actionable suggestion.
- Used vercel to deploy this website to leverage its Vercel Edge Network compression that results in the better performance.

## Available Scripts

In the project directory, you can run:

### `npm install`

To install all the packages in package.json. This will install all the dependencies and devDependencies.

### `npm start`

Runs the app in the development mode.\
Open [http://localhost:3000](http://localhost:3000) to view it in the browser.

The page will reload if you make edits.\
You will also see any lint errors in the console.

### `npm run build`

Builds the app for production to the `build` folder.\
It correctly bundles React in production mode and optimizes the build for the best performance.

The build is minified and the filenames include the hashes.\
Your app is ready to be deployed!

See the section about [deployment](https://facebook.github.io/create-react-app/docs/deployment) for more information.

## 🚀 Project Output

![Homepage](https://raw.githubusercontent.com/sambitos23/react-sql-editor/master/Screenshot/main_project.PNG)

react-sql-editor

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README