My Customer List Page Was Making 500+ Queries Just to Show “Last Order Date”
My Customer List Page Was Making 500+ Queries Just to Show “Last Order Date” I built a customer list page for a small CRM project, showing each…
-
-
I Was Calculating the Same Order Total in Five Different Places, Then I Found Generated Columns
I Was Calculating the Same Order Total in Five Different Places, Then I Found Generated Columns An order management system I built stored quantity and unit_price separately…
-
A Security Audit Found SQL Injection in My Code, and I Genuinely Didn’t See It Coming
A Security Audit Found SQL Injection in My Code, and I Genuinely Didn’t See It Coming A client hired an external security firm to audit their platform…
-
Stock Was Updating Inconsistently Because I Copy-Pasted the Same Logic in Three Places
Stock Was Updating Inconsistently Because I Copy-Pasted the Same Logic in Three Places I was building an e-commerce platform for a small clothing brand, and stock deduction…
-
The Client Had a 10-Year-Old Inventory System I Wasn’t Allowed to Touch, So I Had to Connect Around It
The Client Had a 10-Year-Old Inventory System I Wasn’t Allowed to Touch, So I Had to Connect Around It A wholesale distributor client wanted a modern reporting…
-
A Customer’s Money Left Their Wallet, But the Order Never Got Created
A Customer’s Money Left Their Wallet, But the Order Never Got Created I built a simple digital wallet feature for a local tutoring platform, students could top…
-
An Admin Accidentally Deleted a Customer’s Entire Order History, and I Had No Way to Get It Back
An Admin Accidentally Deleted a Customer’s Entire Order History, and I Had No Way to Get It Back I got a panicked WhatsApp message from a client…
-
A Simple Search Bar Nearly Took Down a Client’s Job Board Site
A Simple Search Bar Nearly Took Down a Client’s Job Board Site I built a job board for a small recruitment startup, listings, filters by category and…
-
My Database Had “John SMITH”, “Sara Ahmed”, and “Muhammad Ali” Until I Fixed This One Thing
My Database Had “john SMITH”, “Sara ahmed”, and “MUHAMMAD Ali” Until I Fixed This One Thing I was building a small CRM for a local real estate…