Dev Tools · 1h ago
OpenCode DB Bloat: 60% Empty Space After Deletions
A developer found that OpenCode's SQLite database grew to 1.3 GB, but only 525 MB was live data. SQLite retains deleted pages as freelist space, so the file doesn't shrink. The issue is common in agent tools that store heavy session history.
Meridian48 take
The story highlights a subtle SQLite behavior that can mislead developers into thinking their data is larger than it is, but it's more of a storage hygiene note than a crisis.
sqlitedatabase-optimization