Python FastAPI Dependency Injection vs Global Singletons for Database Sessions
In FastAPI, create database sessions per request through a dependency, and keep only the engine or connection pool as a shared object. A single global session...
Search
50 results for "Connection Pool"
Go Gin Context Timeouts and Cancellation Propagation to Databases
In a Gin handler, pass c.Request.Context() to every database and outbound call, and wrap it with context.WithTimeout to enforce a deadline. When the client...
Python Asyncio TaskGroup vs Gather for Concurrent API Calls
Concurrent request fan-out introduces failure coordination problems that sequential code rarely exposes. TaskGroup offers structured task ownership and...
Secrets Rotation Strategy for Application Credentials Without Downtime
Quick answer: rotate secrets without downtime by letting two credentials be valid at the same time. Create the new credential, roll it out to every consumer,...
DNS TTL Strategy for Failover and Migration Planning
Quick answer: a DNS TTL tells resolvers how long they may cache an answer. Before a planned migration, lower the TTL at least one old-TTL period ahead of the...
Nginx Upstream Keepalive Connections for High Traffic APIs
Direct answer: Reusable upstream connections can reduce repeated connection setup. Select an approach based on the service's required behavior and a realistic...
PostgreSQL Advisory Locks vs Row Locks for Background Jobs
Direct answer: Row locks protect existing records under transactional guarantees. Choose an implementation based on verifiable correctness, realistic...
PostgreSQL Row Level Security for Multi Tenant Applications
PostgreSQL Row Level Security for Multi Tenant Applications affects both query behavior and the reliability of applications that depend on stored data. A...
Designing Asynchronous REST APIs for Long Running Jobs
Designing Asynchronous REST APIs for Long Running Jobs requires careful engineering once an API handles real traffic, client retries and concurrent state...