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 Aravinth | All thoughts proudly caffeinated ☕

Contact Me | Home

Comments

Post a Comment

Popular posts from this blog

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

PostgreSQL ON CONFLICT Statement

PostgreSQL ON CONFLICT Statement - Explained PostgreSQL ON CONFLICT Statement - Explained 📘 Introduction to ON CONFLICT Statement In PostgreSQL, ON CONFLICT provides a powerful mechanism to deal with data clashes during INSERT operations. When inserting into a table that contains a UNIQUE constraint or index, you can define how the database should react—either by updating the existing record or ignoring the new one. 🧪 Syntax Overview INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...) ON CONFLICT (conflict_target) DO UPDATE SET column1 = value1, column2 = value2, ...; conflict_target: typically the column(s) with a UNIQUE constraint (e.g., employee_id) DO UPDATE: specifies what should be updated DO NOTHING: skips the insertion if conflict occurs ...
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