📝 Parottasalna Blog
248 practical articles on backend engineering, system design, databases, Docker, Python, AI and DSA, explained simply.
4 articles tagged #SQL · Clear filters
Have you been told "Use plain SQL, its faster than ORM" ?
You might have heard this advice before, Just use SQL; no need for ORMs. At first glance, that sounds elegant. SQL is expressive, close to the metal,…
Database ManagementPostgreSQL 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…
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 #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 …