Catalogue

Cards
165
Records
486
Workloads
19
Corpus version
74847648e25a
Workload
Kind
Setup

18 of 486 records match.

KindRecordOrganisationYearSetup
Decision

Batch ping writes with COPY in one transaction instead of calling a stored procedure once per ping

healthchecks-2025-ping-ingest#d1peak under 100,000 requests/s

Healthchecks.io2025One database
Decision

Cache not-found results for UUID ping URLs so repeated pings to missing checks skip the database

healthchecks-2025-ping-ingest#d2peak under 100,000 requests/s

Healthchecks.io2025One database
Decision

Stop using DynamoDB and serve key/value lookups, ingest and rate limiting from one fixed-size SingleStore cluster

fathom-2021-singlestore-database#d1

Fathom Analytics2021One database
Decision

Keep database connections open by moving the dashboard and queue off per-request Lambda connections

fathom-2021-singlestore-database#d2

Fathom Analytics2021One database
Failure

A viral customer's pageviews backlog the shared queue for all sites while the database runs out of disk IOPS

fathom-2020-viral-customer-backlog#f1

Fathom Analytics2020One database
Failure

Unindexed backlog tables and a text-typed site ID kept the database slow after the disk was fixed

fathom-2020-viral-customer-backlog#f2

Fathom Analytics2020One database
Decision

Cap concurrent queue workers on purpose to protect the database, accepting a bigger backlog

fathom-2020-viral-customer-backlog#d1

Fathom Analytics2020One database
Decision

Limit pageviews processed per site per minute so one viral site cannot block the rest, then drop it

fathom-2020-viral-customer-backlog#d2

Fathom Analytics2020One database
Failure

A hundred checker Lambdas each opened a database connection at once, and Postgres refused further connections

onlineornot-2023-lambda-write-fan-in#f1

OnlineOrNotOne database
Decision

Fan results in through SNS and a batching queue so one Lambda writes to Postgres, instead of upgrading the database

onlineornot-2023-lambda-write-fan-in#d1

OnlineOrNotOne database
Decision

Run a Django monolith on a shared AWS EKS cluster with GitOps rather than a single VPS

panelbear-2023-solo-saas-architecture#d1

PanelbearOne site
Decision

Move a growing project's Postgres from an in-cluster container to AWS RDS

panelbear-2023-solo-saas-architecture#d2

PanelbearOne site
Decision

Replace self-hosted Prometheus, Grafana and Loki with hosted New Relic so alerts survive cluster failures

panelbear-2023-solo-saas-architecture#d3

PanelbearOne site
Decision

Serve static assets from the app container with Whitenoise behind Cloudflare instead of uploading to S3

panelbear-2023-solo-saas-architecture#d4

PanelbearOne site
Decision

Cache multi-database plan capacity checks for 15 minutes with explicit invalidation on plan changes

panelbear-2023-solo-saas-architecture#d5

PanelbearOne site
Decision

Self-host ClickHouse in Kubernetes for analytics data alongside Postgres

panelbear-2023-solo-saas-architecture#d6

PanelbearOne site
Decision

Migrate the Energy analytics database from multi-AZ Postgres RDS to Aurora for elastic storage

gridium-2021-aurora-migration#d1

GridiumOne database
Decision

Upsize the Aurora writer for buffer cache, route reads to a downsized replica, and run pg_repack on bloated tables to cut billed I/O

gridium-2021-aurora-migration#d2

GridiumOne database