r/dataanalysis • • Oct 17 '26

Project Feedback A game where everything is SQL

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?

691 Upvotes

68 comments sorted by

21

u/Emergency-Message306 Oct 18 '26

I spend about an hour for the game. There are two things that catch my attention that can have more impact on new players learning the language.

  1. It seems pretty punishing if you enter a wrong value. Since set and update are locked skill, if someone makes a mistake during the data entry, it seems like there is no way to change it.

  2. You can find the discrepancy in the delivery. However, I can’t write the note in the in-game note section. Do I need to write down the discrepancy on my notebook, or is there other way to take note? Or should I create a database to keep track of the discrepancy? Without the skill, the task is going to be very difficult to accomplish.

8

u/avfrodrigo Oct 18 '26

Hi, thank you for taking the time to try the game out, really appreciate it.

You're right about the game being too punishing, I had the same impression and that why when creating a new game you can check the 2 check boxes to unlock everything since the start, this makes things easier and less punishing as you can run updates, alter, delete, and everything since the start and also makes the IDE behave more like a real one.

But I am not sure yet if I should simply remove this upgrades and leave everything open as default, so players focus on completing the stories with the citizens, and managing the store as they please, or if I should keep it, as a hard difficulty setting, because it will definitely makes things much slower as you need to pay for each upgrade and you'd be spending more time doing manual inserts, and later fixing things because now you just unlocked something you did not have before.

4

u/Emergency-Message306 Oct 18 '26

Ok. I see your point. It is fine to make some mistake in the progress but you can fix them afterward. That makes a lot more sense to me. I guess I just don't like it when I have a typo, but I can't fix it immediately XD.

By the way, the game doesn't let me complete the transaction; also, it didn't give me any customers on day 2. I am not sure what caused the issue. Let me know if you need more info.

4

u/avfrodrigo Oct 18 '26

Thanks again for the feedback, guess I need to play test it more. I'll take a look into that and I'll come back here once I have that fixed to let you know.

1

u/avfrodrigo Oct 19 '26

I think it should all be good now.
And there are many new things in the game since last time.

Thanks once again for the feedback, and off course, I invite you to try it out again.

7

u/pumpkinmoonrabbit Oct 18 '26

Your link is giving 429 Too Many Requests lol

9

u/avfrodrigo Oct 18 '26

I guess that's a good thing 😊

12

u/GwynLordOfCedar Oct 18 '26

Love the idea. Can you port this to Mac too so I can play it native on my MacBook instead of having to run the game through an emulator?

6

u/avfrodrigo Oct 18 '26

Probably, if I see the game can get some traction I'll put it on Steam am have it for other OS than only Windows.

0

u/GwynLordOfCedar Oct 18 '26

Great, thanks!

6

u/b3xcellent Oct 18 '26

Awesome! Next please do Python 🙃

6

u/avfrodrigo Oct 18 '26

You read my mind! The initial idea was a mix of SQL and programmable bots to run the store using python. For now I've scrapped the python part, don't think it fits anymore to the way things went while developing, maybe a DataMart 2? Or a game focused on Python.

Anyway, did you try the game? What are your thoughts?

5

u/dupontping Oct 18 '26

Love the idea, I’ll give it a go

1

u/avfrodrigo Oct 18 '26

Thanks! Please let me know what your thoughts are once you have played it.

3

u/Powder9 Oct 18 '26

Omg cant wait to try tomorrow! I’ve been learning sql this year and this sounds like so much fun.

1

u/avfrodrigo Oct 18 '26

Thank! Let me know what your thoughts when you do.

2

u/Thistlemanizzle Oct 18 '26

LMAO. I love this.

1

u/avfrodrigo Oct 18 '26

Thanks! Please let me know what your thoughts are once you have played it.

1

u/carlitospig Oct 18 '26

My 80’s kid heart is overjoyed. I need this for D3.js so I’ll actually get off my ass and learn it! 🙃

2

u/moreofmi01 Oct 18 '26

I’m definitely going to try it. I don’t use SQL very often in my day to day, so this will be a fun way to reacquaint myself.

1

u/avfrodrigo Oct 18 '26

Thanks! Please let me know what your thoughts are once you have played it.

121

u/GroundbreakingAlps78 Oct 18 '26

Where can I find apples in the store??

SELECT aisle
FROM inventory
WHERE product = 'Apples';

🥰🥰🥰

51

u/vmathematicallysexy Oct 18 '26

Worker: sorry, did you want apples or Apples?

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

21

u/GroundbreakingAlps78 Oct 18 '26

Haha yes *pples

38

u/hyrle Oct 18 '26

Found: Nipples.

17

u/GroundbreakingAlps78 Oct 18 '26

Well done! Both are aisle 5

