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

BigQuery MERGE Statement – Explained

Image
BigQuery MERGE Statement – Explained with Syntax & Use Cases BigQuery MERGE Statement – Explained 📘 What is BigQuery MERGE? The MERGE statement in BigQuery allows you to conditionally INSERT , UPDATE , or DELETE rows in a target table based on matching rows from a source table. It’s ideal for data synchronization, staging table merges, and incremental updates. 🖼️ Thumbnail Preview 🧪 Syntax Overview MERGE target_table AS T USING source_table AS S ON T.id = S.id WHEN MATCHED THEN UPDATE SET T.name = S.name WHEN NOT MATCHED THEN INSERT (id, name) VALUES (S.id, S.name); 🎯 Example Use Case MERGE dataset.inventory AS I USING dataset.new_arrivals AS N ON I.product_id = N.product_id WHEN MATCHED THEN UPDATE SET I.quantity = I.quantity + N...
Read more

LRT Masjid Jamek-Bandaraya

Image
LRT Ampang Line Closure – Masjid Jamek to Bandaraya Suspension Update LRT Ampang Line Update – Service Suspension Extended The section of the LRT Ampang Line between Masjid Jamek and Bandaraya stations will remain closed for an additional two weeks following the discovery of significant structural damage on an overhead viaduct near Bandaraya. Transport Minister Anthony Loke stated that the line will reopen only after corrective measures and safety assessments are fully completed. “Once it is okay and safety is ensured, we will reopen the line. I apologise to all commuters who are affected,” he added. Public transport operator Rapid Rail has engaged a professional engineering firm to conduct a detailed investigation of the cracked viaduct and pier. This probe will help determine the source of damage and inform the restoration strategy. 🚍 S...
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