Tag: #database
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 114 posts
Database MVCC & Isolation Levels Complete Guide 2025: Read Phenomena, Snapshot Isolation, SSI, PostgreSQL/InnoDB Internals
From Dirty Read to Write Skew, from Read Committed to Serializable Snapshot Isolation. A 720-line deep dive into the real behavior of each isolation level and the MVCC internals of PostgreSQL and InnoDB.
2026-04-15 · 19 min read #database#mvcc#isolation-level#snapshot-isolation#serializableClickHouse Internals Deep Dive — MergeTree, Vectorized Execution, Distributed Queries, Keeper (2025)
The analytics engine behind Cloudflare, Uber, Bloomberg, and Yandex — processing tens of trillions of rows daily. This post dissects ClickHouse from the ground up: columnar vs row storage, the MergeTree family (Replacing
2026-04-15 · 15 min read #clickhouse#olap#columnar#mergetree#analyticsDatabase Complete Guide — Internals, Indexes, Query Planner, Partitioning, Vector DB (Season 2 Ep 13, 2025)
Treat a database as nothing but "the place where SQL goes" and you stay junior forever. The internals of B-Tree, LSM-Tree, and Hash Index; how the query planner turns a query into an execution plan; the four transaction
2026-04-15 · 14 min read #database#postgresql#b-tree#lsm-tree#indexingClickHouse MergeTree — The Complete Guide to Columnar, Sparse Index, Part, and Materialized View (2025)
Everything about ClickHouse MergeTree — the physical layout of columnar storage, parts and granules and the sparse primary index, why ORDER BY matters so much, projections and skip indexes, real-time aggregation with mat
2026-04-15 · 23 min read #clickhouse#olap#columnar#mergetree#analyticsKubernetes Database Deep Dive 2025: Operator Patterns, HA Configuration, Backup/Recovery, Performance Tuning
K8s DB operations deep dive! CloudNativePG vs Percona Operator comparison, Primary-Replica automatic Failover, pgBackRest/Velero backup, WAL archiving, Connection Pooling (PgBouncer), resource tuning (CPU/Memory/IOPS), A
2026-04-13 · 20 min read #kubernetes#database#operator#cloudnativepg#perconaThe Complete Guide to Flyway -- Automating Database Migrations
A comprehensive guide to automating database migrations with Flyway. Covers installation, configuration, version control, CI/CD integration, and team collaboration strategies.
2026-04-12 · 14 min read #database#flyway#migration#sql#devopsThe Complete Guide to Database Fundamentals — SQL, Normalization, Indexes, Transactions, NoSQL
Everything about databases from SQL basics to normalization, index internals (B-Tree), transactions (ACID), NoSQL selection criteria, and query optimization.
2026-04-12 · 17 min read #database#sql#nosql#postgresql#mongodbSystem Design Fundamentals — Scalability, Availability, Caching, and Message Queues
Core concepts for designing large-scale systems. Horizontal/vertical scaling, load balancing, caching, message queues, database design, and the CAP theorem.
2026-04-12 · 17 min read #architecture#system-design#scalability#caching#message-queueRunning Databases on K8s -- Complete Guide to CNPG, Percona, Vitess, and Helm Charts
A comprehensive overview of running databases in Kubernetes environments. We compare CloudNativePG, Percona Operator, Vitess, and major Helm charts, and share practical operational know-how.
2026-04-11 · 15 min read #database#kubernetes#cnpg#postgresql#mysqlRunning Databases on Kubernetes Complete Guide: StatefulSet, Operators, Backup and Recovery
Everything about running DBs on K8s! StatefulSet vs Deployment, PV/PVC/StorageClass, DB Operators (CloudNativePG/Percona/MongoDB), Backup/Recovery (Velero/pgBackRest), Monitoring (PMM), HA/Failover, Performance Tuning, P
2026-03-24 · 17 min read #kubernetes#database#statefulset#operator#postgresqlDatabase Performance Tuning Complete Guide: Query Optimization, Index Strategy, Connection Pool Management
Everything about DB performance tuning! EXPLAIN ANALYZE interpretation, index design (B-Tree/GIN/BRIN), slow query analysis, connection pooling (HikariCP/PgBouncer), N+1 resolution, partitioning, read replicas, query cac
2026-03-24 · 22 min read #database#performance#tuning#indexing#query-optimizationSQL Mastery 2025: Developer Interview SQL — From JOINs to Window Functions and Query Optimization
Everything about SQL interviews! 7 types of JOINs, Window Functions (ROWNUMBER/RANK/LAG/LEAD), Subquery vs CTE, Index internals (B-Tree/Hash/GIN), EXPLAIN ANALYZE, Transaction Isolation Levels, and 30 practice problems.
2026-03-23 · 30 min read #sql#database#join#window-function#indexingDatabase Complete Comparison 2025: PostgreSQL vs MySQL vs MongoDB vs Redis — Selection Guide
Everything about database selection in 2025! PostgreSQL (JSONB+pgvector), MySQL (HeatWave ML), MongoDB (Atlas Vector Search), Redis (Stack/Search) — architecture, performance benchmarks, cost comparison, use-case selecti
2026-03-23 · 29 min read #database#postgresql#mysql#mongodb#redisBuild Your Own MCP Server: Protocol Internals, Hands-On Guide, and 100+ Ecosystem Deep Dive
Dissect how MCP (Model Context Protocol) works at the protocol level, build your own MCP servers with Python FastMCP and TypeScript SDK, and explore 100+ MCP servers across the ecosystem including Grafana, Mermaid, PPT,
2026-03-23 · 34 min read #mcp#model-context-protocol#mcp-server#fastmcp#typescript-sdkAWS Database Specialty (DBS-C01) Practice Exam — 65 Questions
AWS Certified Database Specialty (DBS-C01) practice exam with 65 questions covering all domains: RDS, Aurora, DynamoDB, ElastiCache, DocumentDB, and Neptune. Includes realistic migration and architecture scenarios.
2026-03-17 · 33 min read #aws#dbs-c01#database#aws-certification#rdsDatabase Engineering Complete Guide: From SQL to Vector DBs and AI RAG Systems
A comprehensive database engineering guide for the AI era — covering advanced SQL, pgvector similarity search, Pinecone, Redis caching, distributed systems theory, and building RAG pipelines with LangChain.
2026-03-17 · 18 min read #database#postgresql#vector-database#pgvector#ragDuckDB In-Memory Analytics and OLAP Guide
A guide to DuckDB in-memory analytics for OLAP workloads, covering query optimization, data formats, and integration patterns.
2026-03-15 · 28 min read #database#duckdb#olap#analytics#in-memoryRedis Cluster High Availability and Failover Guide
A practical guide to Redis Cluster high availability architecture, failover mechanisms, and production operations.
2026-03-14 · 20 min read #redis#database#high-availability#cluster#sentinelPostgreSQL Query Optimization and Performance Tuning Practical Guide: From EXPLAIN to Partitioning
A systematic guide to practical performance optimization techniques for PostgreSQL including EXPLAIN analysis, index strategies, VACUUM tuning, partitioning, and connection pooling.
2026-03-14 · 19 min read #database#postgresql#query-optimization#performance#indexingMongoDB Sharding and Replica Set Operations Guide: From Cluster Design to Troubleshooting
A deep dive into MongoDB distributed architecture essentials: Sharding and Replica Set operations. Covers shard key selection strategies, Replica Set failover, chunk migration, balancer management, backup/recovery, and m
2026-03-13 · 12 min read #database#mongodb#sharding#replica-set#cluster