About The Project

SQL Editor for Data Analysts where they can perform SQL queries and see the results.(Only Front-end)

Built With

• React.js
• styled-components
• react-data-table-component

Usage

The app is hosted for the public at https://atlan-sql-editor-kapaman.netlify.app/

Features

• Tabbed Structure to access Results and Query Quickly.

• Workspace tab to quickly access the tables already generated.

• Preview feature to check all the keys of a particular table without actually querying for it. Useful for data analysts as they don't need to query the entire table just to check the keys the table has. Also potential to add some more metadata regarding type of key (string,number etc) which can add to the overall User Experience.

  

• Minimizing the Workspace tab when not in use to save space.

• Table generated using a light-weight react table library for performance gains.

  

• Export Results in JSON format(can be extended to other formats based on user needs).

Load Time

I calculated the Load time using various websites all of which indicate that on average the load time appears to be around 600-700ms.

Google Page Insights:

Performance Score: 99

First Contentful Paint : 0.7s

gtMetrix:

Latest Contentful Paint: 462ms

tools.pingdom:

Load Time: 633ms