didericis/bot-bottle
1
0
Fork 0
Code Issues 11 Pull Requests 7 Actions Packages Projects Releases Wiki Activity

Add SQLite-backed local storage for queue and audit state #319

New Issue
Open
opened 2026-07-01 12:52:51 -04:00 by didericis-codex · 0 comments
didericis-codex commented 2026-07-01 12:52:51 -04:00
Collaborator
Copy Link
Copy Source

Summary

Add a stdlib SQLite storage layer for bot-bottle local runtime state, starting with the supervise queue and audit log. This also gives forge-native work a shared storage foundation instead of adding one-off persistence in PR #318.

Acceptance criteria

  • Supervise proposals and responses are persisted through SQLite instead of JSON files.
  • Audit entries are persisted through SQLite instead of JSONL log files.
  • Existing public supervise helpers keep their current call shape where practical so sidecars and CLI callers do not need a behavioral rewrite.
  • The implementation stays stdlib-only and keeps the existing sidecar queue mount contract working.
  • Unit tests cover queue round-trips, pending discovery, response waits, archive semantics, and audit round-trips.
## Summary Add a stdlib SQLite storage layer for bot-bottle local runtime state, starting with the supervise queue and audit log. This also gives forge-native work a shared storage foundation instead of adding one-off persistence in PR #318. ## Acceptance criteria - Supervise proposals and responses are persisted through SQLite instead of JSON files. - Audit entries are persisted through SQLite instead of JSONL log files. - Existing public supervise helpers keep their current call shape where practical so sidecars and CLI callers do not need a behavioral rewrite. - The implementation stays stdlib-only and keeps the existing sidecar queue mount contract working. - Unit tests cover queue round-trips, pending discovery, response waits, archive semantics, and audit round-trips.
didericis added the Kind/Feature label 2026-07-01 12:59:31 -04:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Compat/Breaking
Breaking change that won't be backward compatible
 Kind/Bug
Something is not working
 Kind/Documentation
Documentation changes
 Kind/Enhancement
Improve existing functionality
 Kind/Feature
New functionality
 Kind/Security
This is security issue
 Kind/Testing
Issue or pull request related to testing
Priority
Critical
1
The priority is critical
Priority
High
2
The priority is high
Priority
Low
4
The priority is low
Priority
Medium
3
The priority is medium
Reviewed
Confirmed
1
Issue has been confirmed
Reviewed
Duplicate
2
This issue or pull request already exists
Reviewed
Invalid
3
Invalid issue
Reviewed
Won't Fix
3
This issue won't be fixed
Status
Abandoned
3
Somebody has started to work on this but abandoned work
Status
Blocked
1
Something is blocking this issue or pull request
Status
Need More Info
2
Feedback is required to reproduce issue or to continue work
No Label Kind/Feature
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
didericis-claude (didericis (claude)) didericis-codex (didericis (codex)) didericis-gemma (gemma) didericis
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: didericis/bot-bottle#319
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?