A Practical Guide to Postgres Full-Text Search
You can ship fast, relevant search on the database you already run. Here's how tsvector, GIN indexes, and ranking fit together in real projects.
Category
Software, hardware, and the people building it.
You can ship fast, relevant search on the database you already run. Here's how tsvector, GIN indexes, and ranking fit together in real projects.
In March 2024, Interaction to Next Paint replaced First Input Delay as a Core Web Vital. Here's what INP measures, the thresholds that matter, and how to fix a slow score.
Largest Contentful Paint should be 2.5 seconds or less. Here's what LCP measures, the four parts a slow score breaks into, and the fixes that actually move it.
The gap between a mediocre AI answer and a great one is usually the prompt, not the model. Here's a practical framework — task, context, examples, format — with a before-and-after you can copy.
A good CLS is 0.1 or less. Here's what causes the page to jump while it loads — images, ads, fonts, injected content — and how to hold everything in place.
Core Web Vitals are three metrics — LCP, INP, and CLS — that measure loading, responsiveness, and visual stability. Here's what each one means, the thresholds, and which to fix first.