Skip to main content

Changelog

Every release of SQL-Campus and what it brought. We're in alpha: things move fast, and your feedback shapes what comes next.
SELECT version, released_at, notes
FROM releases
ORDER BY released_at DESC;

Query executed. The result is below.

  1. v0.2.0

    AlphaLatest

    Version 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.
  2. v0.1.0-alpha.2

    Alpha

    Second alpha

    Learning journeys and exercise packs, profiles and statistics for teachers, a system overview, AGENTS.md files for generating exercises and our own logo.

    New

    • Exercise packs and learning journeys, with wizards, an overview and a road of packs, exercises and info pages (Markdown).
    • Clicking an account in the console opens a quick view; its profile page shows courses, submissions, exam attempts, skills and audit log entries.
    • A downloadable AGENTS.md per exercise type for generating exercise files (including the schema for SQL), plus one each for datasets and journey pages.
    • Statistics for teachers: pass rates, attempts, score distribution, hardest exercises and activity over time — per course, exercise and student; also as a tab on instructor profiles.
    • A system overview for admins: health of the database, Redis, queues, grading workers and sandbox images, plus server stats.
    • Edit and delete for exercises, packs, journeys, courses, exams and accounts — every list supports multi-select for bulk deletion, plus “delete all exercises using this dataset”.
    • Pages in learning journeys with images, videos (YouTube, Vimeo, files with captions), Mermaid diagrams and links — in exercise texts too.

    Improved

    • Our own, minimal logo and favicon.

    Fixed

    • Crosswords move from cell to cell while typing again and stay on the clue you picked.
  3. v0.1.0-alpha.1

    Alpha

    First alpha

    The first public pre-release of SQL-Campus: real databases, dynamic grading, courses with a gradebook and many new exercise types.

    New

    • Schema explorer with an interactive ER diagram: a guided tour through every table, draggable tables, zoom, relationships and sample data.
    • A new, context-aware SQL autocomplete: keywords, tables after FROM/JOIN, columns of the tables in the query, dialect functions (Ctrl+Space).
    • A Moodle-style gradebook per course: every student against every assignment, with attempts, best result, lateness and CSV export.
    • Attempt limits: assigned exercises and exams allow one attempt by default; teachers can allow more, also for single students.
    • Searchable, sortable, filterable and groupable lists across the console, including an overview of who is in which course.
    • New exercise types: SQL word order puzzles, crosswords with and without a secret word, fix a broken query, set the cardinalities, and try a SQL injection.
    • A notification center and a calendar with everything that's coming up — urgent things first.
    • Course exercises and exams appear as cards in the overviews.
    • This changelog.

    Improved

    • A redesigned home page.
    • Submissions, courses and the console show names, titles and links instead of technical ids.

    Privacy & security

    • Cookie settings on the first visit: only strictly necessary storage is always on, everything else only with your consent.