DEV Community

Vahid Aghajani profile picture

Vahid Aghajani

404 bio not found

Joined Joined on 
Move the data to the compute, or the compute to the data?
vahid_aghajani_60ce9dbec9 profile

Move the data to the compute, or the compute to the data?

#systemdesigncost #programming #softwareengineering
Comments
6 min read
Why your index is ignored: expression indexes explained
vahid_aghajani_60ce9dbec9 profile

Why your index is ignored: expression indexes explained

#databasesindexing #programming #softwareengineering
Comments
4 min read
Design a Rate Limiter: The Four-Point Answer, and the Trap
vahid_aghajani_60ce9dbec9 profile

Design a Rate Limiter: The Four-Point Answer, and the Trap

#systemdesign #programming #softwareengineering #interview
1
Comments
10 min read
MCP vs API: Why Your Server Needs a /mcp Endpoint (and What You Actually Write)
vahid_aghajani_60ce9dbec9 profile

MCP vs API: Why Your Server Needs a /mcp Endpoint (and What You Actually Write)

#mcp #programming #ai #python
1
Comments
9 min read
RTO vs RPO: The Two Numbers That Decide What Disaster Recovery Costs
vahid_aghajani_60ce9dbec9 profile

RTO vs RPO: The Two Numbers That Decide What Disaster Recovery Costs

#systemdesign #programming #softwareengineering #devops
Comments
15 min read
Cache Invalidation: The Delete Ran, and the Page Is Still Wrong
vahid_aghajani_60ce9dbec9 profile

Cache Invalidation: The Delete Ran, and the Page Is Still Wrong

#caching #programming #softwareengineering #redis
Comments
17 min read
Continuous Integration vs Continuous Delivery: The Two Halves Almost Nobody Separates
vahid_aghajani_60ce9dbec9 profile

Continuous Integration vs Continuous Delivery: The Two Halves Almost Nobody Separates

#cicd #programming #softwareengineering
Comments
16 min read
Service Boundaries: Where Does the Line Between Two Services Actually Go?
vahid_aghajani_60ce9dbec9 profile

Service Boundaries: Where Does the Line Between Two Services Actually Go?

#architecture #programming #softwareengineering #systemdesign
1
Comments
13 min read
Validating Input at the Edge: Why Four Checks in Four Places Are Worse Than One Border
vahid_aghajani_60ce9dbec9 profile

Validating Input at the Edge: Why Four Checks in Four Places Are Worse Than One Border

#python #programming #softwareengineering #api
1
Comments
13 min read
Read Replicas Explained: How to Scale Database Reads Without Shipping a Time-Travel Bug
vahid_aghajani_60ce9dbec9 profile

Read Replicas Explained: How to Scale Database Reads Without Shipping a Time-Travel Bug

#database #programming #softwareengineering #systemdesign
1
Comments
10 min read
MVCC and VACUUM: Why Deleting a Million Rows Made Your Table Bigger
vahid_aghajani_60ce9dbec9 profile

MVCC and VACUUM: Why Deleting a Million Rows Made Your Table Bigger

#postgres #programming #softwareengineering #database
1
Comments
10 min read
What Is Middleware? The Onion Model, and Why the Order Is the Configuration
vahid_aghajani_60ce9dbec9 profile

What Is Middleware? The Onion Model, and Why the Order Is the Configuration

#middleware #programming #softwareengineering #webdev
1
Comments
12 min read
Design Search Autocomplete: The Four-Point Answer, and the Trap
vahid_aghajani_60ce9dbec9 profile

Design Search Autocomplete: The Four-Point Answer, and the Trap

#systemdesign #programming #softwareengineering #interview
1
Comments
9 min read
The Ring Buffer: Why a Queue With No Limit Is a Memory Leak (and What Happens When It Fills)
vahid_aghajani_60ce9dbec9 profile

The Ring Buffer: Why a Queue With No Limit Is a Memory Leak (and What Happens When It Fills)

#computerscience #programming #python #softwareengineering
Comments
15 min read
What Is a Webhook? The Same HTTP Request, With the Arrow Turned Around
vahid_aghajani_60ce9dbec9 profile

What Is a Webhook? The Same HTTP Request, With the Arrow Turned Around

