Alex Posts

Insights and thoughts on technology and development, with a focus on React, its ecosystem, PostgreSQL, and all things JavaScript and TypeScript.

Dec 14, 2025 5 min read

Why HAVING is not a replacement for WHERE

🔍 The critical difference between HAVING and WHERE in SQL

Read article

Nov 28, 2025 6 min read

Next.js 16: The End of Static vs Dynamic(feat. PPR)

🥳 Instead of choosing between static or dynamic pages, you now get both on the same page

Read article

Nov 3, 2025 5 min read

Why You're Falling Behind If You're Not Using AI

🤖 AI as a Partner, Not a Replacement

Read article

Oct 9, 2025 7 min read

Drizzle Magic with Next.js

🔍 DB Setup for Next.js application in 3 Minutes(feat. Drizzle and libSQL)

Read article

Oct 6, 2025 8 min read

Activity Component

🧩 React’s New <Activity> Component: Hide and Restore UI Effortlessly

Read article

Oct 3, 2025 5 min read

Mounting vs Rendering

🏗️ Understanding React Component Lifecycle: Mounting vs Rendering

Read article

Sep 4, 2025 10 min read

Node.js Non-Blocking nature

🔍 Why Node.js "Blocking" Operations Don't Actually Block Node

Read article

Aug 29, 2025 7 min read

Shared Buffer Access Rules & Replacement Strategy in PostgreSQL

🌕 Exploring PostgreSQL's buffer management internals

Read article

Aug 24, 2025 15 min read

Window Functions

🪟 Deep dive into Window and Aggregate Functions in PostgreSQL and their usage in real-world scenarios

Read article

Aug 18, 2025 12 min read

Understanding Postgres WAL & Shared Buffers

🔍 Deep dive into WAL (Write Ahead Log) & Shared Buffers in PostgreSQL

Read article

Aug 10, 2025 6 min read

Tree Shaking & Dead Code

🪶 How modern bundlers remove unused code: deep dive into tree shaking, dead code detection, ESM vs CommonJS, and the `sideEffects` flag.

Read article

Aug 4, 2025 10 min read

Index, B+Tree, index scan flow in PostgreSQL

🔍 Deep dive into indexes, B+Tree, and index scan step by step in PostgreSQL

Read article

Jul 31, 2025 9 min read

How Your Rows are Found in PostgreSQL

💡 What Happens When You Type "SELECT..."? (Feat. PostgreSQL's Blazing Fast Cache!)

Read article

Jul 25, 2025 15 min read

PostgreSQL Isolation Levels: A Deep Dive

🔍 Understanding PostgreSQL Isolation Levels

Read article

Jul 21, 2025 6 min read

From JSX to DOM

🚀 The Journey of Your React Code

Read article

Jul 18, 2025 20 min read

MVCC & Locking

👻 Deep dive into MVCC and locking in PostgreSQL

Read article