Skip to content

A web-based application that provides a SQL editor to run queries and display results.

Notifications You must be signed in to change notification settings

227001/sql-editor

 
 

Repository files navigation

SQL Online Editor

SQL Online Editor aims to provide users with a seamless and user-friendly platform for executing SQL queries, displaying query results in a table, maintaining a query history log, and supporting the export of results in CSV formats. The application will also provide a list of themes to change the editor UI and available tables in the sidebar for easy reference.

Project Overview

Project Overview

Key Features 📌

  • SQL Query Execution: The application will allow users to input custom SQL queries and execute them against the connected database.

  • Result Tabular Display: The application will present query results in a tabular format with a smooth scroll. This ensures that large datasets are easily navigable, enhancing the user experience.

  • Query History: The application will maintain a history log of all executed queries. Users can revisit previous queries, and re-run them as needed.

  • Export Data: Users will have the option to download query results in CSV format.

  • List of Available Tables: The application's sidebar will display a list of available tables in the connected database.

  • Change Editor Theme and Size: The user can change the theme of the Editor by selecting the option from the dropdown and expanding or shrinking the editor size.

Techstack used 🛠️

The following technologies and libraries are used for the development of this project.

Demo Screenshots

Query History

Available tables

Changed Theme

Performance

(Performance using PageSpeed Insights)

Pagespeed

(Performance using Chrome Devtools LightHouse)

Chrome Lighthouse

Optimisation

  • Lazy loaded output display.
  • No error logs to the console.
  • Used Vercel for hosting.

Community and Contributions

We warmly welcome all contributors! The Project is meant to build a community and it welcomes open collaboration. As you get started, please review this project's contributing guidelines. Whether you are a user or code contributor and whether you're opening an issue or a pull request, know that any form of your engagement is considered a contribution and is appreciated. Contributors are expected to adhere to the Code of Conduct.

Thanks to these wonderful Contributors 🌻

Contributors

About

A web-based application that provides a SQL editor to run queries and display results.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • JavaScript 97.5%
  • HTML 2.1%
  • CSS 0.4%