#webhooks #programming #softwareengineering #api
Comments
9 min read
Read Committed vs Serializable: The Write-Skew Bug Your Default Isolation Level Allows
vahid_aghajani_60ce9dbec9 profile

Read Committed vs Serializable: The Write-Skew Bug Your Default Isolation Level Allows

#database #programming #softwareengineering #postgres
1
Comments
8 min read
Design a Web Crawler: The Four-Point Answer, and the \"Polite\" Trap
vahid_aghajani_60ce9dbec9 profile

Design a Web Crawler: The Four-Point Answer, and the \"Polite\" Trap

#systemdesign #programming #softwareengineering #interview
1
Comments
7 min read
How Safe Is a 60-Minute Signed URL? The Link Is the Credential
vahid_aghajani_60ce9dbec9 profile

How Safe Is a 60-Minute Signed URL? The Link Is the Credential

#security #programming #softwareengineering #aws
1
Comments
9 min read
Design a Notification System: The Four-Point Answer, and the Duplicate-Send Trap
vahid_aghajani_60ce9dbec9 profile

Design a Notification System: The Four-Point Answer, and the Duplicate-Send Trap

#systemdesign #programming #softwareengineering #interview
1
Comments 1
8 min read
Architecture Patterns: The Six Shapes a System Can Take (and Why They Are Not a Menu)
vahid_aghajani_60ce9dbec9 profile

Architecture Patterns: The Six Shapes a System Can Take (and Why They Are Not a Menu)

#architecture #programming #softwareengineering #systemdesign
Comments
9 min read
SLIs, SLOs and Error Budgets: How to Turn Reliable Enough Into a Number
vahid_aghajani_60ce9dbec9 profile

SLIs, SLOs and Error Budgets: How to Turn Reliable Enough Into a Number

#sre #programming #softwareengineering #devops
Comments
12 min read
HTTP Caching Explained: max-age, ETag and Why Your Users Still See Last Week's CSS
vahid_aghajani_60ce9dbec9 profile

HTTP Caching Explained: max-age, ETag and Why Your Users Still See Last Week's CSS

#webdev #programming #softwareengineering #performance
Comments
10 min read
Offset vs Cursor Pagination: Why LIMIT/OFFSET Breaks at Scale (and What to Use Instead)
vahid_aghajani_60ce9dbec9 profile

Offset vs Cursor Pagination: Why LIMIT/OFFSET Breaks at Scale (and What to Use Instead)

#database #programming #softwareengineering #sql
Comments
8 min read
Running LLMs Locally — Small Models, Quantization, and Your 4GB GPU
vahid_aghajani_60ce9dbec9 profile

Running LLMs Locally — Small Models, Quantization, and Your 4GB GPU

#llm #ai #machinelearning #programming
Comments
12 min read
Authentication vs Authorization: AuthN vs AuthZ (and Why 401 403)
vahid_aghajani_60ce9dbec9 profile

Authentication vs Authorization: AuthN vs AuthZ (and Why 401 403)

#llm #api #security #ai
Comments
6 min read
How AI Agents Do Deep Search — Building a Research Agent from Scratch
vahid_aghajani_60ce9dbec9 profile

How AI Agents Do Deep Search — Building a Research Agent from Scratch

#ai #python #machinelearning #programming
Comments
13 min read
PostGIS vs DuckDB — Choosing the Right Tool for Spatial Data
vahid_aghajani_60ce9dbec9 profile

PostGIS vs DuckDB — Choosing the Right Tool for Spatial Data

#database #postgres #sql #ai
Comments 1
11 min read
S3 vs Database Blobs: Why Your Files Don't Belong in Postgres (and What Pre-Signed URLs Fix)
vahid_aghajani_60ce9dbec9 profile

S3 vs Database Blobs: Why Your Files Don't Belong in Postgres (and What Pre-Signed URLs Fix)

#llm #rag #database #postgres
Comments 1
6 min read
Pub/Sub vs API Calls: Should Your Services Publish an Event or Just Call Each Other?
vahid_aghajani_60ce9dbec9 profile

Pub/Sub vs API Calls: Should Your Services Publish an Event or Just Call Each Other?

#api #ai #machinelearning #programming
Comments
5 min read
WMS vs WMTS vs WFS: A Picture, Fast Tiles, or the Raw Data (and When to Use Each)
vahid_aghajani_60ce9dbec9 profile

