A benchmark sweep of a PostgreSQL instance from 1 to 400 connections shows throughput peaking at 48 connections (18,039 tps) and dropping 37% by 400 connections, while average latency multiplied 13x. The piece explains why connections are OS processes competing for cores rather than free capacity, tests the Universal Scalability Law fit (R²=0.94, predicted optimum 45.1), evaluates the (cores×2)+spindles formula (predicts 9, far off the measured 48), and finds that synchronous_commit=off raises throughput but does not shift the peak. It closes with practical guidance: watch queue depth (cl_waiting in PgBouncer, pending-threads in HikariCP) rather than connection count, account for instances × pool size multiplication, and use transaction pooling or RDS Proxy for Lambda to avoid connection exhaustion.

pnpm 12 is now stable, a full Rust rewrite that preserves pnpm 11's commands, flags, settings, and lockfile format without requiring migration. It's installed via the next-12 npm tag since latest still points to pnpm 11. Breaking changes include git dependency specifiers resolving through canonical HTTPS URLs instead of SSH, unrecognized pnpm-workspace.yaml settings now being reported (and failing when a pnpm version is pinned), canonicalized lockfiles for cyclic dependency graphs (2-3x faster peer resolution, ~25% less memory on cycle-heavy workspaces), hardlink-first behavior for packageImportMethod: auto on Linux, and stricter engineStrict edge traversal. New features include project-aware global bins for node/deno/bun, pnpm provisioning other package managers (npm, Yarn, Bun) via pnx and pnpm shim, registry revisions for serving patched artifacts without version bumps, pnpm init pinning the latest pnpm version, batch approval for staged publishing, audit.ignorePrune, sudo restrict

Node.js 24.20.0 'Krypton' LTS ships several SEMVER-MINOR additions: using scopes for AsyncLocalStorage, an end parameter for Buffer, permission.drop and a new --permission-audit flag, package maps support in the loader, a new node:stream/iter module, context.log() in the test runner, and WebAssembly JSPI enabled. It also updates root certificates to NSS 3.125 and bundles numerous dependency upgrades (npm 11.19.0, ngtcp2, nghttp3, c-ares, sqlite, timezone data) plus a long list of bug fixes across crypto, buffer, http, http2, quic, and net modules.

The UK government has set 2032 as a target date for switching off Freeview digital terrestrial TV broadcasting, moving television delivery entirely to internet-based streaming with an initial set-top-box requirement. This mirrors a broader European decline in over-the-air broadcast media, including the BBC's earlier shutdown of long wave and AM transmissions. Unlike past analog shutoffs, this move retires the very digital multiplex system (DVB-T/ATSC) that replaced analog TV roughly fifteen years ago, despite it still being widely used.

Inertia.js v3.7.0 adds a cancelOnUnmount attribute and a cancel method to the Form component so in-flight submissions can be aborted when a form unmounts or via a button click. usePoll now exposes a reactive polling value across Vue, React, and Svelte. Once props no longer lose their value during instant visits, and navigation no longer cancels background async visits aimed at other pages. Three fixes address a React back_forward stale-props bug, prop identity issues in replaceProp/appendToProp/prependToProp, and a Form unmount crash in React.

Building on an earlier post advocating two-state (rather than tri-state) dark mode toggles, the author now argues that most websites shouldn't have a persistent dark mode toggle at all — the setting should default to following the OS and live in a settings panel instead. The piece responds point by point to Bramus's counter-argument for tri-state toggles (a scenario involving OS auto-switching plus reverted selections), calling it rare, cheaply recoverable, and a case of developers overweighting their own edge cases (IKEA effect meeting false-consensus bias). It also surveys community-designed alternative toggles (Vale's 3-in-2 design,

PostgreSQL 19 introduces four new system views for observability: pg_stat_lock provides cumulative cluster-wide lock contention statistics per lock type, including a fastpath_exceeded counter useful for partition-heavy workloads; pg_stat_recovery gives a single atomic snapshot of standby recovery state (replay LSNs, timelines, pause state, promotion status), replacing the need to combine several inconsistent functions;pg_stat_autovacuum_sc exposes the new per-table scoring system (based on XID age, multixact age, dead tuples, inserts, and analyze staleness) that now determines autovacuum table processing order, replacing the old pg_class ordering; and pg_dsm_registry_allocations lists dynamic shared memory registry entries (name, type, size) used by extensions that no longer need shared_preload_libraries and a restart. The piece walks through each view's schema and runs live demo queries showing sample output. PostgreSQL 19 is still in beta and details may change before GA.

NestJS 12 comes with some solid updates, no doubt about that. But if you haven’t looked at the new observability features yet, it is worth a close look.
Setting up APM tools in Node has always felt a bit clunky. Most agents sit outside the app, monkey-patching HTTP drivers and database packages to guess what is happening under the hood. It works, but you usually lose framework context along the way.
Full Article : https://lnkd.in/p/gP53bYmC

Svelte 5.57 adds new SvelteMap methods (getOrInsert, getOrInsertComputed), a createContext has function, select defaultValue support, and new svelte/server type exports. SvelteKit 3's next release candidate continues iterating with several breaking changes including reworked cross-page form actions, split Vite plugin hooks, defineParams relocation, and route filtering for test files. The sv CLI replaces its mcp add-on with a broader ai-tools add-on and ships a task-based sveltekit-3 migration command that rewrites $lib imports to #lib and bumps dependencies. The roundup also covers stable SvelteKit 2.x patches, language tools updates, and a community showcase of Svelte apps, UI libraries, and dev tools.