Urgent.News

What's breaking now, across thousands of outlets.

Tech

How to Stop N+1 Database Queries in Django Tests with django-query-guard

N+1 database queries and silent query count growth can severely affect Django application performance. Unfortunately, they are often discovered too lateโ€”in production server logs or APM dashboards. To solve this problem, I built django-query-guard โ€”an open-source Pytest plugin that brings database performance checks directly into automated test suites. ๐Ÿ’ก The Problem: Silent N+1 Queries Inโ€ฆ

We haven't written up this one. Dev.to has the full story โ€” the link below goes straight to it.

Read the original at dev.to โ†’

More in Tech

Stop Thrashing Under Memory Pressure: Practical zram + systemd-oomd on Linux

Stop Thrashing Under Memory Pressure: Practical zram + systemd-oomd on Linux When a homelab box or small VPS runs out of free RAM, the failure mode is rarely a clean kill.

  • zram provides compressed swap in RAM, reducing disk swap impact
  • systemd-oomd monitors cgroup v2 PSI to proactively kill offending processes
  • Configuration sets zram size to half of system RAM with ZSTD compression

636 Bytes: What Happens When You Stop Teaching RPA the Path

I sat in a room with a very large automation system and a very familiar problem: it had become fragile. The language came quickly. DOM. Timestamps. Timing windows. Selectors. Retries. Circle back.

  • Traditional RPA relies on brittle selectors and timing windows
  • New architecture uses intent-driven automation with 636-byte WebAssembly module
  • Cost reduction of 82.1% achieved with intent architecture

An 18-hour half-life for mixed launch feeds

Product Hunt, Hacker News, and GitHub do not speak the same language. One is votes in a 24-hour window, one is comments on a Show HN, one is stars on a repo that may have been created last month.

  • 18-hour half-life chosen for LaunchSignal ranking system
  • GitHub stars weighted heavily at 2 ร— stars + forks
  • 18-hour half-life balances recent activity and fair representation

Your App Center List Is Not a Security Audit

I opened Ubuntu's App Center, scrolled through ~90 installed packages, and asked the obvious question: is any of this malware? The list looked suspicious in all the wrong ways.

  • App Center shows Ubuntu archive, Snap Store, but overlooks other attack vectors
  • Updated date indicates package version, not neglect or vulnerabilities
  • Snap publishers verification reveals verified publishers for 21 installed snaps

More from Friday 28 August โ†’