Introduction Continue reading on Medium »

You have probably written this query before — or at least something that looks just like it: Continue reading on Medium »

It wasn’t a big deployment. No major release. No infrastructure change. Just a simple SQL query. And within minutes, production started behaving… strangely. A support ticket came in. A customer repo...

In RAG, people throw more compute at it and call it robust. Continue reading on Medium »

The UAE real estate market gets covered endlessly in terms of property prices and transaction volumes. What gets less attention is the agent layer sitting underneath all of it. Who are these people? H...

Introduction Entering the IT industry is a goal for many students and job seekers, but the path often feels unclear. With so many technologies available, choosing the right skill set becomes difficult...

« Hold on, we need to talk, this doesn't add up » Friday morning, 9:15 AM. Françoise is in her cockpit — three screens: on the left the Excel attendance sheet she's kept up to date for fifteen years...

So you've outgrown MySQL. Maybe you need better JSON support, real window functions, or you're moving to a managed cloud database that defaults to Postgres. Whatever the reason — MySQL to PostgreSQL m...

Skip the theory rabbit holes. This is the caching knowledge that shows up in system design interviews, code reviews, and the 2 AM production incidents nobody warned you about. Why Caching — The 30-Sec...

Inside the five-stage pipeline from 1.1.1, there is another fork right after the parser. PostgreSQL classifies every SQL command into one of two camps. One side holds the optimizable queries, the othe...