Need a datastore for customer purchase history where records are immediately queryable, sortable on multiple fields, and support mixed record formats. Which storage fits?

Firestore in Native mode is ideal because it's a NoSQL document database, allowing for flexible, mixed record formats. Its real-time capabilities ensure immediate queryability, and it supports complex queries with multiple sort orders and filters, crucial for analyzing purchase history. Cloud Storage is object storage, not a database, and lacks query capabilities beyond simple object retrieval. Cloud SQL is a relational database, requiring a predefined schema, which conflicts with the need for mixed record formats. Firestore in Datastore mode is an older version with some limitations compared to Native mode, particularly in real-time updates and certain query features, making Native mode a more robust choice for this use case.