Hi, I'm Mukul 👋
Software developer writing about technology, programming, book reviews, and tools I build. Welcome to my corner of the internet.
Latest Posts
-
Query Optimization in SQL: EXPLAIN, Indexes, and Join Strategies
Learn how to read EXPLAIN ANALYZE output, choose the right indexes, and pick join strategies to diagnose and fix slow SQL queries in PostgreSQL.
-
Understanding Rust Ownership (Without Writing a Compiler)
A practical guide to Rust's ownership model — covering ownership rules, borrowing, lifetimes, and why the borrow checker exists, with concrete examples throughout.
-
Regular Expressions Cheat Sheet with Real-World Examples
A comprehensive regular expressions cheat sheet with real-world examples in Python, JavaScript, grep, and sed — covering anchors, groups, lookaheads, and common patterns.
-
Redis — Caching, Pub/Sub, and TTL: A Practical Guide
Learn how to use Redis for caching, publish/subscribe messaging, and TTL-based expiry with practical code examples in Python and CLI.
-
Python logging Module: A Practical Guide for Real Applications
A practical guide to Python's logging module — covering log levels, handlers, formatters, structured logging, and patterns for production applications.
-
Python Decorators: What They Are and When to Use Them
A practical guide to Python decorators — how they work, how to write your own, and when they genuinely simplify code versus when they add unnecessary magic.
-
Python Dataclasses vs Pydantic: When to Use Which
A practical comparison of Python dataclasses and Pydantic models — covering validation, serialization, performance, and when each tool is the right choice.
-
PostgreSQL vs MySQL: Key Differences Every Developer Should Know
A practical comparison of PostgreSQL and MySQL — covering data types, JSON support, transactions, full-text search, and which database is the right choice for your project.
-
ORM vs Raw SQL: Trade-offs and When to Switch
Compare ORMs like SQLAlchemy and Prisma against raw SQL, understand the performance and maintainability trade-offs, and know when to drop down to raw queries.
-
Go Goroutines and Channels: Concurrency Made Simple
Learn how Go goroutines and channels work together to make concurrent programming practical, safe, and surprisingly readable.