数据库与存储
sqlite-local-caching
更新于 2026-09-22
SQLite · 缓存规则
Caching rules for SQLite: explicit invalidation owners, versioned keys and stampede protection.
- 技术栈
- SQLite
- 主题
- 缓存
- 条目
- 9 条
- 版本
- v0.2.0
✓ 应当这么做
- ✓ Name the invalidation owner for every cache entry
- ✓ Version cache keys so a deploy can invalidate without a purge
- ✓ Protect against stampedes with single-flight or jittered expiry
✕ 常见反模式
- ✕ Caching data whose correctness depends on user-specific authorisation without scoping the key
- ✕ Infinite TTLs with no owner
- ✕ Treating the cache as durable storage
◎ 交付前验证
- ◎ EXPLAIN on the hot queries shows no sequential scan regression
- ◎ Migration rehearsed on a production-size snapshot
- ◎ Rollback path executed at least once in staging
同分类条目
26 篇数据库与存储
PostgreSQL 工程规则
Zero-downtime PostgreSQL rules: expand/contract phases and concurrent index builds
数据库与存储
MySQL 工程规则
MySQL rules: online DDL awareness, lock timeouts and reversible migrations
数据库与存储
Redis 工程规则
Redis rules: explicit TTLs, versioned keys and stampede-safe misses
数据库与存储
MongoDB 工程规则
MongoDB rules: explicit schema validators and index-backed query shapes
数据库与存储
ClickHouse 工程规则
ClickHouse rules: partition pruning, column ordering and batch inserts
数据库与存储
Elasticsearch 工程规则
Elasticsearch rules: alias-based reindexing and mapping compatibility