SQLA - The SQL EDITOR.

Live Demo

Deployed on Vercel - Open Here

Features

• Users can get data of any of the predefined SQL queries either by using SQL Editor or by choosing from dropdown menu.
• Users can also upload a CSV file of their own and perform SQL Queries on it.
• Users can sort data directly by clicking the Table Headers title.
• Users can search for a particular data among many records using the search bar.
• Users can navigate to different pages using pagination.
• Users can download the data in CSV and JSON Format in just one click.
• Users can see query runtime in milliseconds(ms).

Page Load Time

Page Load time of this website in desktop is in the range of 0.5 s to 1.2 s.

Lighthouse Report

GTmetrix Report

Steps I took to optimize the page load time

• Used code-splitting with React.Lazy() and Suspense to lazy load the components and split javaScript into multiple chunks using Dynamic runtime Imports for faster page load.
• 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:

yarn start

Runs the app in the development mode.
Open http://localhost:3000 to view it in your browser.

The page will reload when you make changes.
You may also see any lint errors in the console.

yarn test

Launches the test runner in the interactive watch mode.
See the section about running tests for more information.

yarn 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 for more information.

yarn eject

Note: this is a one-way operation. Once you eject, you can't go back!

If you aren't satisfied with the build tool and configuration choices, you can eject at any time. This command will remove the single build dependency from your project.

Instead, it will copy all the configuration files and the transitive dependencies (webpack, Babel, ESLint, etc) right into your project so you have full control over them. All of the commands except eject will still work, but they will point to the copied scripts so you can tweak them. At this point you're on your own.

You don't have to ever use eject. The curated feature set is suitable for small and middle deployments, and you shouldn't feel obligated to use this feature. However we understand that this tool wouldn't be useful if you couldn't customize it when you are ready for it.

Learn More

You can learn more in the Create React App documentation.

To learn React, check out the React documentation.

Code Splitting

This section has moved here: https://facebook.github.io/create-react-app/docs/code-splitting

Analyzing the Bundle Size

This section has moved here: https://facebook.github.io/create-react-app/docs/analyzing-the-bundle-size

Making a Progressive Web App

This section has moved here: https://facebook.github.io/create-react-app/docs/making-a-progressive-web-app

Advanced Configuration

This section has moved here: https://facebook.github.io/create-react-app/docs/advanced-configuration

Deployment

This section has moved here: https://facebook.github.io/create-react-app/docs/deployment

yarn build fails to minify

This section has moved here: https://facebook.github.io/create-react-app/docs/troubleshooting#npm-run-build-fails-to-minify

sql_editor