Databases
Time-Series Databases: When to Reach for One
When a time-series database earns its place over a general-purpose one, and what you give up in exchange for the speed it buys you.
3 min read
Tag
Data Modeling
5 articles
Databases
MongoDB Schema Design Principles That Hold Up in Production
Schema design principles for MongoDB that hold up under real query patterns, not just the ones that look clean in a demo.
3 min read
Databases
CTEs and Recursive Queries: Solving Hierarchies in SQL
How common table expressions clean up nested subqueries, and how recursive CTEs turn hierarchical data into a solvable SQL problem.
3 min read
Databases
Normalization vs Pragmatic Denormalization
When strict normalization protects you, when it just adds joins, and how to denormalize deliberately instead of by accident.
3 min read
Databases
Table Partitioning Strategies That Actually Pay Off
A comparison of range, list, and hash partitioning strategies, when each one earns its operational complexity, and when it's premature.
3 min read