Treat Firestore as a cache, not source of truth for scalable apps

Using Firestore as the primary database leads to weak transactions and costly migrations. One developer proposes treating it as a read-optimized cache backed by Cloud SQL, with a reconciliation job to ensure consistency. This pattern enables realtime updates while maintaining transactional integrity.