ruvector/crates/ruvector-cli/sql
Claude f632b120e4 feat(hooks): Add PostgreSQL storage with JSON fallback
Add comprehensive PostgreSQL storage backend for hooks intelligence:

Schema (crates/ruvector-cli/sql/hooks_schema.sql):
- ruvector_hooks_patterns: Q-learning state-action pairs
- ruvector_hooks_memories: Vector memory with embeddings
- ruvector_hooks_trajectories: Learning trajectories
- ruvector_hooks_errors: Error patterns and fixes
- ruvector_hooks_file_sequences: File edit predictions
- ruvector_hooks_swarm_agents: Registered agents
- ruvector_hooks_swarm_edges: Coordination graph
- Helper functions for all operations

Storage Layer (npm/packages/cli/src/storage.ts):
- StorageBackend interface for abstraction
- PostgresStorage: Full PostgreSQL implementation
- JsonStorage: Fallback when PostgreSQL unavailable
- createStorage(): Auto-selects based on env vars

Configuration:
- Set RUVECTOR_POSTGRES_URL or DATABASE_URL for PostgreSQL
- Falls back to ~/.ruvector/intelligence.json automatically
- pg is optional dependency (not required for JSON mode)

Benefits of PostgreSQL:
- Concurrent access from multiple sessions
- Better scalability for large datasets
- Native pgvector for semantic search
- ACID transactions for data integrity
- Cross-machine data sharing
2025-12-27 01:27:12 +00:00
..
hooks_schema.sql feat(hooks): Add PostgreSQL storage with JSON fallback 2025-12-27 01:27:12 +00:00