Tag: #database
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 114 posts
PostgreSQL 18 Upgrade and Tuning Guide 2026
PostgreSQL 18 Upgrade and Tuning 2026: A practical guide covering Why, How, When, comparison tables, troubleshooting, code examples, and quizzes.
2026-03-04 · 12 min read #database#2026-03PostgreSQL Index Tuning Patterns 2026
PostgreSQL Index Tuning Patterns 2026 - A Practical Application Guide Based on 2026 Standards
2026-03-04 · 25 min read #database#postgresql#2026-03Complete Guide to Redis Caching Strategies — 6 Practical Patterns from Cache-Aside to Write-Behind
Covers 6 Redis caching strategies (Cache-Aside, Read-Through, Write-Through, Write-Behind, Refresh-Ahead, and Cache Stampede prevention) with code examples.
2026-03-03 · 9 min read #database#redis#caching#cache-aside#write-throughPostgreSQL Partitioning Complete Guide: Range, List, Hash Strategies and Performance Optimization
Learn how to dramatically improve the performance of large tables using PostgreSQL declarative partitioning. Covers Range, List, and Hash partitioning strategies along with partition pruning and automated management.
2026-03-03 · 21 min read #database#postgresql#partitioning#performance#query-optimizationMongoDB Sharding Complete Guide: From Shard Key Design to Operational Automation
Hands-on practice with MongoDB Sharding architecture and shard key strategies. Covers Range/Hashed/Zone Sharding, chunk splitting and balancing, and operational considerations through practical exercises.
2026-03-03 · 8 min read #database#mongodb#sharding#nosql#distributed-systemsPractical Guide to Redis Cluster Setup and Operations — Sharding, Replication, and Failover
Covers everything needed for Redis Cluster operations — from architecture to 6-node cluster setup, hash slots, automatic failover, and resharding — with practical code examples.
2026-03-03 · 31 min read #database#redis#redis-cluster#sharding#high-availabilityPostgreSQL Partitioning Practical Guide
Covers PostgreSQL Range/List/Hash partitioning methods, partition pruning, automation strategies, and operational tips with practical examples.
2026-03-03 · 24 min read #database#postgresql#partitioning#2026-03N+1 Problem Deep Dive — The Silent Performance Killer in ORMs
What the N+1 problem is, why it is dangerous, how to find it, and how to fix it. A complete guide with practical code covering solutions across all ORMs including Django, SQLAlchemy, JPA/Hibernate, Prisma, and ActiveReco
2026-03-02 · 10 min read #database#n-plus-1#orm#django#sqlalchemySQL Practical Cheatsheet — Complete Reference for Everyday Commands
From SELECT, UPDATE, INSERT, DELETE to subqueries, window functions, CTEs, index strategies, and execution plan analysis. All the SQL patterns you use daily in one place. Copy and use right away.
2026-03-02 · 36 min read #database#sql#mysql#postgresql#selectPostgreSQL + pgvector Vector Search Practical Guide: From RAG to Hybrid Search
Implement vector similarity search with the PostgreSQL pgvector extension. Covers installation through HNSW/IVFFlat indexes, hybrid search (vector + full-text search), and RAG pipeline integration with practical code.
2026-03-02 · 9 min read #postgresql#pgvector#vector-search#embedding#ragPostgreSQL Performance Tuning Practical Guide — Query Optimization, Index Strategy, EXPLAIN Analysis
A hands-on guide to the core of PostgreSQL performance tuning. Covers how to read EXPLAIN output, index strategies, query optimization patterns, and configuration tuning with practical code examples you can apply immedia
2026-03-02 · 11 min read #database#postgresql#performance#sql#indexingDataBase Engineering Section 2 ACID
Fundamentals of Database Engineering Section 2 ACID
2024-03-22 · 1 min read #databaseHow to Install MongoDB on Ubuntu 22.04
How to install MongoDB on Ubuntu 22.04
2023-07-07 · 1 min read #database#mongodbCMU Advanced Database Systems
CMU Advanced Database Systems
2023-07-03 · 1 min read #database