6

u/GoullouLeouf86 Oct 18 '26

the fact that this feels so natural is kind of concerning tbh

12

u/Random-I-Am Oct 18 '26 edited Oct 18 '26

I thought this looked like Project Zomboid before the Knox event. That will be my head cannon as I go through this. 👍

2

u/BShaker9000 Oct 18 '26

Is it something that a real beginner can try?

5

u/avfrodrigo Oct 18 '26

Well you can always try, but in the current version of the game I am not sure there is a good progression for beginners.

But they would be a good feedback, if you think you're a beginner, try the game and let me know how you did, what you think would make it more friendly for SQL beginners ☺️

1

u/avfrodrigo Oct 19 '26

Some told me the images in the original post are not being shown.
As I cant edit the images in the original post, nor add multiple images to this comments, here is a video of the game!

1

u/kilopeter Oct 18 '26

Nice! What's the graphics engine? Is there an underlying 3D mesh to anything, is it procedural or raster?

Noticed the rainy screenshot's weather status says "sunny" :)

3

u/avfrodrigo Oct 18 '26

It's is made in Godot, must of the arts are just code, something like cars and the people are free assets I found online. Nothing is procedural in the sense of, it is different everytime, but it is procedural as most assets don't really exist and are generated by code as you play.

Thanks for telling about the screenshot mistake.

1

u/Helios270704 Oct 18 '26

Great idea! Will definitely give it a try!

1

u/avfrodrigo Oct 18 '26

Thanks! Please let me know what your thoughts are once you do.

1

u/lboogie757 Oct 18 '26

I'll try it out. It looks interesting

1

u/avfrodrigo Oct 18 '26

Thanks! Please let me know what your thoughts are once you have played it.

1

u/Jazzlike_Chemist_709 Oct 18 '26

Definitely trying it out. Looks like fun.

1

u/avfrodrigo Oct 18 '26

Thanks! Please let me know what your thoughts are once you have played it.

1

u/i_Homosapien Oct 18 '26

Pretty creative! Will try it out!

1

u/avfrodrigo Oct 18 '26

Thanks! Please let me know what your thoughts are once you have played it.

1

u/sheik_sha_ha Oct 18 '26

Would love this game 🤩🤩

1

u/avfrodrigo Oct 18 '26

Thanks! Please let me know what your thoughts are once you have played it.

1

u/Aggressive_Case4120 Oct 18 '26

Commenting so I can come back to this!

1

u/avfrodrigo Oct 18 '26

Please do, and once you have tried, come back again for a feedback, would like to know what your thoughts are.

1

u/HorrorVeterinarian94 Oct 18 '26

Is this the only way to come back?

1

u/AbundantAnfang Oct 18 '26

SQL Game 🤯

2

u/avfrodrigo Oct 18 '26

Eeeyi Yep, please give it a try and let me know what you think

1

u/competitivebeean Oct 18 '26

Thats pre cool

1

u/avfrodrigo Oct 18 '26

Thanks! Please let me know what your thoughts are once you have played it.

1

u/housebuyinghorror Oct 18 '26

Name?

1

u/avfrodrigo Oct 18 '26

Name of the game? If so, it is DataMart

1

u/carlitospig Oct 18 '26

The concept reminds me of how we would learn basic programming as a kid. Kudos!

How did you build it, if you don’t mind me asking?

3

u/avfrodrigo Oct 18 '26

I got to be honest, always wanted to build a game, never knew how and all seemed very distant and too much sacrifice to learn, then came Claude Code and Godot MCP

1

u/[deleted] Oct 18 '26

[removed] — view removed comment

1

u/avfrodrigo Oct 18 '26

Because something used AI doesn't mean it is slop, don't you use AI at work? So your work is AI slop?

Yes the game was created using AI, and what is not now days?

But if it makes people happier, I just edited the post.

1

u/DancingSouls Oct 18 '26

who cares lol

1

u/AbbreviationsVivid66 Oct 18 '26

omg I’m so excited to try it !

1

u/avfrodrigo Oct 18 '26

Thanks! Please let me know what your thoughts are once you have played it.

1

u/HumanAlive125 Oct 18 '26

Is it available for mac? 😔

2

u/avfrodrigo Oct 18 '26

Not yet, it's still in development, just wanted to put it out there to get people's feedback on it. If it goes well, I'll have it on Steam and definitely make it for Mac and Linux as well.

If you get to try the game with an emulator or a windows PC, please let me know what you think of it.

1

u/AutoModerator Oct 17 '26

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis. If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers. Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

2

u/[deleted] Oct 18 '26

[removed] — view removed comment

1

u/avfrodrigo Oct 18 '26

Thanks! Please let me know what your thoughts are once you have played it.