Tech Diaries

🔧 Tech Diaries — Database Tips & Engineering Insights

Explore lessons learned from real-world projects, scripts, and cloud-native architecture for data engineering.

📌 Featured Post

Avoiding Deadlocks in MySQL: A Practical Guide for Real-Time Systems

🧠 Other Posts

📹 Featured Video

© 2025 Ravin | All thoughts proudly caffeinated ☕

Contact Me | Home

Comments

Post a Comment

Popular Posts

Night Park Putrajaya - Secret Garden

Image
Putrajaya Secret Garden – A Magical Night Park Experience Looking for a place to hang out at night? Whether it's an after-dinner stroll, a cozy date night, or weekend outing with the family, the Putrajaya Secret Garden offers a magical experience. Free to enter and lit with dreamlike lights, it transforms nighttime wanderings into peaceful escapes. This Putrajaya Night Park (Secret Garden) is perfect for couples, families, and photography lovers alike. Avatar-style “Tree of Souls” lighting sets a magical tone here. The garden glows with color: lights drape over trees, pillars shimmer, bushes pulse in soft hues. As the skies darken around 7pm, the pathways light up like something out of a fairytale. It’s peaceful, never too crowded, and the perfect blend of relaxation and visual delight. 📍 Location & Access ...
Read more

Spicy Prawn Masala | Prawn Masala Curry Recipe | Shrimp Masala

Spicy Prawn Masala Recipe 🌶️ Introduction: A Fiery Seafood Favourite Craving something bold and brimming with spice? This Spicy Prawn Masala is a soul-satisfying dish that brings the heat and heart of South Indian kitchens right to your table. Inspired by weekend market hauls and cherished family memories, it’s the kind of recipe that turns ordinary prawns into a culinary celebration. Whether paired with fluffy basmati rice or soft naan, this dish is bound to impress seafood lovers and spice enthusiasts alike. 🧄 Ingredients 500g fresh prawns, cleaned and deveined 2 medium onions, finely chopped 2 tomatoes, pureed 1 tbsp ginger-garlic paste 2 green chillies, slit 1 tsp turmeric powder 1½ tsp red chilli powder 1 tsp coriander powder ½ tsp garam masala Salt to taste Fresh coriander leaves for garnish 2 tbsp oil 🍳 Preparation Heat oil in a pan and sauté the onion...
Read more

Mysql Merge

Image
MySQL MERGE Concept & Alternatives Explained MySQL MERGE Concept & Alternatives MySQL MERGE is not directly supported as a single SQL command like in some other database systems (e.g. SQL Server or Oracle), but the concept can be implemented using a combination of INSERT , UPDATE , and DELETE statements. The MERGE approach is helpful for syncing two tables where data may need to be inserted, updated, or removed depending on conditions. When implemented manually, this requires crafting multiple SQL queries to simulate the behavior. Users should have SELECT, INSERT, DELETE , and UPDATE privileges on both tables used in the MERGE operation. 🔧 Three Logical Cases in a MERGE Operation Case 1 – INSERT If a row exists in the source table but not in the target table, use INSERT to add it to the target. Case 2 – DELETE If a row exists in the tar...
Read more