Categories
APIs & server logic · 54 articles · Page 4 of 5
A practical breakdown of read uncommitted, read committed, repeatable read, and serializable isolation levels — with real examples of the anomalies each one prevents and the performance trade-offs involved.
A practical comparison of gRPC and REST for backend services — covering performance characteristics, developer experience, streaming capabilities, and the tradeoffs that determine which protocol fits your use case.
A practical guide to database sharding — covering partitioning strategies, shard key selection, cross-shard queries, and the operational complexity that comes with distributing data.
A hands-on guide to implementing GraphQL subscriptions for real-time updates — covering WebSocket transport, subscription resolvers, filtering, and scaling considerations.
Explore Redis data structures beyond simple strings — sorted sets for leaderboards, streams for event logs, HyperLogLog for cardinality, and bitmaps for feature flags.
Practical data modeling strategies for MongoDB and document databases — covering embedding vs referencing, denormalization tradeoffs, and schema evolution patterns.
How to configure and monitor database connection pools — covering pool sizing, leak detection, failover handling, and common misconfiguration pitfalls.
A deep dive into rate limiting algorithms with implementations, trade-offs, and guidance on choosing the right approach for your API.
Practical techniques for identifying and fixing slow SQL queries using EXPLAIN plans, indexing strategies, and query restructuring patterns.
Network failures mean requests are retried — idempotent API design ensures that processing the same request twice produces the same result, preventing duplicate charges and orders.
Every API evolves — the question is whether you version through URL paths, headers, or query parameters, and how you handle breaking changes without breaking clients.
Opening a new database connection per request is a silent performance killer — connection pools solve this with a managed set of reusable connections.