WMS vs WMTS vs WFS: A Picture, Fast Tiles, or the Raw Data (and When to Use Each)

#ai #machinelearning #programming
Comments
5 min read
Design a URL Shortener: the Four-Move Answer, and the 301 vs 302 Trap
vahid_aghajani_60ce9dbec9 profile

Design a URL Shortener: the Four-Move Answer, and the 301 vs 302 Trap

#systemdesign #programming #softwareengineering #interview
Comments
7 min read
Feature Flags vs Load Balancer: One Splits Versions, the Other Splits People
vahid_aghajani_60ce9dbec9 profile

Feature Flags vs Load Balancer: One Splits Versions, the Other Splits People

#featureflags #programming #softwareengineering #devops
Comments
8 min read
Chaos Engineering vs Load Testing: One Measures the Ceiling, the Other Measures the Floor
vahid_aghajani_60ce9dbec9 profile

Chaos Engineering vs Load Testing: One Measures the Ceiling, the Other Measures the Floor

#chaosengineering #programming #softwareengineering #devops
Comments
12 min read
Big-O Without the Maths: a Prediction, Not a Measurement
vahid_aghajani_60ce9dbec9 profile

Big-O Without the Maths: a Prediction, Not a Measurement

#algorithms #programming #python #computerscience
Comments
12 min read
View vs Materialized View: A Saved Question vs a Saved Answer
vahid_aghajani_60ce9dbec9 profile

View vs Materialized View: A Saved Question vs a Saved Answer

#database #programming #sql #softwareengineering
Comments
8 min read
Hot Keys in a Cache: Why One Key Saturates One Node While the Cluster Looks Idle
vahid_aghajani_60ce9dbec9 profile

Hot Keys in a Cache: Why One Key Saturates One Node While the Cluster Looks Idle

#caching #programming #systemdesign #softwareengineering
Comments
12 min read
Background Jobs Without a Broker: Your Worker Is Holding a Database Connection for 40 Minutes
vahid_aghajani_60ce9dbec9 profile

Background Jobs Without a Broker: Your Worker Is Holding a Database Connection for 40 Minutes

#postgres #programming #softwareengineering #backend
Comments
13 min read
Heaps and Priority Queues: The Array That Is Secretly a Tree
vahid_aghajani_60ce9dbec9 profile

Heaps and Priority Queues: The Array That Is Secretly a Tree

#datastructures #programming #softwareengineering #python
Comments
13 min read
Arrays vs Linked Lists: Why the Textbook Winner Loses on Real Hardware
vahid_aghajani_60ce9dbec9 profile

Arrays vs Linked Lists: Why the Textbook Winner Loses on Real Hardware

#datastructures #programming #computerscience #performance
Comments
10 min read
Processes vs Threads
vahid_aghajani_60ce9dbec9 profile

Processes vs Threads

#processesthreads #programming #softwareengineering
Comments
6 min read
Active-Active vs Active-Passive: You Had a Second Server, So Why Were You Down for 41 Minutes?
vahid_aghajani_60ce9dbec9 profile

Active-Active vs Active-Passive: You Had a Second Server, So Why Were You Down for 41 Minutes?

#systemdesign #programming #softwareengineering #devops
Comments
10 min read
Hash Tables Explained in Detail: Why a Dict Lookup Beats a List Scan by 62,000x
vahid_aghajani_60ce9dbec9 profile

Hash Tables Explained in Detail: Why a Dict Lookup Beats a List Scan by 62,000x

#python #programming #computerscience #datastructures
Comments
8 min read
Write-Through vs Write-Back Caching — Explained in Detail
vahid_aghajani_60ce9dbec9 profile

Write-Through vs Write-Back Caching — Explained in Detail

#caching #programming #softwareengineering #systemdesign
Comments
6 min read
Airflow vs Cron: When a Crontab Line Isn't Enough
vahid_aghajani_60ce9dbec9 profile

Airflow vs Cron: When a Crontab Line Isn't Enough

#airflow #programming #softwareengineering #devops
Comments
6 min read
25 Years of Object Detection in 4 Walls (Sliding Window YOLO DETR)
vahid_aghajani_60ce9dbec9 profile

25 Years of Object Detection in 4 Walls (Sliding Window YOLO DETR)

