Unverified50% confidenceFactExact time
SQLite's Checkpoint operation has four modes: PASSIVE, FULL, RESTART, and TRUNCATE.
1
Sources
50%
Confidence
Long-term
Relevance
8/14/2026
First Seen
Sources
Tailscale溯源：SQLite一个16年历史的WAL重置Bug
Related Claims
UnverifiedSQLite 3.37.0（2021年11月）引入了 STRICT 表模式，启用后列只能存入与声明类型完全匹配的值，支持 INT、INTEGER、REAL、TEXT、BLOB、ANY 六种类型75% similarUnverifiedSQLite的NUMERIC亲和性采用级联降级策略：先尝试解析为整数，失败则尝试浮点数，仍失败才原样保留为文本70% similarVerifiedSQLite's WAL (Write-Ahead Logging) mode is a concurrency control mechanism introduced in 2010 with SQLite 3.7.0.70% similarUnverifiedSQLite supports enabling page-level checksums via the compile-time option SQLITE_CHECKSUM.70% similar
Cite This Claim
Stable URI
https://kongchang.com/claim/748073API
curl https://kongchang.com/api/v1/knowledge/claims/748073MCP
get_claim(id=748073)