Urgent.News

What's breaking now, across thousands of outlets.

Continued

Tech

Subqueries vs CTEs: Query Optimizer Internals & Memory Spooling Explained

Many engineers believe Common Table Expressions (CTEs) are always faster than subqueries. In modern SQL Server (and PostgreSQL), that is a myth . Here is what actually happens under the hood: 1.

  • CTEs and subqueries treated similarly by SQL optimizer in recent versions
  • CTEs offer readability and pipeline stacking advantages
  • Reusing a CTE multiple times may cause performance overhead

Tech

Building a Client-Side Byte to String Decoder with Unicode Support

Hey DEV community! 👋 When debugging network streams, parsing custom file formats, or inspecting database buffers, we often extract data as raw arrays of numbers rather than human-readable text.

  • Browser-based Byte to String Converter processes data locally
  • Utilizes UTF-8 encoding for diverse character support
  • JavaScript code validates byte values before decoding

Tech

The Golden-File Refactor Loop: Record, Verify, Move, Commit

You do not understand the messy function. That is fine. The snapshot does not care about your understanding. Golden files turn "I think this is safe" into "the diff says so." This loop has four…

  • Golden-file refactor loop records code behavior
  • Verifies behavior matches expectations before moving
  • Commits changes after successful verification

Tech

Nvidia Just Locked In a $279 Billion Bet on Memory Chips

Nvidia just committed $279 billion to lock in critical components for its data center business.

  • Nvidia commits $279 billion to secure memory chip supplies for data centers.
  • CFO Colette Kress reveals $119 billion increase from three months ago.
  • Investment fuels next-gen AI systems and Blackwell systems manufacturing.

Tech

New York City 911 System Missed 1,700 Calls Due To Software Update

Longtime Slashdot reader belmolis writes: Part of New York City's 911 emergency system was offline from about 3:13 a.m. to 10 a.m. on August 18th due to a software update, according to Medical Daily.

  • Software update caused 1,700 unanswered 911 calls in NYC on August 18th
  • Calls made to Bronx center, 400 direct callers didn't receive help
  • NYC didn't inform public, disclosed info upon journalist request

Tech

Is the best way to watch a movie on a pair of sunglasses?

Are XREAL's smart glasses the way of the future for home entertainment?

  • XREAL's a01 smart glasses offer 1080p resolution and 1,600 nits brightness for movie watching.
  • Glasses function as external monitor via USB-C connection to laptop or phone.
  • Project Aura promises more immersive experience with hand tracking and Google Play Store access.

Tech

US officials backpedal on claims that China hacked government agencies, now say they were targeted

In a freshly edited statement, the Justice Department said Friday that the US Senate, the Federal Reserve, NASA, and others were "among the targets of QTFY," a Chinese spy platform.

  • US officials revised claims about Chinese hacking of government agencies.
  • Agencies like Senate, Fed, NASA targeted by Chinese spy platform QTFY.
  • Justice Department clarified agencies were targets, not victims.

Tech

Just a rumour of a bug is enough to find a security exploit these days

Just a rumour of a bug is enough to find a security exploit these days Anil Madhavapeddy is a professor of computer science at Cambridge and a core maintainer of the OCaml compiler.

  • Automated probes discovered security issues in OCaml projects within 10 minutes of patches.
  • Security disclosures for rclone project surged to nearly 50 in the last month.
  • GitHub's CVE assignments now take up to four weeks, compared to previous two to three days.
Continue reading →