Deep Backend Dive
Home
About
Archives
Database

Boost PostgreSQL Performance with Partial Indexes

IntroductionIn our backend application, we often include unnecessary rows in our database indexes, making them larger than they need to be. This...

Database

Building Custom Data Structures with Lua and Redis: A Practical Guide

Intro:Redis offers a variety of built-in data structures like sets and hash maps. But what if we want to combine them and create something even...

Database

The Truth Behind ‘SELECT *’ in SQL: Exploring the Benefits and Drawbacks

IntroWhen working with ORM frameworks, it’s typical for them to retrieve all columns by default, even when we only need a few. Similarly, using...

1

Recent posts

  • Boost PostgreSQL Performance with Partial Indexes
  • Building Custom Data Structures with Lua and Redis: A Practical Guide
  • The Truth Behind ‘SELECT *’ in SQL: Exploring the Benefits and Drawbacks

Archives

  • March 20251
  • July 20232

Categories

  • Database3

© 2025 Heydar Dasoomi