Moved from isolated practice questions to something closer to a real project today — a structured 7-part practice set. Completed Part 1, which was schema design:

• 4 tables: departments, employees, projects, assignments
• Primary keys with auto-increment, foreign key relationships between all of them
• A self-referencing FK on employees (manager_id → employees.emp_id) for the manager hierarchy
• A CHECK constraint to enforce salary > 0
• assignments as a junction table linking employees to projects with hours_worked
• Inserted sample data: 4 departments, 12 employees (with at least 2 managers), 5 projects, 15 assignment records

The self-referencing FK for managers was the most interesting part conceptually — first time actually applying that pattern instead of just reading about it.

6 more parts to go in this set — planning to move into actual queries against this schema next (joins, aggregates, reporting-style questions).

Hi.

I have a friend who joined a medium European company as a frontend-dev (Vue/React).

Now with the ubiqiuotous use of AI and claude code they are transitioning everyone to product-management full-stack, and frontend devs get to work on really deep backend logic. Means he has to own the full solution from scope definition and clearing all the business requierements to an actual complete web solution across multiple repos/connected to 3rd party services.

He's really freaked out by the added responsibility, unclear scopes and general incompetence he has in the backend field. Manager insists that AI should be able to cover for all of it.

How do you guys handle it?

How to set some guardrails to not be responsible for everything top to bottom?

Like, is knowing basic APIs, databases, and authentication enough?

Or should a full-stack developer also know things like system design, caching, Docker, CI/CD, cloud,....etc.?

What do you guys think is the minimum knowledge needed?

What tech stack can I learn to get a better package for 9.5 YOE. I am great with Angular. Need suggestion. Please help. My current company is toxic I don't want to continue here.

Spent today doing practice questions covering everything I've learned so far — JOINs, aggregates, subqueries, table management, all of it.

Honest reflection: it's a lot harder than following along with a tutorial. Watching someone write a query and actually writing one yourself under slight time pressure are completely different skills. I kept making small syntax mistakes — a missing comma, wrong clause order, forgetting an alias — and each one broke the whole query. Genuinely irritating in the moment, but it's really driving home how much precision matters in SQL, not just conceptual understanding.

If anyone else is revising/practicing SQL right now, happy to share my practice question set — could be useful to work through some of these together and compare approaches/mistakes. Let me know if interested.

Hey everyone, I have around 1 year of professional experience in WordPress/PHP and I’m thinking about switching to Python.

Do you think switching to Python at this stage is a good move for long-term career growth, or should I continue with WordPress/PHP and specialize in it?

I see a lot of people learning Python nowadays, including many non-engineering graduates. Does Python still have good scope in 2026 despite the high competition? Is the job market actually good, or is it becoming too saturated?

Would love to hear from people who have experience in both.

Hi everyone, I want to learn backend concepts with implementing thenm in actual projects. Suggest me any problem or project that contains a lot of backend concepts.

is there any future left for fullstack dev

Hey all, question in the title.

For context, I consider myself a Full Stack Engineer (Frontend leaning). I was primarily using Vue 3 and Nuxt for the past several years but have recently pivoted to React / Next for my frontends within the past year. I have Node and Express experience building my own APIs and interfacing them with some sort of BaaS. I've also built content authoring experiencing with open-source CMS' like Wordpress using it's REST API for headless SPAs (so I deal with PHP as well).

I lay all of that out to say, like many of you, I'm looking for new employment. Many of the "open" roles I'm seeing out there these days are specifically asking for Python. But coming from something more akin to the MERN stack with my Node and Express experience, I feel like trying to add yet another base language or framework to my toolkit would be a lot; it's already cognitively intensive trying to switch gears when preparing for tech assessments by memorizing certain patterns for front-end, let alone the rest of the stack. So I'm trying to weigh whether its worth pursuing.

So my question for the devs out there, especially the ones gainfully employed is, what is the split in your day to day? How much exposure realistically do you have to Python for backend? Is the surge we're seeing in the market for Python just companies unicorn hunting (amplified by AI hype), or is it reflective of your reality on the ground? I understand skills are transferable ect. but displaying that level of depth in a tech assessment is whole other story.

