uncaged/nerve
Archived
10
0
Fork 0
Code Issues 5 Pull Requests Actions Packages Projects Releases Wiki Activity

feat(daemon): _signals table retention policy #152

New Issue
Closed
opened 2026-04-27 05:34:19 +00:00 by xiaomo · 0 comments
xiaomo commented 2026-04-27 05:34:19 +00:00
Owner
Copy Link
Copy Source

Background

PR #150 introduced auto-persist signals to per-sense SQLite DB (_signals table). Currently the table grows unbounded.

Problem

Long-running senses (e.g. cpu-usage at 5s interval) will accumulate rows indefinitely, eventually impacting disk usage and query performance.

Proposal

Add a retention mechanism, e.g.:

  • Max rows: keep last N rows per sense (e.g. 10,000), prune on insert or periodically
  • TTL: delete rows older than X (e.g. 7 days)
  • Configurable: let sense config specify retention field

Simplest first step: periodic DELETE FROM _signals WHERE timestamp < ? in the worker loop.

Ref

## Background PR #150 introduced auto-persist signals to per-sense SQLite DB (`_signals` table). Currently the table grows unbounded. ## Problem Long-running senses (e.g. `cpu-usage` at 5s interval) will accumulate rows indefinitely, eventually impacting disk usage and query performance. ## Proposal Add a retention mechanism, e.g.: - **Max rows**: keep last N rows per sense (e.g. 10,000), prune on insert or periodically - **TTL**: delete rows older than X (e.g. 7 days) - **Configurable**: let sense config specify `retention` field Simplest first step: periodic `DELETE FROM _signals WHERE timestamp < ?` in the worker loop. ## Ref - PR #150
This repo is archived. You cannot comment on issues.
No Branch/Tag Specified
Branches Tags
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
aobing jiashuang (Jia Shuang) jiayi (Jiayi) luming scottwei tuanzi xiaoju xiaomo xiaonuo xingyue
No Assignees
1 Participants
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: uncaged/nerve#152
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?