Tag: backend

All the articles with the tag "backend".

Featured
What Database Indexes Actually Do (And Why Your Queries Are Slow Without Them)
What a database index really is under the hood, why queries crawl without one, and how to create, inspect, and reason about indexes in PostgreSQL and MySQL. Covers B-trees, composite indexes, EXPLAIN output, and when an index actually hurts.
Kavindu ManaharaAug 22, 2026database, postgresql
Featured
What Database Replicas Actually Do (PostgreSQL, MySQL, MongoDB)
How database replication actually works under the hood, with real streaming replication, binlog/GTID, and replica set examples from PostgreSQL, MySQL, and MongoDB. Covers replication lag, sync vs async, and elections.
Kavindu ManaharaAug 21, 2026database, postgresql
Featured
Why In-Memory Databases Exist (And Why Everyone Reaches for Redis)
What an in-memory database actually buys you over Postgres or MySQL, with real Redis examples for caching, leaderboards, and rate limiting. Also covers the 2024-2026 Redis license drama and where Valkey, Dragonfly, and Garnet fit in.
Kavindu ManaharaAug 20, 2026redis, databases
Featured
Why Your Database Needs Transactions (And How to Actually Use Them)
What database transactions are, why they exist, and how to use them in plain PostgreSQL, MySQL, and Prisma. Covers ACID guarantees, isolation levels, rollbacks, and interactive transactions with real code.
Kavindu ManaharaAug 19, 2026database, postgresql
Featured
Stop the Flood: Rate Limiting Your NestJS API the Right Way
Why rate limiting matters for any production API, and how to add it to a real NestJS application. Covers the built-in throttler, a custom Redis-backed guard for AI endpoints, and a Python script to actually verify it works.
Kavindu ManaharaAug 8, 2026nestjs, backend