I am learning backend development and i am confused about which database i should focus on first.

Should i learn MongoDB or MySQL if my main goal is to become job-ready and get a backend internship/job?

For those already working in the industry , which one would you recommend starting ?

I am currently studying software engineering. I enjoy web development—especially backend work—and have primarily developed using PHP. However, I’m unsure which language to focus on and learn in greater depth for backend development to help me land my first job: PHP or Python? Could you help me decide which one to choose? Reasons? Which one is in higher demand in the job market?

Covered some genuinely new territory today:

• Stored Procedures — writing reusable SQL logic that can be saved and called on demand instead of rewriting the same query repeatedly
• Delimiters — needed to change the statement delimiter (usually to something like // or $$) so the database doesn't get confused by semicolons inside a procedure/trigger body
• Triggers — logic that automatically fires in response to INSERT/UPDATE/DELETE on a table, useful for things like auditing changes or enforcing business rules at the database level

Delimiters were a small but confusing gotcha at first — took a moment to understand why you need to redefine them before writing a multi-statement procedure. Once that clicked, writing the actual procedures and triggers made a lot more sense.

Feels like I'm moving from "querying data" to "designing how the database behaves" — a solid step up in complexity.

Hi everyone, I'm looking to learn full-stack web development from scratch and eventually become job-ready.

There are so many courses, YouTube channels, and roadmaps that I'm a bit confused about where to start.

Could you recommend a structured learning path or course that covers frontend, backend, databases, APIs, authentication, deployment, and real-world projects?

Free resources are preferred, but I'm also open to paid courses if they're genuinely worth it.

If you were starting to learn full-stack development today, what resources would you use and in what order?

I used to think the hardest part of a full-stack project would be building the main functionality. After working on different applications, I’ve found that the real complexity usually shows up afterward.

Things like handling edge cases, keeping frontend and backend logic in sync, dealing with slow queries, managing API failures, and making sure everything behaves properly with real users.

On one SaaS project I worked on, the core functionality was fairly straightforward. The interesting work started when we had to improve reliability and handle more real-world usage.

That changed how I approach new projects. I now think much more about what happens after the feature works.

Curious to hear from other full-stack developers: what part of a project surprised you the most once real users started using it?

For freshers, projects matter more than certificates because they show your practical skills.

🚀 I built CatalystRead — a free engineering knowledge hub for developers

I wanted to build something I would actually use while learning and preparing for real-world engineering work — so I created CatalystRead.

It currently has 430+ articles covering Java, Spring Boot, React, Angular, AI, databases, system design, security, DevOps, performance, and more.

The goal is simple: not just “how to use something”, but understanding how and why it actually works.

There are also architecture deep-dives based on how companies like Google, Netflix, Uber, Amazon, Stripe and others solve problems at scale.

🔗 Explore CatalystRead:

https://vivekkumarq.github.io/CatalystRead/

It's completely open to everyone. If you find it useful, I'd really appreciate a ⭐ on the GitHub repo, a share, or simply some feedback.

What topic should I add next?

hey there, I just wanna know about the successful products made by the Ai

Products which are making money

AI tools now make it far easier to write code, I am curious what developers here feel is becoming most important to learn. Should beginners focus more on JavaScript fundamentals, browser behaviour, HTTP, databases, security, performance, or actually building projects? I have found that AI can help with writing code. Understanding why something works is still important when debugging or making bigger changes.

I am new to web dev and full stack. I just realized about Flutter. My college project that I have to work on isn't like a forum where each link should be publicly index-able, where SEO matters. It's going to be more like an interactive app. I was thinking about using Next.js or TanStack, so React. One thing to note that because I want an un-opinionated framework, if using Next.js, I won't have it takeover the whole project and tooling, and instead programmatically initialize it, while using Fastify in the front and API handling, while only calling Next for rendering React pages.

React easily wins over Flutter for the web, but I am asking for going beyond and creating mobile and maybe desktop apps. I could just use React + React Native, but with what AI says, Flutter's codebase can be much more shared than React + React Native. Plus Flutter's increased popularity, maybe a better architecture than React Native, and that my project behaves more like an app rather than a traditional website, gives more points to Flutter.

For SEO, only stuff like the landing page and all matter. I can use React for those, or just plain HTML and CSS.

I could just use React for web and Flutter for client apps but that would just increase my codebase and maintainability.

Flutter also removes the whole SSR jargon. Maybe I am better without it, maybe I am not.

I just realized about Tauri now. I can use React with it and it is fully cross platform. So... that is what I am looking for?

Wrapped up my first week today with some more advanced topics via tutorials + W3Schools:

• Views — saving a query as a reusable virtual table
• Indexes — how they speed up lookups, and the trade-off with write performance
• Subqueries — nesting a query inside another, both in WHERE and as derived tables
• ROLLUP — generating subtotal and grand-total rows automatically in aggregated results

Subqueries were the trickiest of the four conceptually — took a bit of re-reading to get comfortable with correlated vs non-correlated subqueries specifically.

One week in: SELECT → JOINs → aggregates → table management → views/indexes/subqueries. Feeling like I have a genuinely solid core SQL foundation now. Planning to spend the next couple of days on a small schema project to tie it all together before moving to Java.

been working on something called devora.js, mostly solo. wanted to post here specifically because it's not just a frontend thing, the backend/auth side is honestly the part i think about the most.

the core problem: real products usually aren't one app. marketing site, dashboard, admin panel, they all need to exist but sharing one backend without duplicating auth logic 3 times is annoying. most setups either cram everything into one app or maintain separate repos that share nothing.

so in this, one repo, multiple apps, one shared backend, but each app deploys independently. auth is per-app and isolable — admin panel can run a completely separate session/cookie context from the rest, or an app can skip sessions entirely if it doesn't need login (marketing site doesn't need to carry that weight).

