Query limitations and workarounds in Firebase - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a common limitation of Firebase Firestore queries?

Firestore queries can only filter on indexed fields and support simple logical operations. Complex queries like OR across different fields or full-text search are not directly supported.

intermediate

Why can't Firebase Firestore perform 'OR' queries across different fields directly?

Firestore indexes each field separately and does not support combining multiple fields with OR logic in a single query, to keep queries fast and scalable.

beginner

What is a workaround for performing 'OR' queries in Firebase Firestore?

Run multiple queries for each condition separately and merge the results in your app code.

intermediate

How can you handle full-text search limitations in Firebase Firestore?

Use an external search service like Algolia or Elasticsearch, syncing your Firestore data to it for advanced search capabilities.

beginner

What is a limitation related to Firestore query result size?

Firestore limits query results to 1MB of data per query. Large datasets require pagination or filtering to reduce data size.

Which of the following is NOT a direct limitation of Firebase Firestore queries?

A Cannot perform OR queries across different fields in one query

B Cannot filter on non-indexed fields

C Query results limited to 1MB of data

D Cannot sort results

Firestore supports sorting query results, so option C is not a limitation.

What is a common workaround to perform OR queries in Firestore?

A Use a single complex query with OR logic

B Use SQL joins

C Run multiple queries and merge results in the app

D Use Firestore's built-in OR operator

Firestore does not support OR queries directly, so running multiple queries and merging results is the workaround.

How can you add full-text search capabilities to Firestore data?

A Use Firestore's native full-text search

B Use an external search service like Algolia

C Use Firestore's OR queries

D Use Firestore's array-contains-any filter

Firestore does not support full-text search natively; external services like Algolia provide this feature.

What happens if a Firestore query returns more than 1MB of data?

A The query fails or returns partial data

B The query compresses data

C The query returns all data without limit

D The query automatically paginates

Firestore limits query results to 1MB; exceeding this causes failure or partial data return.

Which field must be indexed to be used in Firestore queries?

A Any field used in filters or sorting

B Only fields with numeric data

C Only fields with string data

D No fields need indexing

Firestore requires indexing on any field used in filters or sorting for queries to work.

Explain the main query limitations in Firebase Firestore and how you can work around them.

Think about what Firestore can and cannot do with queries and how to handle those cases.

Describe how to implement full-text search for Firestore data despite its limitations.

Consider combining Firestore with specialized search tools.