
How We Reduced PostgreSQL Query Time from 250ms to 20ms
A production story about wrong indexes, planner regressions, and the query rewrite nobody wanted to do. Rails, PostgreSQL, PgHero, partial indexes, and LEFT JOIN.

A production story about wrong indexes, planner regressions, and the query rewrite nobody wanted to do. Rails, PostgreSQL, PgHero, partial indexes, and LEFT JOIN.

Model benchmarks get the attention, but workflows, agent design, and toolchain architecture drive real AI coding productivity. Why workflow-first beats model-chasing.

LinkedIn metrics lack signal. I built a local pipeline: scrape posts, score against a CTO/founder goal, classify topics—Ruby, Postgres, Ollama, caching, RAG rollup.

Learn how this in-memory datastore is single-threaded on the outside, but multithreaded on the inside. Read the full case study!

Learn how we eliminated UI flicker and reduced load time in a Telegram Mini App by loading all user data in a single PostgreSQL query. Read the full case study!

Learn why effective AI-powered development starts with your own architectural thinking and task decomposition — not just prompts. Discover how to think architecturally!

90% of startups fail because customers don’t feel real pain. Learn how to validate ideas, avoid AI chaos, and turn vision into a working product.

Beware fake recruiters on LinkedIn. A real case of malware disguised as a job test, targeting crypto wallets and system data. Learn how to protect yourself.

Learn how to formulate prompts in Cursor using the TARS technique (Task, Assumptions, Requirements, Specification) to get more accurate and helpful results.

Learn how to send USDT TRC-20 on TRON without needing TRX or energy using Ruby gem gasfree_sdk. Build gasless transactions and simplify Web3 UX.