• 7 min read ⏱️
Drizzle Magic with Next.js
🔍 DB Setup for Next.js application in 3 Minutes(feat. Drizzle and libSQL)
Alex Posts ✨
by 
Insights and thoughts on technology and development, with a focus on React, its ecosystem, PostgreSQL, and all things JavaScript.
• 8 min read ⏱️
Activity Component
🧩 React’s New <Activity> Component: Hide and Restore UI Effortlessly
• 5 min read ⏱️
Mounting vs Rendering
🏗️ Understanding React Component Lifecycle: Mounting vs Rendering
• 10 min read ⏱️
Node.js Non-Blocking nature
🔍 Why Node.js "Blocking" Operations Don't Actually Block Node
• 7 min read ⏱️
Shared Buffer Access Rules & Replacement Strategy in PostgreSQL
🌕 Exploring PostgreSQL's buffer management internals
• 15 min read ⏱️
Window Functions
🪟 Deep dive into Window and Aggregate Functions in PostgreSQL and their usage in real-world scenarios
• 12 min read ⏱️
Understanding Postgres WAL & Shared Buffers
🔍 Deep dive into WAL (Write Ahead Log) & Shared Buffers in PostgreSQL
• 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.
• 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
• 9 min read ⏱️
How Your Rows are Found in PostgreSQL
💡 What Happens When You Type "SELECT..."? (Feat. PostgreSQL's Blazing Fast Cache!)
• 15 min read ⏱️
PostgreSQL Isolation Levels: A Deep Dive
🔍 Understanding PostgreSQL Isolation Levels
• 6 min read ⏱️
From JSX to DOM
🚀 The Journey of Your React Code
• 20 min read ⏱️
MVCC & Locking
👻 Deep dive into MVCC and locking in PostgreSQL