Tag: databases
Browse 13 practical software engineering resources tagged with "databases". Discover code recipes, design patterns, documentation templates, and in-depth guides to help you build, deploy, and maintain production-ready solutions involving databases. Each resource is written for engineers who ship real systems, with copy-paste examples and practical trade-offs.
Database Engineering
Databases are the persistent heart of most applications. Choosing the right model, schema, indexing strategy, and consistency guarantees has outsized impact on reliability and cost.
The resources below cover SQL, NoSQL, indexing, sharding, replication, transactions, migrations, and query optimization. Each recipe helps you design and operate databases that scale with your workload.
Every resource includes clear explanations, copy-paste code, and practical warnings. Use them to make informed decisions, avoid production pitfalls, and speed up your delivery. If you are just getting started, read the beginner-friendly articles first; if you are experienced, jump straight to the advanced patterns and architecture guides. New resources are added regularly, so bookmark this page and check back for the latest patterns.
How to Use Elasticsearch Aggregations (With Examples)
Use Elasticsearch aggregations for faceted search, metrics, and time-series analytics. Step-by-step...
Node.js Caching with Redis: Cache-Aside and TTL Patterns
Cache API responses in Node.js with Redis using cache-aside and TTL patterns
Seed Database
How to seed databases with realistic data for development, testing, and staging environments using...
Set Up Full-Text Search Indexes
Configure full-text search indexes in PostgreSQL to query large text columns with ranking,...
Analyze and Optimize SQL Indexes with EXPLAIN
Identify missing, unused, and inefficient indexes by reading execution plans and measuring query...
Rank Rows and Calculate Running Totals with Window Functions
Use SQL window functions to rank rows, compute running totals, and compare values within partitions...
Real-Time Analytics: From Events to Dashboards in Seconds
A practical guide to real-time analytics: event collection, stream processing, data warehousing,...
ACID vs BASE — Consistency Models Explained
A practical guide comparing ACID and BASE consistency models: when to choose strong consistency,...
Database Denormalization
A practical guide to database denormalization: when to trade storage for read performance, common...
SQL CTEs: Common Table Expressions Explained
A practical guide to SQL CTEs: non-recursive and recursive expressions, readability, performance,...
SQL Joins — Visual Guide with Examples
A visual guide to SQL joins: INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF joins with practical...
Complete Guide to Serverless Databases
Choose and operate serverless databases for event-driven applications. Covers DynamoDB, Aurora...