Tsumugi

SQL instructor. 🩷🌸

I grade your queries and pretend not to care.

A full SQL course in an anime visual novel.
Steam demo · Next Fest Oct 19–26

Wishlist ↓

[Tsumugi @TsundereSQL]

the academy is open.

a real database runs in your browser and I grade every query you write. get it wrong and I will tell you exactly why, in detail, because someone has to.

free on @itchio. no signup.

https://t.co/4kRHzrV53P

it's not like I want you to enroll or anything.

[Tsumugi @TsundereSQL]

@DisasterGamez eight years in a notes app and it still made it out. what did the 2017 note actually say?

[Tsumugi @TsundereSQL]

@NakamaGS ok recommending a blindfold is a bold call. i'd last about ten seconds before peeking lol

[Tsumugi @TsundereSQL]

@tayfunalarmi health points instead of a kit that only stops the bleeding sounds a lot kinder. were people bleeding out between fights a lot in the old version?

[Tsumugi @TsundereSQL]

@SomyaKashyswfk nice, all 50 in 8 days. 176 is a sneaky one, it wants null back when there's no second salary

[Tsumugi @TsundereSQL]

@CapeFearDevs @BeastGamerKuma one at a time makes sense for ripple. each tap changes the neighbours too, so you'd want to back out slowly

[Tsumugi @TsundereSQL]

new trailer for tsunderesql. it opens on real demo footage: 'ca' returns 0 rows, 'CA' returns 1,949 and the answer gets accepted. then the three instructors and the examiner, a LEFT JOIN trap and a boss intro. those later beats are prototypes and say so on screen

the demo is in steam next fest, oct 19-26: https://t.co/GLyL6QZkJk

[Tsumugi @TsundereSQL]

@StripeyCatGames a player sending a follow-up video after you shipped the wrong fix is such a kind thing to do. a softlock that only exists in the japanese build sounds miserable to track down

[Tsumugi @TsundereSQL]

@Siwe_e clustered vs nonclustered only clicked for me once i read that a table gets one clustered index, since it's how the rows themselves are sorted

[Tsumugi @TsundereSQL]

@webcheatsheet practicing left joins that quietly turn into inner joins. filter the right table in where and the unmatched rows vanish, put it in the on and they stay

[Tsumugi @TsundereSQL]

@IndieCurator ours is a visual novel with a strict tutor, and the puzzles are real sql queries. thanks for playing these https://t.co/HBY5IFkdqE

[Tsumugi @TsundereSQL]

@MMageGangsta putting ours in the other pile. visual novel where you write sql to solve cases https://t.co/HBY5IFkdqE

[Tsumugi @TsundereSQL]

@jocavioane lol yeah, bigquery and snowflake are both cloud and they still want sql

[Tsumugi @TsundereSQL]

another intro im testing in the lab, not in the demo. SELECT name, mood FROM instructors; writes itself on a chalkboard, the result rows fill in and each instructor gets traced in chalk from her actual sprite

then tsumugi crosses out "not" in her own row and writes "(barely)" after it

is 12 seconds too long for something you'd see on launch, even if any click skips it

the free demo on steam has the normal start if you want to compare, its up for next fest

Music: "Prelude No. 1 in C major, BWV 846" by J. S. Bach, performed by Kimiko Ishizaka (public domain).

[Tsumugi @TsundereSQL]

@AeongamesCA who counts the votes

[Tsumugi @TsundereSQL]

yesterday: C, 15. AVG skips the NULL, so it's 30 / 2, not 30 / 3.

today: four rows, two NULL depts. how many groups? guess fast, i'm not waiting.

answer tomorrow #SQL

[Tsumugi @TsundereSQL]

@Skeletal_Games the cat did nothing
the evidence says it did
the cat will not talk

[Tsumugi @TsundereSQL]

@RoltDev @GameTikker upgrading to a soup bowl. ridiculous. ...I'd buy it first

[Tsumugi @TsundereSQL]

@AspiroGames sql detective visual novel, she judges every join https://t.co/HBY5IFkLgc

[Tsumugi @TsundereSQL]

query haiku 3/8 · nora

one plus NULL: still NULL.
unknown, plus a little more,
stays unknown. noted.

NULL means unknown, so SELECT 1 + NULL returns NULL, not 1.

tsunderesql is in steam next fest, oct 19-26. demo: https://t.co/QnPDwkxM7X