PostgreSQL

16 articles · Page 2 of 2

Table comparing four transaction isolation levels and their protection against read anomalies

Database Transaction Isolation Levels Explained

A practical breakdown of read uncommitted, read committed, repeatable read and serializable: the anomalies each prevents and what they cost you.

Jun 6, 2022·5 min read

Database cluster diagram showing data distributed across multiple shards with a routing layer

Backend

Database Sharding Strategies and Trade-Offs

A practical guide to database sharding: partitioning strategies, shard key selection, cross-shard queries and the operational cost of distributing data.

Dec 4, 2021·5 min read

Diagram showing a connection pool managing multiple database connections between an application and database server

Backend

Database Connection Management in Production

How to configure and monitor database connection pools — covering pool sizing, leak detection, failover handling, and common misconfiguration pitfalls.

May 17, 2021·5 min read

SQL EXPLAIN output showing query execution plan with sequential and index scans

Backend

SQL Query Optimization: From Slow Queries to Fast Results

Practical techniques for identifying and fixing slow SQL queries using EXPLAIN plans, indexing strategies, and query restructuring patterns.

Dec 17, 2020·4 min read

View all articles