database

  1. Stateful Systems and the Fitness Floodplain: A Lament (Jan 24 2026)

    when the only tool you have is a feedback loop, everything starts to look like a process amenable to incremental adjustment across fundamentally compatible stable states

  2. Fixing Slow Row-Level Security Policies (Jul 13 2025)

    execution boundaries in funny places

  3. pdot 1.0.0: Exploring Databases Visually, Part III (May 21 2025)

    how many graphs does it take to document a database?

  4. ST_MapAlgebra and Tiled Rasters (Jun 27 2024)

    dynamic sql conquers all

  5. Terminal Tools for PostGIS (Jun 02 2024)

    visual debugging for geospatial queries, all in the shell

  6. (Plausible) Random Geography Generation with PostGIS: Fluviation (Feb 12 2024)

    take me to the river

  7. pdot: Exploring Databases Visually, Part II (Aug 13 2023)

    graph database? graph your database

  8. PGSQL Phriday #008: pg_stat_statements (May 05 2023)

    lesson learned: always check stddev_exec_time