SQL Murder Mystery: teaching SQL concepts with a mystery game

Cory Doctorow 12:32 pm Wed Oct 9, 2019

SQL Murder Mystery is a free/open game from Northwestern University's Knight Lab that teaches the player SQL database query structures and related concepts while they solve imaginary crimes.

It was inspired by The Command Line Murders, a murder mystery game that teaches you to master Unix command-line syntax.

I love this kind of thing so much. Learning the abstruse syntaxes of power-users, network administrators and programmers gives users so much power over the computers they use.

SQL Murder Mystery [NU Knight Lab/Github]

(via Four Short Links)

Drone filmmaker captures Children's Fairyland from the view of a flying fairy — and it's downright magical

There's still magic in the world, as evidenced by this fairy's-eye view of Children's Fairyland, that charming 70-year-old storybook theme park in Oakland, California. You might remember that when I'm… READ THE REST
This deck of wholesome activities inspires mini-adventures

We've been writing about Lea Redmond since 2009 here on Boing Boing. She's just one of those kind of people who consistently makes neat things — a real Happy Mutant!… READ THE REST
This house for sale in Pittsburgh is filled with whimsical themed rooms

Listed at $159,900 this 1,075 square-foot home in Pittsburgh, Pennsylvania is bland on the outside but features rooms with outer space, submarine, tropical island, and moonbase motifs. The owners put… READ THE REST
Short Post, just one paragraph

Dessert cheesecake wafer bear claw fruitcake. Fruitcake chupa chups donut candy canes marzipan. Apple pie sweet roll tart chocolate cake macaroon marshmallow carrot cake gummi bears sweet. Pastry sugar plum… READ THE REST
Save 50% on a 1-year subscription to Dashlane's premium password manager

We all know vital information about ourselves and our private digital accounts can be compromised by cybercriminals. However, many would be frightened to know just how compromised they and their… READ THE REST
The Bite Helper removes the itch of a mosquito bite in seconds

While mosquitoes have certainly earned their title as the deadliest animal on earth, their impact on most of our lives is usually a lot less consequential. But even though they… READ THE REST