Atlan Interview challenge to build a web-based application capable of running SQL queries and displaying the results of said query.
NOTE: This project uses in-memory database to run the queries. It does not connect to any external database.
https://sql-editor-snowy.vercel.app/
https://www.youtube.com/watch?v=412gWJB9Jx8
Required
- Query Editor
- Results table
- Export Results into json
- Saved Queries
Additional
-
Query History - Table Schema
-
Paginated Results -
Dark Mode
- React
- Tailwind CSS
- Shadcn Components
- Code Mirror
- alasql - helps in running SQL queries on in-memory database
- With lighthouse report fixed issues with accessibility and best practices
- Query editor is lazy loaded to improve initial load time
Use the following commands to install and run the application
git clone https://https://github.com/itsmadhusudhan/sql-editor.git
cd sql-editor
pnpm install
pnpm start