September 2026
March 2026
February 2026
January 2026
December 2025
- Dec 30, 2025TechnologyScaling Cloud Systems: Strategies and PatternsMapping many logical shards onto few physical ones means adding hardware never requires reorganizing the shard layout, which is why the 2012 design became a reference implementation. The page is blunt that adding servers to a poorly designed system just produces a poorly designed system with more servers, and covers load balancing, statelessness, cache invalidation, read replicas and replication lag, queues, and the CAP tradeoff during a partition.
- Dec 15, 2025TechnologyMobile Performance Optimization: Increasing App SpeedGoogle and DoubleClick research cited here found that 53% of mobile visitors abandon a session once load time passes 3 seconds, and the penalty curve is not linear: Google's 2017 analysis of 11 million mobile ad landing pages measured a 90% higher bounce rate at 3 to 5 seconds and 106% at 5 to 6 seconds. The article works through launch-time budgets, main-thread jank inside the 16.67ms frame window, list virtualization, memory limits, and battery.
July 2025
June 2025
- Jun 16, 2025ExplainersStep-by-Step: Designing Effective MetricsMetrics shape behavior whether or not they measure the right thing, so gaming follows wherever stakes are attached. A Department of Justice investigation found Baltimore officers downgrading shootings and pressuring victims to withdraw reports under CompStat. Payment can also crowd out motive: Swiss communities offered compensation for a nuclear waste site accepted it at 25%, down from 51% with no money offered.
- Jun 12, 2025ExplainersHow Database Indexes Improve Query PerformanceLeis and colleagues evaluated PostgreSQL alongside commercial systems and found estimation errors drove the planner to pick query plans 10 to 100 times slower than optimal, so a correct index can still go unused. The structural case for indexes remains overwhelming: with a branching factor of 500, a B-tree reaches 62.5 billion rows in four levels. This page covers clustered versus non-clustered, covering indexes, BRIN, the write penalty and reading EXPLAIN output.
February 2025
- Feb 9, 2025ConceptsSocial Facilitation: When Others Make Us Better, or WorseBond and Titus pooled 241 studies and over 20,000 participants in 1983 and found the effect real but modest, a mean of about d = 0.22, driven mainly by task complexity, with little consistent evidence that physiological arousal is the mediating link. That leaves the phenomenon settled and the mechanism disputed: Zajonc's drive theory, Cottrell's evaluation apprehension, Baron's distraction-conflict account, and Bond's self-presentation view each explain part of it.
- Feb 5, 2025ConceptsGoal-Setting Theory: Effective Strategies for SuccessWhat makes a goal change behavior. Latham and Baldes gave timber truck drivers one specific target, load to 94 percent of the legal maximum, with no bonus and no training on technique; load weights climbed toward it within weeks and stayed, while a control group given no number showed no change. Locke and Latham's 1990 book synthesized roughly 400 studies conducted over about 25 years.
January 2025
February 2023
September 2022
No guides match that search. Try a shorter phrase, or clear the search.