Logging Re-Architecture & Disaster Recovery (Quanted, UK)Logging Re-Architecture & Disaster Recovery (Quanted, UK)

Cut logging-infrastructure costs 80% and removed cluster overhead for 5 GB/day of logs by retiring Elasticsearch and building a lightweight full-text search and trace-correlation engine on SQLite FTS5 and FastAPI. Achieved a validated 24-hour RPO and 2-hour RTO for Supabase/PostgreSQL through a nightly automated dump-and-restore pipeline that strictly verifies schema, role, and sequence integrity.