top of page
All Blogs
Search


From Messy JOINs to Clean Architecture: My SQL Views Wake-Up Call
It was 3 PM on a Tuesday when Rashmi, my lead, messaged me: Can you send the top rented movies report again , but only for Store 1? I already knew what that meant. A long SQL query Multiple JOINs across film, inventory, rental, and payment Copy, paste, tweak, run, export Five minutes later, another message : Oh exclude staff test rentals too. That's when it hit me. I wasn't analyzing data anymore. I was rewriting the same logic again and again . There had to be a better
Prajna M
Jan 146 min read
bottom of page