Category
33 articles in Technology.
P.01Two-phase commit makes several databases commit or abort together. How prepare and commit work, why a coordinator crash blocks you, and Postgres examples.
P.02HyperLogLog counts millions of unique visitors in about 12 KB with roughly 0.81% error. How it works, a Python sketch, and Redis PFADD in production.
P.03Python 3.15 made UTF-8 the default encoding on every platform. Here is how to find the open() calls that change behavior, and fix them before upgrading.
P.04WAL mode lets SQLite readers and a writer work at once. Here is how it works, the pragmas to set, and the three ways it bites in production.
P.05Use zstd as your default, LZ4 when decompression speed beats size, gzip only for compatibility. Benchmark numbers, code and a decision table for 2026.
P.06MVCC keeps several versions of each row so reads never wait on writes. See xmin and xmax in a live Postgres session, and why long transactions cause bloat.
P.07Your p99 is slower than your average suggests, and fan-out makes it worse. How hedged requests and load shedding cut tail latency, with TypeScript code.
P.08An LSM tree turns random writes into sequential ones by buffering in memory and merging sorted files. How it works, what compaction costs, and when to pick it.
P.09Zig 0.17 is out. Here is what breaks in your code and build.zig, the before-and-after fixes, and why ZLS is not ready yet. Read this before you bump.
P.10A write-ahead log makes a database durable by recording changes before touching data files. How WAL commits, recovers, replicates, and what it trades.
P.11JDK 27 arrived September 15 with G1 as the default GC everywhere and compact object headers on by default. What to measure before you roll it out.
P.12Beta 4 reverted six features, including SQL/PGQ graph queries, and PostgreSQL 19 turns JIT off by default. What to test before the October release.
P.13Python 3.15 adds explicit lazy imports, a frozendict built-in, UTF-8 by default and the Tachyon sampling profiler. What to test now and what can wait.
P.14Shopify moved its mobile apps from React Native back to Swift and Kotlin. Here's the reasoning, the numbers, and how small teams should read the news.
P.15macOS 27 deprecates hdiutil and points disk image work at diskutil image. The subcommand mapping, what's missing, and updating a DMG build without breaking CI.
P.16cargo-audit finds known CVEs after the fact; cargo-vet checks trust before you upgrade. Setup for both, and which catches an arrayref-style attack.
P.17Google made Android UI Compose-first: Views gets critical fixes but no new features, ever. What maintenance mode covers, and how to plan a migration.
P.18GitHub restricted stargazers and watchers to admins and collaborators in July 2026. It stopped spam scraping, and took Star History and OSS Insight with it.
P.19Android 17 (API 37) brings mandatory large-screen resizability, a local network permission, and stricter media rules. What to fix, and by when.
P.20OpenFeature is a CNCF incubating project with broad SDK support. How to use vendor-neutral feature flags, and why the standard beats the tool behind it.
P.21DuckDB runs OLAP queries directly in your process, on files on your laptop, without a server. Here's how to use it and when it beats spinning up BigQuery or Redshift.
P.22Most developers still run decade-old command line tools. Here's what's replaced them in 2026: faster terminals, Git UIs, shell prompts, and search tools.
P.23PostHog, Mixpanel, and Amplitude serve different primary users: engineers, product managers, and growth teams. Here is how to pick the right one.
P.24React Native's Fabric and JSI replaced the async bridge with direct native calls, default since RN 0.76. What changed, what migration costs, and the rough edges left.
P.25Python 3.13's experimental mode removes the Global Interpreter Lock. What the GIL actually does, what free-threaded Python changes, and what it doesn't fix.
P.26Python 3.14 shipped in October 2025. The new features worth upgrading for, the ones you can safely ignore, and what changes for existing code when you move.
P.27Polars beats pandas on speed through Arrow memory, multi-threading, and lazy evaluation by default. Here's when the switch is worth it and how to migrate.
P.28Vitest runs faster than Jest, handles ESM and TypeScript natively, and shares Jest's API. The case for switching in a Vite project, and how to do it.
P.29uv is a Rust-written Python package manager covering dependencies, virtualenvs, and Python versions. What changed after moving eight projects onto it.
P.30EditorPickThe A19 Neural Engine, the Foundation Models framework, and Visual Intelligence upgrades compared, from six months of shipping real iOS AI features on both chips.
P.31Zig 0.16 ships an async rewrite, improved comptime, and growing production use at Bun, TigerBeetle, and Uber. Here is why C developers should stop ignoring it.
P.32WebAssembly is not just for browser apps anymore. From edge computing to plugin systems, here are 5 production use cases reshaping how we build software.
P.33EditorPickMaster bitwise operations, bitmasking, bit manipulation tricks, and bit-based algorithms for competitive programming and software engineering interviews.