🤖robot.villas
PostsTagsStatsStatus

© 2025 - 2026 Nat Welch. All rights reserved.

← All bots

Brandur Leach

@brandur@robot.villas

High-quality writing on Postgres, distributed systems, and API design.

Source: https://brandur.org/articles.atom

Pick your instance

Enter the Mastodon instance your account is hosted at.

Don't have an account? Find a server at joinmastodon.org

Posts
21
Followers
2
Following
2

Posts

  • The Second Wave of the API-first Economy

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Mar 27, 2026
  • Eradicating N+1s: The Two-phase Data Load and Render Pattern in Go

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    May 28, 2024
  • The Notifier Pattern for Applications That Use Postgres

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    May 6, 2024
  • Web APIs: Enriched DX By Disallowing Unknown Fields

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    May 5, 2024
  • River: a Fast, Robust Job Queue for Go + Postgres

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Nov 20, 2023
  • On Using Go's `t.Parallel()`

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Aug 26, 2023
  • Soft Deletion Probably Isn't Worth It

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Jul 19, 2022
  • Postgres: Boundless `text` and Back Again

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Sep 10, 2021
  • How We Went All In on sqlc/pgx for Postgres + Go

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Sep 8, 2021
  • Minimally Invasive (and More Accurate) Analytics: GoAccess and Athena/SQL

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Feb 16, 2021
  • Feature Casualties of Large Databases

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Dec 1, 2020
  • Doubling the Sorting Speed of Postgres Network Types with Abbreviated Keys

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Aug 7, 2019
  • Sequences: A Modest, Contra-garden Travel Project

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Jun 4, 2019
  • Building a Robust Live Reloader with WebSockets and Go

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    May 28, 2019
  • SortSupport: Sorting in Postgres at Speed

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Feb 4, 2019
  • How to Manage Connections Efficiently in Postgres, or Any Database

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Oct 15, 2018
  • A Missing Link in Postgres 11: Fast Column Creation with Defaults

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Aug 28, 2018
  • Tweeting for 10,000 Years: An Experiment in Autonomous Software

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Jul 20, 2018
  • Living APIs, and the Case for GraphQL

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Jun 8, 2018
  • Scaling a High-traffic Rate Limiting Stack with Redis Cluster

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Apr 26, 2018
  • Touring a Fast, Safe, and Complete(ish) Web Service in Rust

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Pick your instance

    Enter the Mastodon instance your account is hosted at.

    Don't have an account? Find a server at joinmastodon.org

    Mar 27, 2018