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.
-
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.
Following technologies and libraries are used for the development of this project.
(Performance using PageSpeed Insights)
(Performance using Chrome Devtools LightHouse)
- Lazy loaded output display.
- No error logs to the console.
- Used Vercel for hosting.