databases
Practical resources about databases for software engineers.
89 results
Storing, Querying, and Scaling Data
Databases are the persistence layer every application depends on. Choosing between relational and NoSQL, designing indexes, handling migrations, and optimizing slow queries are skills that directly impact user experience and infrastructure cost.
This section covers recipes for PostgreSQL and MySQL connections, MongoDB CRUD operations, Redis caching strategies, and schema design patterns. You will also find guides on ACID transactions, connection pooling, and full-text search implementation.
Lakehouse Architecture — The Best of Both Worlds
A practical guide to Lakehouse architecture: combining data lake storage flexibility with data...
Complete Guide to Redis Caching Strategies
Choose and implement the right Redis caching pattern — cache-aside to refresh-ahead — with...
Connection Pooling: Optimize Database Connections for Scale
A practical guide to database connection pooling: sizing pools, handling idle timeouts, detecting...
Data Migration: Zero-Downtime Strategies That Work
Plan, dual-write, backfill, and validate a zero-downtime data migration — with schema evolution...
Full-Text Search — Implement Search That Actually Works
A practical guide to full-text search: PostgreSQL tsvector, Elasticsearch indexing, query design,...
Read Replicas: Scale Reads Without Changing Your App
Production guide to database read replicas: streaming replication setup, read/write routing (app,...
ACID vs BASE — Consistency Models Explained
A practical guide comparing ACID and BASE consistency models: when to choose strong consistency and...
CAP Theorem and Database Trade-offs
CAP theorem explained for practitioners: CP vs AP trade-offs, PACELC, tunable consistency per...
Complete Guide to Database Sharding
Master database sharding: shard keys, partitioning strategies, consistent hashing, cross-shard...
Complete Guide to Elasticsearch Cluster Setup
Deploy and scale Elasticsearch clusters in production. Covers node roles, sharding, index...
Complete Guide to MongoDB Indexing
Choose the right MongoDB index for every query pattern: compound, text, geospatial, TTL, wildcard,...
Complete Guide to PostgreSQL Replication
Set up and operate PostgreSQL replication in production: streaming and logical replication,...
Complete Guide to PostgreSQL Tuning
Tune PostgreSQL for high throughput: server config, indexes, query plans, connection pooling,...
Complete Guide to Redis in Production
Keep Redis stable in production: RDB/AOF persistence, Sentinel vs Cluster for HA, memory...
Complete Guide to SQL Query Optimization
Find and fix slow SQL queries: read EXPLAIN plans, index the right way, kill N+1 queries, and apply...
Database Denormalization: Storage for Read Speed
A practical guide to database denormalization: when to trade storage for read performance, common...
Database Design Guide
A practical guide to designing relational databases with normalization, indexing, and relationship...
Database Normalization — 1NF to 5NF Explained
A visual guide to database normalization: learn 1NF through 5NF with practical examples, when to...
Database Replication — Primary-Replica, Multi-Primary
A practical guide to database replication strategies: primary-replica, multi-primary, synchronous...
Graph Databases — Neo4j and Property Graph Modeling
A practical guide to graph databases: property graph model, Cypher query language, modeling...
No results found.