Automating Partition Cleanup in Oracle with PL/SQL and DBMS Scheduler

Automating Partition Cleanup in Oracle with PL/SQL and DBMS Scheduler The procedure begins by reading from the configuration table CMN_DROP_PARTITION, which defines which partitioned tables need cleanup, how many partitions should be retained, and which partitions must be excluded. For each active table entry, it retrieves the table owner, table name, and retention count. Next,…

Read More

Blockchain as a Database: Hype or a Real Alternative?

Imagine a world where instead of trusting a centralized database, every record you access is validated, immutable, and visible to all. Sounds futuristic? That’s what blockchain promises—but is it really a practical alternative to traditional databases like MySQL, PostgreSQL, or MongoDB? Let’s break it down. Why People Consider Blockchain as a Database Immutability: Once data…

Read More

Understand React Hooks the Right Way: From Basics to Bug Prevention & Design Decisions

0. Introduction React Hooks are a way to manage state and lifecycle without classes (since 16.8). Simpler than class syntax Easier to reuse logic (custom hooks) Easier to test 👉 Goals of this article: Beginners: Use useState / useEffect correctly Intermediate: Understand render/commit, stale closures, and re-renders caused by function props to make sound design…

Read More

Contributing a Code Change to an Open Source Project

This week, I had the opportunity to contribute to another student’s project on GitHub. It was my first time making a meaningful code change in someone else’s repository, and the process gave me valuable insight into collaboration, version control, and technical problem-solving. Finding the Project and Setting Up I selected Repo-Contextor as the project I…

Read More

Welcome to the World of Embedded Systems with Python

When most people think about embedded systems — the tiny computers inside cars, appliances, medical devices, and sensors — they think of C or C++. And that makes sense: these languages have long been the backbone of resource-constrained, real-time applications. But in recent years, Python has quietly been gaining popularity in the embedded space. It’s…

Read More

Lost Recovery Keys with Auto Unseal – Vault

เป็นหนึ่งจากหลายๆ เคสที่ถูก Raise มาถึงเราในสัปดาห์นี้ และน่าจะเป็นเคสที่สนุกสุดด้วยเพราะผู้เขียนยอมอดกินเนื้อย่างคืนวันศุกร์เพื่อมาแก้เคสนี้ ด้วยตัว HashiCorp Vault ทางทฤษฏี เคสนี้ควรจะถูกแก้ได้ แต่พอไปดูเครื่องมืออาจจะยังไม่ครอบคลุม (หรือจะมองอีกมุม ว่าเพื่อความปลอดภัยและความชัดเจนในมุมการใช้งานของ Product เองก็ได้ครับ) ในที่นี้ wrapped key ที่ต้องการมีพร้อม ขาดแค่เครื่องมือ ซึ่งเราสร้างเพิ่มขึ้นมา Introduction Vault provides centralized, well-audited privileged access and secret management for mission-critical data whether you deploy systems on-premises, in the cloud, or in a hybrid environment.With a modular design based around a growing plugin…

Read More