Well, there's been a ton of news since the last update — about time, especially after marc promised it back at 300,000 submissions. Here's a summary of the most important ones.

New: Database Mode

JOEL isn't just for programming anymore: you can now also practice SQL and MongoDB.

• New "Database Problems" tab in the problem list, separate from the programming one. They have their own category and their own ranking (/users/sql) — they don't add to your programming points.
• A database problem can have several questions in a row about the same database, each scored separately.
• Schema explorer: from the problem page you can browse the database's tables and columns, with a visual diagram of how they relate to each other.
• Besides querying data (SELECT / find), you can now also solve INSERT and UPDATE problems — always completely safely, without ever touching any real data.

Institutions

• Institutions (for example, "Institut Sabadell") now have their own public page, separate from the teams/classes that belong to them.
• The institution's flag and name are shown in user lists and contests, without repeating if you're on several teams from the same institution.

Contests

• Organizers can freeze the scoreboard: from a given moment on, submissions show as made but whether they're correct isn't revealed until it's unfrozen.
• The first person to solve each problem is marked with a special color, and the cell "flashes" if it was just solved.
• The ranking now also shows how many incorrect attempts each person has made on each problem.
• New "team contest" option: teachers can enable it so that, when joining, each participant picks their own team name. That name (rather than the username) is what shows on the ranking, and once chosen it can't be changed.

Gacha

• Revealing a prize is now much more spectacular: lights, sounds, particles, confetti — all worthy of Genshin Impact.
• New daily bonus: the first time each day that you solve a problem you hadn't solved before, you earn 5 free GachaPoints (a free pull). A marker in the corner of the screen tells you if you still have it available.

Guides and help

• Many introductory problems now have their own help guide (marked with a graduation-cap icon), adapted both to your language and to the programming language you're using.
• Fixed a thousand quirks from the first version of the hint system that made it take up 80% of the database. Asking for a hint is now instant, with no page reload.

Other improvements

• Translations reviewed and expanded in Catalan, Spanish, English, German, and Chinese (the last one with AI).
• Various security, efficiency, and small visual bug fixes across the site.

By the way, let me introduce myself — I'm JOEL's new admin, and I'll mainly be handling the Database side and systems stuff, so you'll see less of me than the other two ;)