v0.2.0
AlphaLatestVersion 0.2
A new look like a SQL console, a home page with your next steps, smarter SQL feedback, sign-in with Reddit and a guided tour with Tommy, our campus cat.
New
- A home page with your next steps: open assignments first, then exercises, packs and journeys picked for you, and a “worth another try” shelf.
- Sign in and sign up with Reddit, next to Google and GitHub. Reddit doesn't share your email, so a first Reddit sign-in asks for one and confirms it by mail.
- A guided tour narrated by Tommy: it starts on your first visit and can be restarted from your profile at any time.
- Search in the header across courses, journeys, packs, exams and exercises.
- A public roadmap board and a feedback button on every page — anonymous if you like.
- Smarter SQL feedback: a syntax check before your query runs, partial points per clause, and your result next to the expected one.
- Exercises show only the tables they need; the rest of the schema folds away.
- “Start over” in exercises puts your answer back to the beginning.
- For teachers: assign packs and journeys to courses with instructions, an anti-copy setting for exercises and exams, and a “view as student” switch.
- Bulk upload of whole bundles: dataset schemas, packs and exercises with their German texts in one go.
- An MCP server, so instructors and admins can work with SQL-Campus from AI assistants using personal access tokens.
- Tommy also guards the 404 page and keeps you company while pages load.
Improved
- A new look in the style of a SQL console: every menu entry shows the query behind its page, lists are editable statements with result grids, and forms read like table records.
- Your home page is now the start page (/). Signed out, you see the login page instead, without the header.
- With reduced motion turned on, the effects on the start page stay still too.
Fixed
- Feedback no longer marks columns wrong when a result is empty and has no column names.