lite-sqlite
bởi omprasad122007-rgb
Coding Agents & IDEsTóm tắt
Fast lightweight local SQLite database for OpenClaw agents with minimal RAM and storage usage.
Mô tả
Kỹ năng này làm gì
Lite SQLite provides a local SQLite database layer for OpenClaw agents with low memory overhead (2-5MB typical). Supports in-memory and file-based modes, WAL mode, connection pooling, TTL-based caching, and automatic schema migration.
SQLite requires no server or configuration, making it faster to deploy for agent-local storage than alternatives like PostgreSQL or Redis.
Khi nào nên dùng
- Storing agent session logs between runs
- Caching API responses with expiry times
- Persisting agent memos and key-value state
- Logging structured metadata from multi-step agent tasks
- Migrating flat JSON or CSV files into queryable storage
Quy trình ví dụ
User asks: store and retrieve memos for an agent across sessions
- 1
Create a file-based SQLiteDB instance with WAL mode enabled
- 2
Create the agent_memos table with agent_id, key, value, and expires_at columns
- 3
Index agent_id and key columns for fast lookups
- 4
Insert a memo with a TTL using batch_insert or insert
- 5
Query memos by agent_id and key, filtering out expired rows
Memo records persisted to agent_data.db, retrievable by agent ID and key with automatic expiry handling
Cài đặt
clawhub install omprasad122007-rgb/lite-sqliteChạy lệnh CLI, hoặc dán prompt vào Claude Code, Cursor, Codex hay coding agent bạn đang dùng.