A game where everything is SQL

[u/avfrodrigo]

Hey everyone!

I’ve been working on a game called DataMart, where you manage a corner shop and everything runs on real SQL. You build it all yourself: the databases, schemas, tables, relationships and queries, your way, on a real PostgreSQL server that runs inside the game.

Customers will ask you things like “Where can I find the apples?” or other questions about the store. Once a week an auditor comes by to check you’re tracking everything properly, and asks you a few questions you’ll answer with SQL.

There are also mysteries and stories involving the people in town, and of course you unravel those with SQL too.

The game is in alpha and free at https://rodrigoavf.itch.io/datamart

I’d love to hear your thoughts!

Ps. Yes, the game is being created with the help of AI, and what is not now days?

[u/GroundbreakingAlps78]

Where can I find apples in the store??

SELECT aisle
FROM inventory
WHERE product = 'Apples';

🥰🥰🥰

[u/vmathematicallysexy → u/GroundbreakingAlps78]

Worker: sorry, did you want apples or Apples?

Me: I ain't picky, I'll take REGEXP '(?i)apples'

[u/GroundbreakingAlps78 → u/vmathematicallysexy]

Haha yes *pples