📝 Parottasalna Blog
248 practical articles on backend engineering, system design, databases, Docker, Python, AI and DSA, explained simply.
12 articles in Database · Clear filters
Effortless Data Storage with LocalBase and IndexedDB
IndexedDB is a powerful client-side database API for storing structured data in browsers. However, its API is complex, requiring transactions, object…
DatabaseLearning Notes #57 - Partial Indexing in Postgres
Today, i learnt about partial indexing in postgres, how its optimizes the indexing process to filter subset of table more efficiently. In this blog, …
DatabaseLearning Notes #51 - Postgres as a Queue using SKIP LOCKED
Yesterday, i came across a blog from inferable.ai https://www.inferable.ai/blog/posts/postgres-skip-locked , which walkthrough about using postgres a…
DatabaseLearning Notes #42 - Optimistic Lock and Pessimistic Lock | Postgres Locks
Today, I learnt about concurrency control on database from application level. Two widely used strategies to manage concurrency are optimistic locking…
DatabaseLearning Notes #41 - Shared Lock and Exclusive Locks | Postgres
Today, I learnt about various locking mechanism to prevent double update. In this blog, i make notes on Shared Lock and Exclusive Lock for my future …
DatabaseLearning Notes #35 - Durability in ACID | Postgres
As part of ACID series, i am refreshing on topic Durability. In this blog i jot down notes on durability for better understanding. What is Durability…
DatabaseLearning Notes #34 - Consistency (Correctness) in ACID | Postgres
As part of the ACID Series, i am refreshing on consistency. In this blog, i jot down notes on consistency (correctness) in postgres database. What is…
DatabaseLearning Notes #33 - Isolation in ACID | Postgres
This is a continuation of A CID Series. In this blog i jot down notes on Isolation in ACID for better understanding. Isolation is one of the core pro…
DatabaseLearning Notes #28 - Unlogged Table in Postgres
Today, As part of daily reading, i came across https://raphaeldelio.com/2024/07/14/can-postgres-replace-redis-as-a-cache/ where they discussing about…
DatabaseLearning Notes #21 - Sharding (database) with Postgres
…contd. Early Morning today, i watched a video on partitioning and sharding. In that video, Arpit explained the limitation of Vertical Scaling and wa…
DatabaseLearning Notes #20 - Partitioning (data) With Postgres
Early Morning today, i watched a video on partitioning and sharding. In that video, Arpit explained the limitation of Vertical Scaling and ways to in…
DatabasePostgres - Write-Ahead Logging (WAL) in PostgreSQL
Write-Ahead Logging (WAL) is a fundamental feature of PostgreSQL, ensuring data integrity and facilitating critical functionalities like crash recove…