Search for a command to run...
Articles tagged with #software-development
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
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...