You are here: Home / Topics / Search / solid system design
Showing 12 Search Results for : solid system design

What is ATOMIC SQL UPDATES?

Filed under: Solid System Design on 2026-01-03 09:33:29
Excellent.Day 7 is one of the most practical days — this is where we eliminate an entire class of production bugs by changing how we write SQL.Today’s focus:Avoid Read → Modify → Write bugs using ATOMIC SQL UPDATES? DAY 7 — ATOMIC SQL UPDATES1️⃣ The Core Problem (MOST COMMON BUG)❌ Re

TRANSACTION ISOLATION LEVELS in software development

Filed under: Solid System Design on 2026-01-02 14:11:52
Perfect.Day 5 is one of the MOST important days — this is where many “it works in testing but fails in production” bugs come from.I’ll explain Isolation Levels in a way you can feel what the database is doing.TRANSACTION ISOLATION LEVELSIsolation = how much of other transactions your transac

What is Read Shared Data in Software Development?

Filed under: Solid System Design on 2026-01-02 13:10:34
This is a very important foundational question.If you truly understand “read shared data”, race conditions will start making sense everywhere.I’ll explain it from first principles, with plain language + real examples + mental model.1️⃣ What Does “Shared Data” Mean?Shared data is any da

How to create Idempotent in your code?

Filed under: Solid System Design on 2026-01-02 10:24:20
Great — this is the right moment to learn idempotency, because it is one of the pillars of “code that doesn’t break”.I’ll explain it in three layers:Theory (mental model)Database-level design (most important)Spring Boot practical patternsNo shortcuts, no magic — just solid engineering.1

What do you mean by method can be called twice?

Filed under: Solid System Design on 2026-01-02 10:23:21
This is a very important question.Most production bugs exist because developers don’t truly understand this.Let’s break it down slowly, clearly, and with real-world examples.1️⃣ What “Method Can Be Called Twice” REALLY MeansIt does NOT mean:You wrote method() twice in code ❌It DOES mea