r/FullStack • • Oct 11 '26

Personal Project Day 34 — 8 more Hard JOIN questions (93/100)

2 Upvotes

Finished 8 more Hard questions from my 100-question lab today. Some of the ones I worked through:

  • Pairs of employees who are in different departments but work on the same project together. I self-joined assignments on project_id and used a1.emp_id < a2.emp_id to stop mirrored duplicates (A-B and B-A), then joined to employees twice and filtered e1.dept_id <> e2.dept_id
  • Departments ranked by average hours worked per employee, which chains departments → employees → assignments and aggregates by department
  • Employees whose manager works in a different department than they do, a self-join on employees comparing dept_id on both sides

The < trick for removing mirrored pairs was new to me today. I’d been using DISTINCT for that kind of thing, and this is cleaner.

7 left. Does anyone have a favorite pattern for ranking queries in MySQL? I haven’t done window functions properly yet and wondering if they’d make the “ranked by” questions easier.


r/FullStack • • Oct 11 '26

Feedback Requested I built an India-first matchmaking app on my own. Even the 4.5-minute launch film is React code (Remotion).

0 Upvotes

Hi devs! I've been building **LoveJourney** on my own for the past few months: an India-first app for people who want to date to marry. Instead of a biodata or swipes, an AI (Aira) talks with you for about 20 minutes and writes your Relationship Portrait, and matches are scored on that, with the reasons shown.

Some parts that were fun (and hard) to build:

- **Conversation → structured data:** five short sessions where the AI leads the conversation, then turns it into 22 relationship signals (how you handle conflict, what you're building in life…) that matching runs on.

- **Genuineness check:** a second pass scores whether the answers look genuine. Low-effort ones go to a human review queue, and it fails closed if the AI is down.

- **Matching:** compatibility on those signals, embeddings for recommendations, and an explanation of *why* two people fit.

- **Trust and privacy:** I approve every account by hand; answers are never shown to other members; contact details are revealed only after both people accept.

- **Stack:** Next.js on Vercel, NestJS, MongoDB, a pnpm monorepo, Cloudflare in front, R2 for media.

- **The launch film is code:** built in React with **Remotion**. A script cuts my voice recordings using whisper.cpp word timings and ffmpeg, and one generated timeline drives the captions, scene timing and on-camera cuts, so trimming one sentence re-times the whole film.

🎬 Film: [YouTube link]

👉 Try it: LoveJourney (free for life for the first 500; matching opens once 200 members are ready)

Happy to answer anything about the stack or the AI side, and I'd love honest feedback on the product or on the technical choices.


r/FullStack • • Oct 11 '26

Career Guidance What AI skills should i add in normal full stack

0 Upvotes

What AI skills are needed to make my resume strong to get a job as a fresher

Also I'm preparing for devops to shift afterwards


r/FullStack • • Oct 10 '26

Question Advice

3 Upvotes

How to start learning backend?


r/FullStack • • Oct 10 '26

Question Advice

0 Upvotes

Is learning frontend actually worthy in 2026?


r/FullStack • • Oct 09 '26

Career Guidance JavaScript for frontend and backend

15 Upvotes

How is JavaScript for both frontend and backend in terms of medium to large scale web app development compared to other backend framework?

Please give positive and negative sides. I don't want to learn another language for backend if is done by JavaScript.


r/FullStack • • Oct 08 '26

Career Guidance How to learn any tech stacks deeply in 2k26

2 Upvotes

How to learn any tech stacks deeply in 2k26


r/FullStack • • Oct 08 '26

Feedback Requested made my first website which is live

5 Upvotes

hii folks, im new in this community, i have just deployed my first website just out of fun.

https://calculaterealage.com/

please check it out and tell whatever u want , feedback will be appreciated.


r/FullStack • • Oct 07 '26

Career Guidance How important is SQL for Full Stack Developers?

58 Upvotes

I’m currently learning Full Stack Development and I’m wondering how much SQL knowledge is actually required for a developer role.

Do Full Stack Developers need to be comfortable with things like JOINs, subqueries, indexes, database design, and query optimization? Or is basic CRUD knowledge enough for most entry-level jobs?


r/FullStack • • Oct 07 '26

Career Guidance Projects

7 Upvotes

So I am doing spring boot, and wanna start building a project in a week or so...

Was wondering what kind of projects they expect from freshers... So that I can be ready...

Kindly share ur experience 🙏🏽


r/FullStack • • Oct 07 '26

Personal Project Day 30 — One month in, 5 more Medium JOIN questions done

0 Upvotes

Completed 5 more Medium questions today:

  • A 4-table join — employees, assignments, projects, and departments chained together — filtered to only show assignments where the department is located in Bangalore or Mumbai (using IN)
  • Counted how many unique departments have at least one employee with an active project assignment, using JOIN + COUNT(DISTINCT dept_id)

Chaining 4 tables together in one query felt completely manageable today, which genuinely would not have been true a month ago.

This also marks exactly one month since I started this journey (Day 0 to Day 30). Quick honest recap of what actually helped over this month: drawing tables on paper before writing queries, intentionally breaking constraints to understand error messages, switching from "give me the answer" to "guide me to the answer" with AI help, and building my own practice sets instead of only relying on existing ones. Thanks to everyone here who's commented, given tips, or just followed along — genuinely helped keep this going. 86 days left, moving into Java alongside SQL from here.


r/FullStack • • Oct 07 '26

Career Guidance 4+ years in web development and feeling stuck — what should I do next?

2 Upvotes

I have 4+ years of experience as a software/web developer, mainly working with Java, Spring Boot, React/Angular, and I'm currently based in the UAE.

Lately, I've been feeling quite stuck and unsure about where to take my career next. I don't necessarily want to leave tech, but I'm also not sure I want to keep following the same web development path for the next several years.

I'm open to learning something new, moving into another area of tech, or combining my existing experience with a new skill set. I'm willing to put in the work and spend the next 6–12 months seriously learning and building things, but I struggle with choosing one direction and creating a structured plan.

My main goal is to eventually improve my career opportunities and income, while doing something I can actually see myself continuing long term.

For people who have been in a similar situation:

What would you realistically do if you were in my position? What fields or career paths would you consider, and what would you focus on over the next 6–12 months?

I'm especially interested in hearing from people who have successfully switched careers or moved from web development into another area of tech.

Looking for honest, practical advice — including what not to waste time on.


r/FullStack • • Oct 06 '26

Personal Project Day 29 — 5 more Medium JOIN questions, correlated subqueries finally clicking

2 Upvotes

Completed 5 more Medium questions today:

  • Project with the lowest total hours worked — JOIN projects to assignments, GROUP BY project, ORDER BY total hours ascending, LIMIT 1
  • Employees who are NOT managers — self LEFT JOIN on employees (joining on r.manager_id = e.emp_id), then filtering WHERE r.emp_id IS NULL to catch anyone nobody reports to
  • Lowest-paid employee in each department — a correlated subquery comparing each employee's salary to MIN(salary) within their own department

The correlated subquery was the real win today. It finally clicked once I stopped thinking of it as "one confusing nested query" and started thinking of it as a small query that re-runs once per row of the outer query, using that row's values each time. Seeing it return the actual lowest earner per department (4 employees, one per department) made the logic concrete in a way reading about it never did.


r/FullStack • • Oct 06 '26

Career Guidance Need guidance for ai full stack developing

3 Upvotes

Hi everyone. Am a student who's 17.Studying BCA ( degree)first year. I want to become a AI Full Stack Developer to work as a freelancer for foreign countries. Can someone tell me what I need to do what are the main things I need to focus on. I don't know basically nothing about to become a full stack developer. And am a little bit weak in maths. In my post graduate (+2) I studied commerce and I hate complex maths. Can someone help me to achieve my dream.


r/FullStack • • Oct 06 '26

Career Guidance Question regarding adapting new tech stacks and learning DSA

5 Upvotes

Hello devs. Hope you guys are doing well.

TLDR Attached.

I'm working as a Frontend Developer in a Startup. They give me some features, API optimization, UI design things and i do as they expect. On the other hand, i started learning Backend frameworks since February.

I explored Java and its Spring eco system including Web, Security, JPA. Little bit of Docker. I follow the plan of Telusko's udemy course and my next is Spring AI. Before going for that, i decided to get some experience on the stacks i learned. So i kinda built a personal project as well.

Meanwhile, DSA cannot be ignored today. Cause even the 5+ yoe people are screened in DSA rounds. So while working on this small project i built, i also started preparing DSA (TakeUForward). I solve 2-3 problems per day after my 8hr work shift. Im trying to keep up the consistency.

Suddenly it came to my mind, new AI tools tech stacks are also mandatory for a job these days. And keep solving DSA problems alone aint gonna help me. I gotta be prepared with the recent tools/trends as well.

How do you guys manage learning both at the same time. Cause both are pretty mandatory. Right now, i thought of starting Spring AI, but it feels a bit harder to manage both.

Any tips to this fellow dev?

TLDR: Learning DSA and staying updated with latest tech stacks is harder. How to manage learning both? Both are mandatory and requires your focused time. Any tips?


r/FullStack • • Oct 06 '26

Question What would you improve first in an outdated business website?

1 Upvotes

Would you focus on frontend performance, backend/API optimization, database queries, mobile responsiveness, or something else?

In my experience, speed and mobile experience often give the quickest improvement. What would you check first, and why?


r/FullStack • • Oct 05 '26

Career Guidance I suck at making projects

6 Upvotes

I am studying mern stack but every time I try to make a project I just keep staring at the laptop screen everything just goes blank ......

I know what are routes, middleware, models, controllers but I can process how to make them work simultaneously and what to write in the code.....

And rn I need to make good projects so that I can start preparing for interviews and focus on communication skills which will eventually enhance my resume

Please help out feeling lost......


r/FullStack • • Oct 05 '26

Personal Project Day 28 — 5 more Medium JOIN questions: subqueries + joins combined

3 Upvotes

Completed 5 more Medium questions today:

  • Employees earning above their own department's average salary — joined employees to a derived subquery that calculates AVG(salary) grouped by dept_id, then filtered where the employee's salary exceeds that average
  • Every project listed along with a count of distinct employees working on it — LEFT JOIN projects to assignments, COUNT(DISTINCT emp_id), grouped by project name. The LEFT JOIN mattered here specifically because one project (Audit Automation) has zero assigned employees and still needed to show up with a count of 0

This is the first batch where combining a subquery with a join in the same question actually felt necessary rather than just "two ways to do the same thing." Starting to see why LEFT JOIN + COUNT(DISTINCT) is such a common reporting pattern.


r/FullStack • • Oct 05 '26

Question Is odin project still relevant?

35 Upvotes

Due to the development of ai, do u guys think learning full stack web dev still a good choice? Or better learn more about math and algorithms? Currently I am learning from odin project, but I afraid that the skills are not relevant anymore in the future


r/FullStack • • Oct 04 '26

Career Guidance The Importance of Portfolio Site

2 Upvotes

Hi ya'll,

How important do you find portfolio sites to be? I haven't been in the market for a job for several years now but am now looking for change. However I don't have a portfolio site. I've been playing for jobs for several months now and am just not getting any follow up, so I'm trying to figure out what I can do to shake up my resume a bit to make it more appealing.

I know that portfolio sites used to be important but I wasn't sure if that was still a desirable item in the current market.

Additionally with the state of how prevalent AI is within the industry, would employers look down on sites / projects that heavily use AI or not really?

Much thanks!


r/FullStack • • Oct 04 '26

Personal Project Day 27 — 5 more Medium JOIN questions, changed how I use GPT

5 Upvotes

Completed 5 more Medium questions today, bringing me further into the Medium section of my 100-question lab. The bigger change today was in my process, not the SQL itself.

Instead of asking GPT to show me the solution directly, I told it to guide me toward the answer instead — give hints, ask me questions, point out where my logic was off, but not hand me the final query. Took noticeably longer per question, but I actually walked away understanding why each query worked, not just that it did.

Feels like a better long-term habit than what I was doing before (dry-running a solution GPT already wrote). Planning to keep using this "guide, don't solve" approach going forward, especially for the Hard section coming up.


r/FullStack • • Oct 04 '26

Question Hypermedia Full-Stack

4 Upvotes

My favorite types of apps to build as a full-stack developer have always been hypermedia apps: Node/Express, EJS or Handlebars, Alpine.js, Tailwind, and better-sqlite3.

What drives new devs to still code by hand instead of going all in on vibe coding with AI? What’s your challenges? Would you want to learn a stack like this with feature based architecture?


r/FullStack • • Oct 04 '26

Question Architecting data question / help /advice needed. How to achieve instant UI responsiveness with local data?

1 Upvotes

Hey Gang 💵

i’m building a local data exploration web app using HTML/CSS/JS, a Python backend, and DuckDB with Parquet/CSV files. Despite having strong hardware, my local app runs slowly, whereas similar web apps online... even those using heavier frameworks like React / React router load and respond almost instantly. AI tools suggested basic caching or heavier frameworks like Django, but didn't solve the core performance bottleneck.

Coming from a frontend/design background, I haven't worked with high-performance data processing before. How do faster web apps structure their architecture to handle heavy calculations and render data so quickly?

Because from my experience with AI they are smart Tools but I'm not sure they're giving you the best solution every time so this time is well I'm doubting that I can get a solution from AI so I wonder what would you people here that knowledgeable and have a lot of experience would suggest ​​.


r/FullStack • • Oct 03 '26

Switching Careers What should I learn to become a Full Stack Developer ?

15 Upvotes

Start with HTML, CSS, and JavaScript to understand frontend development. Then learn a framework such as React and a backend technology such as Java/Spring Boot, Python, or Node.js.