#computervision #programming #softwareengineering
Comments
5 min read
Ollama vs vLLM: Local Dev Tool or Production Inference Engine?
vahid_aghajani_60ce9dbec9 profile

Ollama vs vLLM: Local Dev Tool or Production Inference Engine?

#ollamavsvllm #programming #softwareengineering
Comments
3 min read
Autoscaling Explained: Why New Servers Always Arrive Two Minutes Too Late
vahid_aghajani_60ce9dbec9 profile

Autoscaling Explained: Why New Servers Always Arrive Two Minutes Too Late

#systemdesign #programming #softwareengineering #devops
Comments
8 min read
Debouncing vs Throttling: Only the Last Event, or the Ones in Between?
vahid_aghajani_60ce9dbec9 profile

Debouncing vs Throttling: Only the Last Event, or the Ones in Between?

#javascript #programming #webdev #performance
1
Comments
6 min read
Proximity Search: How \"Restaurants Near Me\" Doesn't Scan Every Restaurant
vahid_aghajani_60ce9dbec9 profile

Proximity Search: How \"Restaurants Near Me\" Doesn't Scan Every Restaurant

#database #programming #softwareengineering #systemdesign
Comments
6 min read
At-Least-Once vs Exactly-Once Delivery: Why the Customer Got Charged Twice
vahid_aghajani_60ce9dbec9 profile

At-Least-Once vs Exactly-Once Delivery: Why the Customer Got Charged Twice

#distributedsystems #programming #softwareengineering #systemdesign
Comments
7 min read
Chain of Thought — why 'think step by step' actually works
vahid_aghajani_60ce9dbec9 profile

Chain of Thought — why 'think step by step' actually works

#chainofthoughtprompting #programming #softwareengineering
Comments
5 min read
Quantization vs Distillation
vahid_aghajani_60ce9dbec9 profile

Quantization vs Distillation

#quantizationdistillation #programming #softwareengineering
Comments
4 min read
Distributed Tracing — how you find which service ate the 3 seconds
vahid_aghajani_60ce9dbec9 profile

Distributed Tracing — how you find which service ate the 3 seconds

#systemdesignobservability #programming #softwareengineering
Comments
6 min read
SQLite FTS5: How Full-Text Search Actually Works (Inverted Index + BM25)
vahid_aghajani_60ce9dbec9 profile

SQLite FTS5: How Full-Text Search Actually Works (Inverted Index + BM25)

#sqlite #programming #softwareengineering #database
Comments
6 min read
Next-Token Prediction: How an AI Actually Writes Text (Not Magic — Just Probability)
vahid_aghajani_60ce9dbec9 profile

Next-Token Prediction: How an AI Actually Writes Text (Not Magic — Just Probability)

#llm #programming #softwareengineering
Comments
5 min read
Speculative Decoding, Explained: Free LLM Speed With Zero Quality Loss
vahid_aghajani_60ce9dbec9 profile

Speculative Decoding, Explained: Free LLM Speed With Zero Quality Loss

#speculativedecoding #programming #softwareengineering
Comments
5 min read
Data Modeling Explained: From One Messy Table to a Real Schema
vahid_aghajani_60ce9dbec9 profile

Data Modeling Explained: From One Messy Table to a Real Schema

#datamodelingindataengineering #programming #softwareengineering
Comments
6 min read
GeoParquet Explained: Your Geodata Has Two Shapes (One You Edit, One You Scan)
vahid_aghajani_60ce9dbec9 profile

GeoParquet Explained: Your Geodata Has Two Shapes (One You Edit, One You Scan)

#gis #programming #softwareengineering #database
Comments
8 min read
Connection Pooling: Why Your API Dies at 200 Users (But the DB Is at 4% CPU)
vahid_aghajani_60ce9dbec9 profile

Connection Pooling: Why Your API Dies at 200 Users (But the DB Is at 4% CPU)

#database #programming #softwareengineering #backend
Comments
6 min read
Zero-Shot vs Few-Shot Prompting: Why Your LLM Output Keeps Breaking (and the 1-Minute Fix)
vahid_aghajani_60ce9dbec9 profile

Zero-Shot vs Few-Shot Prompting: Why Your LLM Output Keeps Breaking (and the 1-Minute Fix)

#promptengineering #programming #softwareengineering
Comments
4 min read
loading...