r/letscodecommunity

I've spent the last few months building something and I'm finally at the point where I want to share it properly rather than just quietly hoping people find it.

The idea came from a frustration I kept seeing (and feeling myself): SQL tutorials teach the syntax fine but there's never a reason to care about the answer. You filter a table called employees, get a result, and nothing happens. Your brain doesn't bother keeping it.

I wanted to try a different approach. QueryCase teaches SQL through detective investigations. You get a briefing from Chief Fox (our mascot), a real database to query, and a mystery to crack. The JOIN matters when a suspect has an alibi. The WHERE clause matters when you're trying to find who entered the building at 22:13. The SQL is the tool for solving something, not the point in itself.

Here's what's actually in it:

• A structured learning path across 54 cases, going from Recruit through Rookie, Detective, Senior Detective, and Chief Detective. Each rank has drills and a level exam to pass before you progress.
• Sandbox mode where you can explore real datasets (IMDB movies, Spotify, sports stats, Steam games) and run whatever you want with no pressure and no mystery attached. Just free exploration against actual data.
• Everything runs in the browser using DuckDB WASM so there's nothing to install.

I'm a solo developer and this is genuinely early days. I'm sharing here because this community is exactly the kind of people I built it for, and I'd rather get honest feedback now than find out later I've built the wrong thing.

What's missing? What would make you actually stick with something like this versus what you've used before?

querycase.com if you want to take a look.

Any feedback appreciated!

I'm a Computer Science student who's just starting to build projects seriously.

One thing I kept struggling with was figuring out what to build . I'd spend hours watching tutorials or browsing GitHub instead of actually making progress.

So I started compiling beginner-friendly project ideas and resources that I found useful into a single repository. The goal is to help students and self-taught developers who know some basics but don't know where to go from there.

The projects are grouped by technology and difficulty level, and I plan to keep expanding the list as I learn more. I'd also love contributions from people who have resources or project ideas that helped them when they were starting out.

I'm still very much a beginner myself, so this isn't meant to be the "ultimate roadmap" this is just a starting point that can grow with the more people.

Hopefully, it helps someone else get from "I don't know what to build" to "I made my first project."

Repository: https://github.com/dezzki/0-to-projects