cutting N+1 queries in Next.js API routes with Supabase RPC
when a dashboard starts pulling relational data from Supabase, the naive approach is to fire a separate select per row. the result is a classic N+1…
DevOps
⚑ Report a ProblemLatest DevOps news from Tech News
All topics
agents
ai
api
architecture
automation
aws
backend
beginners
cloud
database
devchallenge
devops
docker
javascript
kubernetes
llm
machinelearning
mcp
node
opensource
performance
productivity
programming
python
security
showdev
testing
tutorial
typescript
webdev
Enforcing a concrete performance budget for Expo EAS builds and OTA updates
The situation Say you are a mobile engineer on a small React‑Native team that uses Expo Application Services (EAS) for CI‑driven builds and over‑the…
why pg‑bouncer can still choke your service under burst load
problem statement in a typical microservice, each instance opens its own pg client pool. during a traffic spike the aggregate connection count can e…
Architecture Patterns for Custom Direct Booking Engines & Hospitality Web Apps
When building web applications for the hospitality sector—ranging from luxury boutique hotels to private villa rentals—developers often face a choic…
CrUX Now Counts SPA Soft Navigations. 5 Things I'd Check Before Search Console Switches
For years, the Chrome UX Report (CrUX) has had a blind spot. If your site is a single-page app, Chrome only recorded the first "hard" page load. Eve…
Bevy instancing: drawing 639,000 units with one draw call per mesh
Originally published at tensorust.com . TL;DR: Bevy already instances meshes for you when entities share a mesh and a material. Past a few thousand…
🔥 30 Days of Frontend — Day 5: React DevTools Profiler
When a React application starts feeling slow, one of the first things developers often do is reach for useMemo , useCallback , or React.memo . We've…
when tRPC beats REST for fine‑grained data fetching in Next.js
in a midsize SaaS product we hit a scaling wall when dozens of React components started querying overlapping slices of a user record. each component…
C = 1.25 is a tolerance, not a constant: the load-tail law behind MoE token dropping
Every sparse Mixture-of-Experts layer has a number in it that nobody derived. You need a static shape for the kernel, so each expert gets a budget c…
Why We Kept Ternary Bonsai 2 27B After Testing the Faster 9B
October 16, 2026 Our production classifier runs on a single RTX 2080 Ti with 11 GB of VRAM. It is often busy enough that requests spill over to a ho…
A million-tap linear-phase FIR in real time: 7 ms of plumbing, 650 ms of filter
I'm building Sonir Bench, a macOS app that captures everything your Mac plays, runs it through a DSP chain you design, and sends it to your DAC. The…
The optimization that doesn't survive the process boundary
The optimization that doesn't survive the process boundary I found a slow lookup in our inbound-message handler — every incoming SMS triggered an O(…
HBM Explained: Why High-Bandwidth Memory Is Critical for AI Accelerators
Introduction: Why HBM Matters Artificial intelligence has changed the way computing systems are designed. In traditional servers, system performance…
Technical SEO for Developers: From URL Architecture to Rendering and Indexing
A sitemap points to one URL. The page declares another as canonical. Internal links keep reinforcing a third version. You can change the SEO plugin…
How I Use a $5.5 WebDAV Mount to Edit 4K Video Without Local Storage
How I Use a $5.5 WebDAV Mount to Edit 4K Video Without Local Storage Most video editors assume your media lives on a fast local drive. If you are ed…
How to Improve Blogger Website Performance with Practical HTML and CSS Optimizations
How to Improve Blogger Website Performance with Practical HTML and CSS Optimizations A Blogger website can look beautiful and still perform poorly o…
Profiling a Slow Application: Stop Guessing, Start Measuring
Your application is slow. Users are complaining. API requests are taking too long, and pages are struggling to load. Your first instinct might be to…
Why a '35GB' Quantized LLM Still OOMs an 80GB GPU: KV Cache, GQA vs. DeepSeek MLA, and the Real VRAM Math
Every engineer deploying open-weights models hits the same rite of passage: You take a 70B parameter model, quantize it to 4-bit ( 70B * 0.5 bytes ≈…
Most PySpark Tuning Advice Starts in the Wrong Place
When I benchmarked PySpark's UDF types earlier this year, I ran the same three workloads (trivial arithmetic, a string transform, a normal CDF) at f…
What Is Event Loop Lag in Node.js? How to Measure It (Part 1)
Your Node.js API gets slow. The database looks fine. So do the downstream services. Yet p99 latency has tripled and even the health check takes 300m…
How I Kept a 4K Media Client Under 1 MB (When Every Player App Weighs 100 MB+)
I build small software. My latest project, RKMovies, is a 4K-capable media client for Android and Windows that ships as a 0.91 MB APK. Not 91 MB — 0…
Why your tests don't catch N+1 queries (and how to make them)
N+1 queries are easy to merge with a green CI run. The tests covered the endpoint and checked the response. They did not check how many queries it t…
How big is Hello World in C#? From 76 MB down to 0.73 MB
How big is the smallest C# program? It depends almost entirely on how you publish it . Same one line of code, five different dotnet publish commands…
What async/await really compiles to in C# (and when ValueTask is worth it)
Most of us use async / await every day without knowing what it turns into. That's fine, until you need to answer a question like "should this method…
1,826 draw calls to put 61 objects on the screen
Development covered 15 Aug 2026 to 17 Aug 2026 (commit dates). Players of Myriad Immortal Sect walk a continent that streams in around them as they…
Server-Sent Events (SSE) Backpressure Breaks: Memory Leaks and Socket Starvation in High-Throughput LLM Pipelines
Streaming LLM completions over Server-Sent Events (SSE) looks trivial in sandbox demos, but unhandled backpressure under real-world network conditio…
Our Next.js ISR writes hit 325K on Vercel's free plan. Determinism fixed half of it
I run promokoduz.uz , a promo-code catalogue for Uzbekistan in three languages. It is a small site: 111 live codes across 75 brands and about 60 vis…
Replacing ffmpeg.wasm with WebCodecs: a 1080p export from 10.3s to 2.6s
I maintain a browser-based video editor. Everything runs client-side — no upload, no server — which for a long time meant ffmpeg compiled to WebAsse…
Why @next/bundle-analyzer wasn't enough for our team (So we built an automated PR bot)
If you've ever worked on a growing Next.js app, you've probably lived through this exact scenario: You’re reviewing a seemingly harmless pull reques…
You Picked a State of the Art Model. The API Is Making It Hard to Tell.
The model can do the job. The service delivering it has a job to do, too. You compare models, run your evaluation set, and find one that gets it. It…