EXPLORE ARTICLES

Articles & dev notes

Implementation guides, design thinking and troubleshooting. Find them by context and code.

⌕

ARTICLES & NOTES

Articles & dev notes

2 ARTICLES

All Frontend Backend Infrastructure Dev Practices & Tools CS & Math AI & Data Science Saved articles

Backend·Design guide13 MIN READ

A stack for solo developers and early startups: build small, keep operations light

How to choose technology to build and run with a small team, using the setup of a real web app (React Router, Cloudflare Workers, D1, Clerk) as the example.

Solo devCloudflareArchitecture

Enough if you have built one web app

Backend·Hands-on guide10 MIN READ

IN (subquery) over UNION ALL read 570,000 rows: PostgreSQL's estimates, and = ANY(ARRAY(...))

After two tables were shown as one through UNION ALL, a product-code search took 4 seconds. Reproduced locally, IN made the planner walk the whole popularity index. A record of reading the estimates to find the cause, and getting back to 0.3 ms with = ANY(ARRAY(...)).

PostgreSQLSQLEXPLAINPerformance

For people who have looked at EXPLAIN