Calculate running totals, rankings, and moving averages efficiently with SQL window functions.
Tag: design-patterns
Tips and Tricks #216: Apply Strangler Fig Pattern for Legacy Migration
Gradually replace legacy systems by routing traffic to new implementations incrementally.
Tips and Tricks #215: Implement Domain Events for Loose Coupling
Use domain events to decouple components and enable reactive architectures.
Tips and Tricks #189: Use Embeddings for Semantic Search
Implement semantic search using text embeddings for more relevant results than keyword matching.
Tips and Tricks #188: Use dbt for Maintainable Data Transformations
Build modular, tested, documented data transformations with dbt.
Tips and Tricks #187: Partition Large Tables for Query Performance
Use table partitioning to dramatically speed up queries on large datasets.