Topic
Postgresql
Learn Postgresql as a connected topic across chapters, concepts, simulations, and interview reasoning.
10 Concepts8 Articles3h 34m
Overview
Learn Postgresql as a connected topic across chapters, concepts, simulations, and interview reasoning.
How this topic helps
Databases
System Design
Distributed Systems
Sql
Learning Path in this Topic
Series that contain articles from Postgresql. Select a path to filter the article list.
Articles
8 matched articles
Article 1How CDC Works Across Databases: PostgreSQL, MySQL, MongoDB, and BeyondA data engineering team at a fintech company built what they believed was a robust Change Data Capture pipeline: three source databases (PostgreSQL, MongoDB, and Cassandra), Debezium connectors wired 37 minArticle 2SQL Partitioning: Range, Hash, List, and Composite Strategies ExplainedTLDR: SQL partitioning divides one logical table into smaller physical child tables, all accessed through the parent table name. The query optimizer skips irrelevant child tables entirely — a process 25 min
Article 3ACID Properties Explained: How SQL Databases Guarantee Atomicity, Consistency, Isolation, and DurabilityTLDR: ACID is four orthogonal guarantees that every SQL transaction must provide. Atomicity says all-or-nothing: PostgreSQL implements it via WAL rollback; MySQL InnoDB via undo logs. Consistency says38 minArticle 4Azure Cosmos DB API Modes Explained: NoSQL, MongoDB, Cassandra, PostgreSQL, Gremlin, and TableTLDR: Cosmos DB's six API modes are wire-protocol compatibility layers over one shared ARS storage engine — except PostgreSQL (Citus), which is genuinely different. Every API emulates its native datab24 min
Article 5Sharding Approaches in SQL and NoSQL: Range, Hash, and Directory-Based Strategies ComparedTLDR: Sharding splits your database across multiple physical nodes so no single machine carries all the data or absorbs all the writes. The strategy you choose — range, hash, consistent hashing, or di29 min
Article 6Isolation Levels in Databases: Read Committed, Repeatable Read, Snapshot, and Serializable ExplainedTLDR: Isolation levels control which concurrency anomalies a transaction can see. Read Committed (PostgreSQL and Oracle's default) prevents dirty reads but still silently allows non-repeatable reads, 28 minPage 1 of 2