I indexed 17,341 polynomial fan curves in Postgres and matched a duty point in <100ms
Most B2B HVAC catalogs publish fan performance curves as scanned PDFs. Engineers do the interpolation by eye when they need to know "will this fan del…
Open Source
⚑ Report a ProblemLatest Open Source news from Tech News
All topics
AI
agents
ai
api
architecture
automation
aws
beginners
career
claude
database
devchallenge
devops
discuss
javascript
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
rust
security
showdev
tutorial
typescript
webdev
Ruby on Rails Has Scalability Issues. Here's How We Solved Them
Every few months someone declares Rails dead. Then Shopify reports another record Black Friday. In 2025, Shopify's Rails monolith handled 489 million …
Async Processing: The Secret to Surviving Spikes
How decoupling work from requests helps systems stay stable under load In the previous part, we saw the limitations of synchronous systems. When every…
PostgreSQL Index Usage and Optimization
PostgreSQL Index Usage and Optimization Indexing is the single biggest lever in SQL performance, and it is also the category where most of the bad adv…
Building for the Next Billion Users: Engineering for Emerging Markets
The next wave of internet users will not come from highly connected urban centers. They will come from emerging markets. From small towns, rural areas…
Stop Guessing Your Next GPU: I Built a GPU Upgrade Value Calculator
I published a new tool on the site: the GPU Upgrade Value Calculator . This one started as a follow-up to my RX 6700 XT vs RTX 4070 Ti comparison . Re…
The Zeigarnik Effect in a Single Room: Fixing Context Bleed and Mental Fog
I recently spent two hours in a noisy coffee shop, completely locked into some fairly dense reading. I was jumping between the mechanics of gold price…
Maximum Concurrency (& Sub-Quadratic Scaling) By TokenGate
What is TokenGate? TokenGate is a beta Python concurrency system built around a token-managed execution model. Instead of managing threads directly, y…
eBPF From Rust: The 34ms Ghost We Couldn’t See
When your profiler swears everything’s fast but your metrics are screaming bloody murder eBPF From Rust: The 34ms Ghost We Couldn’t See When your prof…
How to Benchmark LLM Inference Performance: TTFT, ITL, and Throughput Metrics
When deploying large language models to production, measuring performance accurately is critical. Whether you're using vLLM, SGLang, TensorRT-LLM, or …
JavaScript: Handling Large Files in the Browser. Part 1/2: Reading Large Files
The DGRM.net online whiteboard stores data in PNG images. With attachments, the files become large. I’ll explain how data is stored in PNG files. Fig.…
Building Performance-First Websites: A Developer's Guide to Measurable Speed
Building Performance-First Websites: A Developer's Guide to Measurable Speed Web performance has evolved from a nice-to-have optimisation into a funda…
How I Fixed a 42/100 Lighthouse Score on a B2B 3D WebGL Landing Page (and Open-Sourced the Fix)
A few weeks ago, I was building a B2B landing page that embedded an industrial 3D model using <model-viewer> . The page looked fantastic. Then I…
React Re-rendering: When and Why Component Trees Update
Related: Long Tasks and Main Thread Blocking heavy React renders are one of the most common sources of Long Tasks. React's default re-render behavior …
How to add backpressure to Socket.IO in production
Real-time applications often start with a simple promise: push data from the server to the client as it happens. You install Socket.IO, set up a names…
Programming Hopper GPUs: The Memory Consistency Model
You've decided to write fast code for an NVIDIA Hopper GPU. Maybe you want to build a custom attention kernel. Maybe you're trying to understand how C…
Borrowed Strings: API Designs That Cut 94% of Allocations
The 6ms latency improvement from one character change — how &str over String transformed our hot path performance Borrowed Strings: API Designs Th…
Advanced PostgreSQL: JSONB, partial indexes and partitioning
A trades table with 50 million rows. The query "which active trades for this user this month" takes 4 seconds. After applying the four techniques in t…
Building C24 Club: The Architecture Behind a Rewards-Powered Video Chat Platform!
Random video chat looks simple from the outside! click a button, meet a stranger. But the moment you add a live rewards economy, gender-aware matchmak…
NVIDIA Driver Setup on Fedora 43 Workstation
RTX 3050 Mobile (Hybrid AMD + NVIDIA Laptop) Reference Guide: Comprehensive-Wall28/Nvidia-Fedora-Guide System Profile Property Value OS Fedora 43 Work…
SQL Server Running Slow? Here's What Actually Fixes It.
Every growing business hits this wall at some point. The application that worked perfectly six months ago now takes forever to load. Users start compl…
Cost Optimization Strategies for Databricks Workloads
Introduction Databricks has become a core platform for data engineering, analytics, and machine learning. It brings flexibility and scalability, but i…
Stitch Multiple Videos Together Without Re-encoding Them
Ever recorded several short clips and wished you could just glue them into one file? Maybe a bunch of vacation footage, a series of screen recordings,…
One PR to a parser unlocked prerendering in Brisa
I built a JavaScript framework called Brisa . The kind of framework that needs to parse every single source file your app contains; analyze imports, d…
Spelling correction at scale: Levenshtein distance, BK-trees, and symmetric deletion
Spelling correction at scale: Levenshtein distance, BK-trees, and symmetric deletion If you’ve ever built a search feature, you’ve likely started …
How I Built a React JSON Tool That Handles 150k+ Lines Without Freezing the Browser
Most JSON tools work fine… until they meet real-world production data. We’ve all been there: You paste a massive payload into a web-based formatter, a…
Privacy-first mind mapping app. Part 2: Rust Backend - Why the Pain Is Worth It
Choosing Rust for a backend can feel irrational at first. If your short‑term goal is raw development speed, Rust does not win. The compiler is unforgi…
Redis-backed permissions for high-volume Laravel apps: v4.0.0-beta.1
I just shipped v4.0.0-beta.1 of laravel-permissions-redis , and I want to share both what's in it and the specific problem it exists to solve. The pro…