Intermediate guides.
For people who already ship. Claude Code workflows, deploys without downtime, Postgres in production, and the operational details that start to matter.
186 posts · page 1 of 8
UUIDv7 Explained: Time-Ordered IDs and Why Postgres 18 Added uuidv7()
UUIDv7 is a UUID that starts with a millisecond timestamp, so new IDs sort in creation order. Why that makes database indexes faster than random UUIDv4, the format in detail, generating them in Postgres 18, Node.js and Python, what the timestamp leaks, and when to still use v4 or bigint.
TypeScript satisfies Explained: Check a Type Without Losing Precision
The satisfies operator checks that a value matches a type while keeping the value's own, more specific type. How it differs from a type annotation and from as, the patterns where it shines (config objects, route maps, as const), and the mistakes to avoid.
TypeScript Enums vs Union Types: Which Should You Use?
TypeScript enums generate runtime code and have surprising behaviour; string literal unions and as const objects give the same safety with plain JavaScript. How each works, why erasableSyntaxOnly and Node's built-in type stripping reject enums, and a practical rule for choosing.
Upgrading to Tailwind CSS v4: What Changed and How to Migrate
Tailwind CSS v4 moved configuration into CSS, replaced the @tailwind directives with one import, detects your files automatically and renamed several utilities. How to run the official upgrade tool, the breaking changes that actually bite (shadows, rings, borders, opacity utilities), browser requirements, and what to check after.
systemd Timers vs cron: Scheduling Jobs on a Linux Server
cron is simple and everywhere; systemd timers give you logging, missed-run catch-up, randomized delays, resource limits and dependencies. A side-by-side comparison, a complete timer and service example with OnCalendar, how to test calendar expressions, list and debug timers, and which to choose.
SQLite WAL Mode: Faster Writes and Readers That Don't Block
Write-ahead logging (WAL) mode is the single most important setting for using SQLite in a web app: readers no longer block the writer, writes get faster, and "database is locked" errors mostly disappear. How to turn it on, the companion pragmas, checkpoints, the -wal and -shm files, safe backups, and its limits.
How to Self-Host n8n: Docker, Postgres, HTTPS and Backups
A production-minded guide to self-hosting n8n: Docker Compose with Postgres instead of SQLite, the environment variables that matter (encryption key, webhook URL, timezone), HTTPS behind a reverse proxy, backups of both the database and the encryption key, updates, and when queue mode is worth it.
React useActionState and useOptimistic: Forms Without the Boilerplate
React 19's Actions replace hand-rolled loading and error state for forms. How useActionState returns state, a form action and isPending; how useOptimistic shows a change instantly and rolls back on failure; useFormStatus for submit buttons; and how they fit with Next.js server actions.
Postgres LISTEN/NOTIFY: Real-Time Events Without Another Service
LISTEN and NOTIFY let Postgres send messages to connected clients when something happens — new orders, cache invalidation, live dashboards — without Redis or a message broker. How it works, a Node.js example with triggers, the 8000-byte payload limit, why notifications aren't durable, and the PgBouncer gotcha.
Postgres Generated Columns: Stored vs Virtual (New in PostgreSQL 18)
Generated columns compute their value from other columns automatically — a full name, a total, a search vector, a lower-cased email. How GENERATED ALWAYS AS works, the difference between STORED and the VIRTUAL columns added in PostgreSQL 18, indexing, the rules on expressions, and when to use a view or trigger instead.
pnpm Workspaces: Set Up a JavaScript Monorepo Step by Step
How to set up a monorepo with pnpm workspaces: pnpm-workspace.yaml, linking internal packages with workspace:*, running scripts across packages with --filter and -r, sharing dependency versions with catalogs, approving build scripts in pnpm 10, and deploying a single app from the repo.
Nginx Rate Limiting: limit_req, Bursts and Protecting Your Login Page
How to rate-limit requests in Nginx with limit_req_zone and limit_req: choosing a key and rate, what burst and nodelay really do, returning 429 instead of 503, separate limits for login and API routes, getting the real client IP behind Cloudflare, connection limits, and testing it.
Nginx location Blocks and try_files Explained (With SPA and API Examples)
How Nginx chooses a location block — exact, prefix, regex and ^~ matches — and how try_files serves a file, a directory or a fallback. Working configs for single-page apps (fixing 404 on refresh), a frontend plus /api backend, static asset caching, and the trailing-slash proxy_pass trap.
Next.js Cache Components and 'use cache': The New Caching Model Explained
Cache Components replace the App Router's implicit caching with explicit 'use cache' annotations on components and functions. How to enable it, how cacheLife and cache tags work, why dynamic data must sit inside Suspense, ensureStatic in Next.js 16.4, and how to migrate an existing app.
MCP Transports: stdio vs Streamable HTTP (and What the 2026 Spec Changed)
MCP servers talk to clients over stdio (a local subprocess) or Streamable HTTP (a remote endpoint). How each works, when to choose which, how to add both to Claude Code, why the old HTTP+SSE transport is deprecated, and what the stateless 2026-07-28 specification means for building and hosting HTTP servers.
Hybrid Search in Postgres: Full-Text + pgvector With Reciprocal Rank Fusion
Keyword search finds exact terms; vector search finds meaning. Hybrid search combines both for better results in RAG and site search. How to build it in plain Postgres with a tsvector column, a pgvector embedding column, and reciprocal rank fusion — with the full SQL, indexes, and tuning tips.
Scheduled GitHub Actions: Run Workflows on a Cron Schedule
How to run a GitHub Actions workflow on a schedule with on.schedule and cron syntax: examples, the new timezone option, why scheduled runs start late or get skipped, the 60-day inactivity rule, running on demand with workflow_dispatch, and what to use instead when timing really matters.
GitHub Actions Caching: Faster CI With setup-node, actions/cache and cache-mode
How to make GitHub Actions workflows faster with caching: the built-in cache option in setup-node and setup-python, actions/cache for anything else, good cache keys, Docker layer caching, the new cache-mode setting that limits cache access to prevent cache poisoning, and why caches miss.
Drizzle vs Prisma: Which TypeScript ORM Should You Use in 2026?
Drizzle and Prisma are the two leading TypeScript ORMs. Drizzle is SQL-shaped, lightweight and schema-in-TypeScript; Prisma has its own schema language, a higher-level query API and, since Prisma 7, a Rust-free client. How they compare on schema, queries, migrations, serverless, performance and AI-assisted coding.
.dockerignore Explained: Faster Builds, Smaller Images, No Leaked Secrets
A .dockerignore file keeps files out of the Docker build context: node_modules, .git, .env files, build output. Why that makes builds faster and images smaller, how it prevents secrets ending up in images, the syntax and negation rules, a ready-to-use template, and how to check what's being sent.
Docker Compose Healthchecks and depends_on: Start Services in the Right Order
depends_on alone only waits for a container to start, not for it to be ready — which is why your app crashes with ECONNREFUSED while Postgres boots. How to write healthchecks for Postgres, MySQL, Redis and your own app, use condition: service_healthy, tune intervals, and debug unhealthy containers.
CPU Steal Time Explained: Why Your VPS Is Slow When Nothing's Running
Steal time (%st in top) is time your virtual machine wanted the CPU but the hypervisor gave it to someone else. How to measure it with top, vmstat and mpstat, what levels are normal, how it differs from high load, why shared vCPUs suffer from it, and what to do when it's hurting your app.
Claude Code Routines: Scheduled, API and GitHub-Triggered Agents in the Cloud
Routines are saved Claude Code tasks — a prompt, repositories and connectors — that run on Anthropic's cloud or an organization's self-hosted environment. How to create one with /schedule or the web, use schedule, API and GitHub triggers, and manage limits and security.
Claude Code /loop: Run a Prompt on Repeat (and Let Claude Pick the Interval)
/loop re-runs a prompt inside your Claude Code session — every 5 minutes, at an interval Claude chooses, or with a built-in maintenance prompt that babysits your PR. Syntax, self-paced loops, loop.md, one-time reminders, the 7-day expiry, jitter, and when to use routines instead.