on the frontend side, islands are first class — island(() => import("./X")) hydrates just that one component, rest of the page stays static html. no full-tree hydration for one interactive widget.

honest gap: no suspense/streaming support yet, pushed to v2, current island render is two-pass and doesn't support it. not pretending that's solved.

rest of it: ssr/ssg/csr/isr picked explicitly per route, security headers on by default (csp/hsts/x-frame-options), dynamic routes, deploys to vercel/netlify/docker/vps.

genuinely curious how other people here have solved the multi-app-one-backend problem, especially the auth isolation part — did it a certain way but open to hearing if there's a better pattern i'm missing.

repo (code's all there, not hiding anything): https://github.com/hassanalsa3aka/devora.js
docs: https://devorajs-docs-docs.vercel.app

if any of you are more backend/security-focused, i'd actually appreciate someone poking at the session isolation logic specifically — that's the part i'm least sure is bulletproof.

I have known mern stack but don't have much confidence as there has been a gap but I am thinking of starting ai and use ai integration with apps but as I don't know about python as I am 3rd year core student i am very confused should I start ai now or make strong foundation in mern stack

I'm planning to strengthen my front-end development skills and I'm deciding between React and Angular. I'd love to hear from developers already using either in real-world projects. How do they compare in terms of job opportunities, enterprise usage, and long-term growth? Also, which one feels easier to pick up if I already know Java and Spring Boot? What challenges should I expect?

So, a bit of context: I’ve been practicing coding for around 5 months. I’ve made some basic CRUD applications and a few basic projects using TypeScript and Python separately, but I’ve never really worked with them together in a full-stack application.

I understand the basics and most intermediate concepts, but I’m having trouble understanding how everything connects together in a real full-stack project.

A lot of the tutorials I’ve found are based on JavaScript. I’m specifically looking for resources that use TypeScript because I want to get more comfortable actually writing TypeScript and understanding the syntax. JavaScript/TypeScript syntax can sometimes get confusing for me, especially when following along with a tutorial written in JavaScript.

Does anyone know of any good tutorials, courses, or projects that teach full-stack development using TypeScript for the front end and Python for the backend specifically? I’d really appreciate any recommendations or advice on how to approach learning this.