databases
Practical resources about databases for software engineers.
99 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.
How to Use Elasticsearch Aggregations (With Examples)
Use Elasticsearch aggregations for faceted search, metrics, and time-series analytics. Step-by-step...
Implement Event Sourcing in a Relational Database
Build event sourcing in a relational database. Store immutable events, project read models, and use...
Full-Text Search
How to implement full-text search with Elasticsearch, Meilisearch, and PostgreSQL.
CRUD Operations with MongoDB and Mongoose
How to perform Create, Read, Update, and Delete operations in MongoDB using Mongoose ODM with...
Optimistic Locking to Prevent Lost Database Updates
Implement optimistic locking with versioning to prevent lost updates. Examples in SQL, Node.js,...
PostgreSQL Query Optimization and Indexing Strategies
Analyze and optimize slow PostgreSQL queries using EXPLAIN, proper indexing, partial indexes, and...
Redis Cache Patterns for High-Performance Applications
How to implement cache-aside, write-through, and write-behind patterns with Redis to reduce...
Database Schema Evolution
Evolve database schemas safely with backward-compatible changes, versioned migrations, and online...
Seed Database
How to seed databases with realistic data for development, testing, and staging environments using...
Implement Soft Deletes in Databases with Python, JS and Java
Learn to implement soft deletes in databases. Practical examples in Python, JavaScript, and Java...
Find and Remove Duplicate Rows in SQL
Detect duplicate records in SQL tables using GROUP BY and HAVING, then remove them safely while...
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...
SQL Joins
Practical examples of INNER, LEFT, RIGHT, and FULL OUTER JOINs with real-world query patterns.
Zero-Downtime Column Rename Migration
Rename columns or change data types without locking tables by using views, triggers, and backfill...
Partition Large Tables by Date or Range
Split huge SQL tables into smaller partitions by date, range, or list to improve query performance...
Traverse Hierarchical Data with Recursive CTEs
Query tree-like or graph-like structures in SQL using recursive common table expressions to walk...
Rank Rows and Calculate Running Totals with Window Functions
Use SQL window functions to rank rows, compute running totals, and compare values within partitions...
Use ORM for CRUD
How to perform CRUD operations using ORMs in Python, JavaScript, and Java.
No results found.