SQLLearn
A full-stack MySQL learning platform with student progress tracking
Technologies Used
ReactTypeScriptMySQLHonoTailwind CSS
Project Overview
SQLLearn is an interactive platform designed to teach MySQL through hands-on exercises and real-time feedback. The platform offers a structured learning path from basic queries to advanced database operations.
Key Features
- •Interactive SQL editor with syntax highlighting and error detection
- •Progress tracking with completion badges
- •Admin dashboard for content management
- •Responsive design for all device sizes
Challenges
- •Implementing a secure SQL execution environment
- •Designing an intuitive user interface for complex queries
- •Managing student progress data efficiently
- •Adapting to a new tech stack
Solutions
- •Created a separate database to protect the main database from attacks
- •Followed design best practices
- •Implemented a chart for teacher to access the student progress
- •Asked for help, and read documentation if I was stuck
Lessons Learned
- •Importance of proper input sanitization for SQL queries
- •Value of immediate feedback in learning interfaces
- •Reduce the amount of features implemented