Tag: postgresql

All the articles with the tag "postgresql".

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 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