Tanishk

PostgreSQLAdvanced

How PostgreSQL MVCC and VACUUM actually work

Every UPDATE in PostgreSQL leaves a dead row behind. Here's how MVCC works under the hood, what VACUUM cleans up, and how to keep autovacuum ahead of your workload.

#concurrency#internals#maintenance

SQL ServerAdvanced

Diagnosing deadlocks in SQL Server with Extended Events

Error 1205 again? Pull the deadlock graph from the system_health session, read it like a DBA and fix the access pattern that causes it.

#concurrency#locking#troubleshooting

SQL ServerBeginner

Clustered vs. nonclustered indexes in SQL Server

The single most important physical design decision in SQL Server, explained from first principles — with the queries to prove it.

#indexing#performance#schema-design

SQL ServerIntermediate

Transaction isolation levels in SQL Server, from READ UNCOMMITTED to SNAPSHOT

What each isolation level protects you from, what it costs, and why so many teams switch on READ_COMMITTED_SNAPSHOT.

#concurrency#locking#transactions

PostgreSQLIntermediate

EXPLAIN ANALYZE in PostgreSQL: reading plans without guessing

Learn to read PostgreSQL query plans node by node — estimates vs. actuals, loops, buffers — and turn them into index and query fixes.

#execution-plans#indexing#performance

MySQLIntermediate

InnoDB and the clustered primary key: why your PK choice matters

In MySQL's InnoDB, the table is the primary key index. That single fact shapes insert speed, index size and how you should pick primary keys.

#indexing#internals#schema-design

MongoDBBeginner

MongoDB schema design: embed or reference?

The core modeling decision in MongoDB, with simple rules of thumb for one-to-few, one-to-many and many-to-many relationships.

#data-modeling#nosql#schema-design

RedisBeginner

Redis caching patterns: cache-aside, write-through and TTLs

Put Redis in front of your database the right way — choose a caching pattern, set sane TTLs, and avoid stampedes and stale data.

#caching#nosql#performance

SQLiteIntermediate

SQLite in production: WAL mode and knowing when it's enough

SQLite can serve real production traffic. Here's how WAL mode changes concurrency, which PRAGMAs to set, and where the limits are.

#concurrency#internals#performance

Apache CassandraIntermediate

Data modeling in Cassandra: design for your queries

Forget normalization. In Cassandra you model one table per query, choose partition keys carefully and keep partitions bounded.

#data-modeling#nosql#schema-design

Oracle DatabaseIntermediate

What is New in Oracle’s Eighth Generation SPARC Systems

In this article, we will see what the newly launched Eighth Generation of Oracle SPARC platform has to offer.

GeneralBeginner

Introduction to OmniDB

OmniDB, the browser-based database manager, has had no release since 2020. See what it offered, the risks of still running it, and which tools replace it.