📝 Parottasalna Blog
248 practical articles on backend engineering, system design, databases, Docker, Python, AI and DSA, explained simply.
9 articles tagged #PostgreSQL · Clear filters
PostgreSQL Backups: Protecting Your Data Like an Architect
When you run a database, your data is everything. It powers your applications, analytics, and often, your entire business. Now imagine a sudden power…
Learning📊 Learn PostgreSQL in Tamil: From Zero to 5★ on HackerRank in Just 10 Days
PostgreSQL is one of the most powerful, stable, and open-source relational database systems trusted by global giants like Apple, Instagram, and Spoti…
Database Bootcamps🎯 PostgreSQL Zero to Hero with Parottasalna – 2 Day Bootcamp (FREE!) 🚀
Databases power the backbone of modern applications, and PostgreSQL is one of the most powerful open-source relational databases trusted by top compa…
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 #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 #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…
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…