query-caching-strategies
Implement query caching strategies to improve performance. Use when setting up caching layers, configuring Redis, or optimizing database query response times.
By aj-geddes · 446 installs
npx skills add aj-geddes/useful-ai-prompts --skill query-caching-strategies
Source repository · Upstream listing
Query Caching Strategies
Table of Contents
[Overview]( overview)
[When to Use]( when to use)
[Quick Start]( quick start)
[Reference Guides]( reference guides)
[Best Practices]( best practices)
Overview
Implement multi level caching strategies using Redis, Memcached, and database level caching. Covers cache invalidation, TTL strategies, and cache warming patterns.
When to Use
Query result caching
High read workload optimization
Reducing database load
Improving response time
Cache layer selection
Cache invalidation patterns
Distributed cache setup
Quick Start
Minimal working example:
Reference Guides
Detailed implementations in the references/ directory:
Guide Contents
[Redis Caching with PostgreSQL](references/redis caching with postgresql.md) Redis Caching with PostgreSQL
[Memcached Caching](references/memcached caching.md) Memcached Caching
[PostgreSQL Query Cache](references/postgresql query cache.md) PostgreSQL Query Cache
[MySQL Query Cache](references/mysql query cache.md) MySQL Query Cache
[Event Based Invalidation](references/event based invalidation.md) Event Based Invalidation
[Time Based Invalidation](references/time based invalidation.md) Time Based Invalidation, LRU Cache Eviction
Best Practices
✅ DO
Follow established patterns and conventions
Write clean, maintainable code
Add appropriate documentation
Test thoroughly before deploying
❌ DON'T
Skip testing or validation
Ignore error handling
Hard code configuration values