#http

1 post tagged with "http"

This post costs one cent

I put an x402 paywall on a blog post to see what HTTP 402 feels like from both sides. This is the post behind it: what the protocol actually does, what broke on a Next.js page, and the cookie that fixed it.

September 6, 20265 min readRead more →

~/tips/today — 2026-09-06

~cat tips/today

Let a generated column hold the derived value

postgresqlschema-design

Storing lower(email) in the application and hoping every writer remembers is a bug waiting for a second writer. The database can own it.

ALTER TABLE users ADD COLUMN email_lower text
  GENERATED ALWAYS AS (lower(email)) STORED;
CREATE UNIQUE INDEX users_email_lower ON users (email_lower);

Postgres 18 added virtual generated columns too, computed on read, for values that are cheap and not worth the storage.

↵ open y yesterday l ls /tips

esc close