Archive
98 posts, newest first. Page 1 of 10.
A practical field guide to the Postgres behaviors that most often surprise application developers—from index selection and lock queues to SQL NULL semantics and JSONB trade-offs. The central lesson: use Postgres’s conventional relational tools deliberately, inspect query plans, and treat schema changes and flexible data types with caution.
PostgreSQL can consolidate much of a modern application stack—from search and queues to analytics, vectors, and graphs—reducing operational complexity. Start with Postgres and introduce specialized systems only when real scale or feature limits demand them.
A centralized navigation hub for Casey Muratori’s Computer, Enhance! programming courses, technical challenges, and interview series. The flagship Performance-Aware Programming curriculum teaches how modern CPUs execute code and how to measure and optimize real software.
A navigable index for Handmade Hero’s extensive game-development video series, from C and Win32 fundamentals through rendering, simulation, tooling, asset pipelines, and lighting. It also catalogs companion chats, raytracing sessions, miscellany, and HandmadeCon talks.
A forensic tour of the real hardware, software, and screen graphics used in Jurassic Park’s control room. The production borrowed more than $1.7 million in period equipment, while many supposedly live systems were driven from an off-stage graphics room.
JA Westenberg argues that convenience routinely beats the appeal of doing things yourself—a dynamic that undermines claims that users will replace SaaS products by coding their own tools. The essay uses the "bread paradox" to frame why SaaS is not doomed.
A fully headless Apple-app workflow can build, sign, notarize, staple, install, and deploy apps using Xcode’s command-line toolchain. After one-time credential setup, a generated project and release script let developers or coding agents ship without opening Xcode.
Susan Rigetti’s self-study roadmap lays out a textbook-driven path from high-school math through graduate-level physics. The guide emphasizes sequential prerequisites, rigorous problem solving, and accessible alternatives to formal university study.
Databricks argues that externalizing Postgres storage eliminates core monolithic-database constraints, then extends the design to serve fresh analytics from the same durable data. Lakebase and LTAP separate transactional and analytical compute while unifying their storage layer.
Co-locating durable workflow metadata and application data in Postgres lets both commit atomically, eliminating critical failure windows. DBOS uses this to offer exactly-once transactional steps and a simpler transactional-outbox pattern.