Phase 2: Storage layer

[evansenter]

Summary

Implement SQLite persistence with schema for events, sessions, ingestion state, and patterns.

Tasks

• Implement SQLite schema with migrations
• Create storage.py with connection management
• Add ingestion state tracking table
• Write storage tests

Schema

-- events: Core denormalized event table
-- sessions: Session metadata
-- ingestion_state: Track processed files
-- patterns: Pre-computed insights

References

• Plan: ~/.claude/plans/precious-crunching-crescent.md (full schema)
• DB location: ~/.claude/contrib/analytics/data.db

[evansenter]

Completed in PR #19.