Blog

Thoughts & Stories

Sharing my experiences, learnings, and adventures in tech and beyond.

Browse by Topic

Image Optimization in Next.js: WebP, AVIF, and the Settings I Actually Ship

A practical guide to Next.js image optimization — the formats, the config, and the real-world results from optimizing matthewswong.com.

A decision framework for choosing between ISR, SSR, and SSG in Next.js App Router — with real performance numbers and the configs I ship.

How connection pooling works, why your NestJS app will eventually exhaust PostgreSQL connections, and the PgBouncer config I run in production.

How tsvector and GIN indexes make PostgreSQL a capable search engine for small-to-medium datasets — and when you actually need Elasticsearch.

Why offset pagination falls apart on large datasets and how to implement cursor pagination in a NestJS API that stays fast at any page depth.

How to implement URI-based API versioning in NestJS without breaking existing clients — with the controller patterns and migration strategy I use.

Showing 259–264 of 428 posts

See the projects I've built

My professional career

Professional certifications