Common Table Expression (CTE) in MySQL 8
Break down complex queries into easier-to-read steps with WITH.
A JOURNAL ABOUT TECHNOLOGY
Learn something new.
Write. Share.
A space to connect knowledge, one line of code a day.
Discover tutorials, ideas, and notes from a learning journey.
EDITOR’S PICK ↗
PentestingPlanning Your First Web Application Pentest: Scope, Safety, and Evidence
Build a focused web pentest plan with clear authorization, realistic objectives, controlled testing, and evidence that developers can use.
FOR YOUR CURIOSITY
Latest notes.
Composite Indexes in MySQL: Column Order Matters
Understand how column order in a composite index affects the queries it can help.
MySQL Replication: Separating Read and Write Workloads
Learn the primary-replica model and its implications for read consistency.
Introducing Tibero: An Oracle-Compatible Database from Korea
Explore Tibero as an enterprise relational database with a focus on Oracle compatibility.
Migrating Oracle Queries to Tibero: What to Check
A practical checklist before moving schemas and queries from Oracle to Tibero.
T-SQL Stored Procedures in SQL Server for Beginners
Learn the basic structure of T-SQL stored procedures with input and output parameters.
Knowledge grows when shared.
Stay curious. There is always something new to learn.
ABOUT THE AUTHOR
Dr (C). Ir. Putu Adi Guna Permana, S.Kom., M.Kom., IPM., ASEAN Eng.
Writer and founder of Diary Coding — sharing notes, tutorials, and experiences about programming for anyone who wants to keep learning.