Search for a command to run...
Efficient pagination is absolutely critical when dealing with millions of rows in PostgreSQL — especially if you care about performance, index usage, and UX for APIs or UI pages. 1. OFFSET/LIMIT Pagin
When you’re running PostgreSQL with 100M+ rows, the difference between “it works” and “it flies” is all about tuning—but not the generic, copy-paste advice you get everywhere. Here’s the advanced, bat
Imagine this: Your high-traffic app is humming along smoothly. Most data requests are being served instantly from Redis or other, blazing-fast cache layer. But then — a cache key expires, and within milliseconds, 10,000 clients hit your backend at on...
In this post, I’ll walk you through how I built a semantic similarity search API using FastAPI, Sentence-BERT (SBERT), and PostgreSQL with the pgvector extension.This project began as a proof of concept (POC) to explore how seamlessly we can integrat...
If you’re indexing huge, append-only tables with naturally ordered data — BRIN can give you massive performance and space benefits compared to B-Tree. What is a BRIN Index? BRIN = Block Range Index A BRIN index doesn't index every row, unlike B-Tree....
When working with high-concurrency workloads in MongoDB, understanding how locking and concurrency control work is essential to maintain performance and data integrity. Here’s a quick overview of the core ideas: Key Highlights: Document-Level Lockin...
Over the past few months since the start of new year, I’ve been actively interviewing for technical roles, and each conversation proved to be both challenging and rewarding. In this post, I’ll share some of the SQL questions I was asked, along with d...
In Go programming, the context package is widely used to manage deadlines, cancellations, and other request-scoped values across API boundaries and go-routines. It provides a standardised way to pass contextual information and control the lifecycle o...
In every application development process, we often encounter scenarios where entities share common attributes while also possessing unique characteristics. We manage these parent-child-like relationships between entities using inheritance logic in ou...