Module db 

SQLite database for caching scan and build results.

This module provides optimized database access with:

• Lazy loading to minimize memory usage
• Indexed reverse dependency lookups for fast failure cascades
• Normalized dependency tables for efficient queries
• Hybrid storage: columns for hot fields, JSON for cold data

Schema

• packages - Core package identity and status
• depends - Raw dependency patterns from scans
• resolved_depends - Resolved dependencies after pattern matching
• builds - Build results with indexed outcome
• metadata - Key-value store for flags and cached data

Structs

Database

SQLite database for scan and build caching.

PackageRow

Lightweight package row without full scan data.