From Our Team

All Articles

Insights, tutorials, and updates from our team to help you build better software.

Search the journal

Filter by topic

From Our Team

Ideas worth building on

Practical notes from the people designing, shipping, and improving digital products every day.

backend

Running Databases in Production: Pooling, Maintenance, Partitioning, and Backups

Fast queries are only part of a healthy database. This guide covers the operational side: sizing connection pools, keeping vacuum and statistics healthy, partitioning large tables, planning capacity, and designing backups you have actually tested restoring.

Sep 24, 20266 min read

backend

Go Concurrency in Production: Goroutines, Channels, and Knowing When to Stop

Starting a goroutine takes one keyword. Shutting it down cleanly, capping how many run at once, and making sure none leak takes design. This article covers the patterns we use for concurrent Go services that stay predictable under load.

Sep 24, 20265 min read

backend

A Practical Indexing Strategy: Choosing, Ordering, and Pruning Indexes

Indexes are the most powerful performance tool in a relational database, and the easiest to misuse. This article explains how B-tree, hash, GIN, and BRIN indexes differ, why column order in composite indexes matters, when covering and partial indexes help, and how to find indexes that only cost you.

Sep 24, 20266 min read

backend

SQL Query Optimization: Reading Plans and Fixing the Usual Suspects

A slow query is rarely a mystery once you can read its execution plan. This guide explains EXPLAIN ANALYZE, then fixes the problems that account for most slow queries: N+1 access patterns, non-sargable filters, bad row estimates, deep pagination, and fetching more data than needed.

Sep 24, 20266 min read

backend

Optimizing Graph Workloads: From Algorithm Choice to Memory Layout

Graph problems power route planning, recommendations, fraud detection, and dependency resolution, and they get slow in surprising ways. This article covers choosing the right traversal algorithm, representing graphs compactly, pruning the search space, and tuning queries in graph databases.

Sep 24, 20266 min read

backend

Observability for Microservices: Traces, Metrics, and Logs That Answer Questions

With twenty services behind one request, "check the logs" stops being a strategy. This article covers how distributed tracing, well-chosen metrics, and structured logs work together, and how to instrument services with OpenTelemetry without drowning in data.

Sep 24, 20265 min read

backend

Resilient Service Communication: Sync Calls, Events, Retries, and Idempotency

In a distributed system, every network call can fail, stall, or succeed twice. This article compares synchronous and event-driven communication and covers timeouts, retries with backoff, idempotency keys, circuit breakers, and the outbox pattern.

Sep 24, 20266 min read

backend

Drawing Microservice Boundaries with Domain-Driven Design

Most microservice pain traces back to one decision: where the boundaries were drawn. This guide shows how bounded contexts, aggregates, and a few practical tests help you split a system into services that can change independently.

Sep 24, 20265 min read

backend

Profiling Go with pprof: Finding the Real Bottleneck

Guessing at performance problems wastes days. Go includes a profiler that shows where CPU time and memory actually go. This walkthrough covers collecting CPU, heap, and allocation profiles, reading flame graphs, and fixing the problems they reveal most often.

Sep 24, 20265 min read

Showing 1-9 of 10 articles