Posts
All posts I have written.
-
Unlocking Indonesian Expertise: A Deep Dive into Malaka Project's 'Kelas Pakar'
Discover 'Kelas Pakar' (Expert Class) by Malaka Project, a brilliant Indonesian YouTube series bringing expert knowledge to the masses. From public speaking with a stand-up comedian to understanding the 'thrifting' boom, this series is a goldmine of insights. This post explores why this content is a must-watch for anyone interested in Indonesian culture, creative industries, and lifelong learning.
-
Kelas Pakar: Generalist vs. Specialist: Who Wins in Today's Job Market?
In this episode of 'Kelas Pakar', Indra De Prestio dissects the age-old debate: is it better to be a deep specialist or a broad generalist? This post breaks down his key arguments, including the concepts of 'degree inflation', the V-shaped professional, and why adaptability might be the most crucial skill of all in a rapidly changing, AI-driven world.
-
The Ultimate Laravel + PostgreSQL Query Optimization Checklist (Part 7)
A practical end-to-end checklist to diagnose and optimize any Laravel query: classify short vs long, apply index and N+1 fixes, streamline long report queries, and escalate with CTEs, views, JSON functions, and partitioning.
-
Solving N+1 for Good in Laravel: The NORM JSON Function Pattern (Performance Part 6)
How to eliminate N+1 queries in complex Laravel endpoints by offloading relationship assembly to a PostgreSQL JSON-building function (NORM pattern) and returning one predictable JSON payload.
-
Architecting Complexity: CTEs, Views, and Partitioning in Laravel (Performance Part 5)
How and when to use PostgreSQL CTEs, database views, and table partitioning in a Laravel app to tame complex queries, encapsulate reusable logic, and keep massive tables fast.
-
My Java Baptism by Fire: Conquering 'Not Equals', Exponents, and Printing Arrays Like a Pro
A hilarious and deeply personal journey through the most common Java beginner pitfalls. This guide uses real-world coding war stories to teach you how to properly handle 'not equals', string-to-int conversions, array printing, exponents, and other fundamental concepts that trip up new developers.
-
Taming Long Queries & Joins: Winning Strategies for Reports (Laravel + PostgreSQL Performance Part 4)
How to optimize report-style 'long queries' in Laravel with PostgreSQL: when Seq Scans are good, how hash joins work, using EXISTS for semi/anti-joins, and structuring GROUP BY to avoid repeated large table scans.
-
How to Exit Vim: The Ultimate Guide for the Trapped, the Terrified, and the Truly Determined
A hilarious and deeply practical guide on how to exit the Vim editor. From the panic-inducing first encounter to mastering life-saving commands like save, quit, undo, redo, and search, this article turns Vim victims into Vim victors. Your escape plan is here.
-
Short Queries, Massive Tables: Indexes That Make Laravel Fly (Laravel + PostgreSQL Performance Part 3)
Why once-fast find() and where() calls slow down at scale, how PostgreSQL chooses Seq Scan vs Index Scan, and the exact indexing habits to keep short queries instant on millions of rows.
-
My Epic Quest Through the Bash Labyrinth: From Multiline Strings to Conquering Chaos
A deep-dive, humor-filled journey into the world of Bash scripting. This guide goes beyond the basics, sharing personal war stories and hard-won lessons on everything from multiline strings and function returns to robust error handling and command-line argument parsing with getopts. It's the field guide to Bash you wish you'd had when you started.