Skip to content
Home » PostgreSQL

PostgreSQL

What is a Non-Repeatable Read Anomaly?

Non-Repeatable Read is a database anomaly that occurs in the context of transactions, which are sequences of database operations that should behave as single, indivisible units of work. Non-Repeatable Read happens when a transaction reads the same row twice, and gets different data each time. This is usually due to another transaction modifying the data after the first read. In this post, we look at this concept in detail and techniques to address this.

Understanding SQL Database Isolation Levels

Database isolation is a property that defines how and when the changes made by one operation become visible to other concurrent operations. Isolation is one of the ACID (Atomicity, Consistency, Isolation, Durability) properties.
In this post, we will look at 4 standard isolation levels along with some database-specific ones.

What is ACID in database systems?

ACID is a fundamental concept in database systems, standing for Atomicity, Consistency, Isolation, and Durability. These properties ensure reliable processing of database transactions. ACID Properties of Database Systems Atomicity Atomicity ensures that a transaction is treated as a single, indivisible… Read More »What is ACID in database systems?

Introduction to Indexing in Relational Databases

Indexing is a powerful technique in relational databases that enhances query performance by minimizing the time it takes to search and retrieve data. It’s similar to the way you use an index in a book to quickly find the page containing the information you seek. In this blog post, we’ll dive into the world of indexing, focusing on how it works in relational databases like PostgreSQL, and explore the benefits and trade-offs involved.