Module maintenance 

Database Maintenance Utilities for SQLite

Provides utilities for SQLite maintenance operations.

Overview

SQLite maintenance operations:

• VACUUM: Rebuilds database file, reclaims space
• ANALYZE: Updates statistics for query planner
• Statistics: Provides insights into database health

Usage Example

use oxify_storage::{MaintenanceService, MaintenanceConfig};

let config = MaintenanceConfig::default();
let maintenance = MaintenanceService::new(pool, config);

// Run maintenance
let results = maintenance.run_maintenance().await?;
println!("Maintenance completed");

// Get database size
let size = maintenance.get_database_size_mb().await?;
println!("Database size: {} MB", size);

Structs

IndexBloatInfo

Index bloat information (simplified for SQLite)

MaintenanceConfig

Maintenance configuration

MaintenanceResults

Maintenance results

MaintenanceService

Maintenance service for database upkeep

TableStats

Table statistics (simplified for SQLite)