查询缓存策略指南：Redis、Memcached与数据库级缓存实现多级缓存优化

query-caching-strategies by aj-geddes/useful-ai-prompts

168 周安装量

162 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill query-caching-strategies

Node.js 数据库性能优化

🇨🇳中文介绍

查询缓存策略

概述

使用 Redis、Memcached 和数据库级缓存实现多级缓存策略。涵盖缓存失效、TTL 策略和缓存预热模式。

使用场景

查询结果缓存
高读取负载优化
降低数据库负载
提高响应时间
缓存层选择
缓存失效模式
分布式缓存设置

快速开始

最小工作示例：

// Node.js example with Redis
const redis = require("redis");
const client = redis.createClient({
  host: "localhost",
  port: 6379,
  db: 0,
});

// Get user with caching
async function getUser(userId) {
  const cacheKey = `user:${userId}`;

  // Check cache
  const cached = await client.get(cacheKey);
  if (cached) return JSON.parse(cached);

  // Query database
  const user = await db.query("SELECT * FROM users WHERE id = $1", [userId]);

  // Cache result (TTL: 1 hour)
  await client.setex(cacheKey, 3600, JSON.stringify(user));
  return user;
}

// Cache warming on startup
// ... (see reference guides for full implementation)

参考指南

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

指南	内容
Redis Caching with PostgreSQL	Redis 与 PostgreSQL 缓存
Memcached Caching	Memcached 缓存
PostgreSQL Query Cache	PostgreSQL 查询缓存
MySQL Query Cache	MySQL 查询缓存
Event-Based Invalidation	基于事件的失效
Time-Based Invalidation	基于时间的失效，LRU 缓存淘汰

🇺🇸English

Query Caching Strategies

Overview
When to Use
Quick Start
Reference Guides
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:

// Node.js example with Redis
const redis = require("redis");
const client = redis.createClient({
  host: "localhost",
  port: 6379,
  db: 0,
});

// Get user with caching
async function getUser(userId) {
  const cacheKey = `user:${userId}`;

  // Check cache
  const cached = await client.get(cacheKey);
  if (cached) return JSON.parse(cached);

  // Query database
  const user = await db.query("SELECT * FROM users WHERE id = $1", [userId]);

  // Cache result (TTL: 1 hour)
  await client.setex(cacheKey, 3600, JSON.stringify(user));
  return user;
}

// Cache warming on startup
// ... (see reference guides for full implementation)

Reference Guides

Detailed implementations in the references/ directory:

Guide	Contents
Redis Caching with PostgreSQL	Redis Caching with PostgreSQL
Memcached Caching	Memcached Caching
PostgreSQL Query Cache	PostgreSQL Query Cache
MySQL Query Cache	MySQL Query Cache
Event-Based Invalidation	Event-Based Invalidation
Time-Based Invalidation	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

Weekly Installs

126

Repository

aj-geddes/usefu…-prompts

GitHub Stars

126

First Seen

Jan 21, 2026

Security Audits

Gen Agent Trust HubPass SocketPass SnykPass

Installed on

opencode102

gemini-cli100

codex98

cursor96

claude-code93

github-copilot86