SQLEd is a SaaS app for colleges to conduct assignments or exercises for their students digitally.

The editor

The SQLEd Editor uses the Monaco editor (same as VSCode) to facilitate a rich SQL code writing experience. Students would write SQL code in the editor and click on the play button to execute their code. Which shows the result data in the below table.

Teachers create classrooms

Teachers create classrooms and invite students to join into their classroom, after which they can send exercises or assignments to the students.

Classrooms have assignments

Both students & teachers get to see their assignments with a intuitive progress bar indicating for teachers how many students have completed the assignment, and for students it shows how many questions are remaining for the assignment to be completed.

Creating a new assignment

When creating a new assignment, teachers give it a name, a few questions with a title and rich markdown explanation of the question. Along with a CSV data file, that the students can play with.

This data set is isolated for each student, so changes made by one student are not passed on to the other, allowing each student to play with the dataset and learn SQL syntax.

Password-less login

Both teachers & students need to remember a password to login to SQLEd, a magic link is sent to them via email if they have already signed up.

The tool can send reminders to students about new assignments or deadlines on existing ones via email or WhatsApp.

It is was aimed at Indian colleges that are still taking SQL assignments or exercises in paper.

How we built it

The ideation of the project started on 20th April 2024 and the first stable version was finished by 10th June 2024. We built it with:

1. Bun.js

2. React

3. TailwindCSS

4. Hono

5. tRPC

Thank you 😊