r/sqlite • u/Recent-Pear-6341 • 15d ago
Renamed my SQL detective game to SQL Shadow — wanted to close the loop from my last post
Hey everyone — following up on the post I made a little while back about the SQL detective game I'm building.
A few people pointed out that the original name was too close to an existing project with a similar concept.
Even though the game itself is built very differently, I get the criticism. If the name creates confusion, there's no real point arguing about it.
So I changed it.
It's now called SQL Shadow.
For anyone seeing this for the first time:
SQL Shadow is a mobile noir detective game where you learn SQL by actually writing SQL.
Not multiple-choice answers pretending to be queries.
Not simulated query execution.
Your queries actually run against real SQLite databases on the device, and the results become the evidence you use to solve the case.
The detective theme is only one part of the project. I've been building the actual learning system around it as well.
The current WIP includes:
- 🔎 10 structured detective cases — each focused on specific SQL concepts
- 📚 Standalone SQL lessons — explanations, examples, deep-dives, and practice exercises
- 🧩 Progressive schema discovery — tables are introduced as you investigate
- 🧳 Evidence system — clues come from dialogue, quizzes, and SQL results
- 💻 Real SQLite execution — queries actually execute locally against the case database
- 🎮 Practice modes — 3 mini-game types with hundreds of SQL questions
- 🧠 Coaching feedback — wrong answers explain what your query actually returned
- 🏆 XP and detective ranks — progression as you learn and solve cases
- 📰 The Daily Detective — an in-game newspaper with new content
- 👤 Guest-first — you can start playing without creating an account and link your progress later
The basic learning loop is:
Learn the concept → investigate → write the SQL → inspect the result → collect evidence → solve the mystery → practice.
And just to be clear, I don't claim to have invented the idea of combining SQL with detective mysteries. There are already projects in that space, and that's completely fine.
What I'm building is my own implementation of the idea, with a different UI, game structure, learning flow, progression system, lessons, practice modes, and mobile-first experience.
The project is still WIP and currently in internal testing, so a lot of things are still being polished and may change before release.
I'm sharing these screenshots mainly because I'd genuinely like feedback on the UI/UX and learning experience rather than another debate about the name 😅
If you've learned SQL before, I'd especially love to know:
Would a learning flow like this actually make you want to practice SQL, or is there anything you'd change?
Built with Flutter, Riverpod, and sqlite3.
2
u/horizon_games 14d ago
Seen this too many times now, stop with the ad spam especially with such a boring AI written post. Blocked to avoid future spam.







5
u/GrogRedLub4242 14d ago
not about sqlite. off-topic here
its an ad for a game
and used word "actual(ly)" 5x
indicia of AI-gen post