Database Connection Pooling Explained
A practical guide to database connection pooling for Postgres and Node.js. Pool sizing, timeouts, PgBouncer, serverless pitfalls, and real numbers.
Server-side development, APIs, databases, and building robust backend systems.
A practical guide to database connection pooling for Postgres and Node.js. Pool sizing, timeouts, PgBouncer, serverless pitfalls, and real numbers.
A practical guide to designing idempotent API endpoints. Covers idempotency keys, HTTP semantics, storage patterns and the edge cases that usually bite first.
A practical guide to API versioning strategies, from URL paths and headers to semantic versioning, with real-world examples and trade-offs.
Learn when and how to use background jobs and task queues. Practical patterns for reliable async processing in modern web applications.
Learn when and how to use WebSockets for real-time features, with practical patterns for connection management, scaling, and common pitfalls.
A practical guide to choosing the right database for your project, comparing relational, document, key-value and graph options with clear criteria.
British Summer Time starts today. If your code stores local times, you probably have a bug. Here is how to handle time zones properly.
Practical guide to designing database schemas that scale cleanly, covering normalisation, denormalisation, naming and common mistakes.
A practical guide to API rate limiting. Covers algorithms, implementation patterns, response headers, and best practices for resilient APIs.