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