Question 1

How do I set up FireSQL for realtime updates?

Accepted Answer

Install rxjs and rxfire alongside firesql, import 'firesql/rx' in your code, and use the .rxQuery() method to get an observable. This lets you subscribe to live data changes as documents update in Firestore.

Question 2

Can FireSQL handle joins between Firestore collections?

Accepted Answer

No, FireSQL does not support JOIN operations. Since Firestore is a NoSQL database, you'll need to manage relationships manually, such as by denormalizing data or making separate queries.

Question 3

What's the performance impact of using FireSQL vs native Firestore queries?

Accepted Answer

For simple queries, FireSQL translates directly to single Firestore calls with minimal overhead. However, complex conditions like OR can trigger multiple queries, potentially increasing read costs and latency compared to optimized native methods.

Question 4

How to query nested objects in Firestore with SQL using FireSQL?

Accepted Answer

Use backticks around the field path in your SQL, like `details.stock`. FireSQL converts this to access nested fields in Firestore documents, making it straightforward to query deep object structures without custom code.

Question 5

Does FireSQL support pagination with OFFSET?

Accepted Answer

No, FireSQL's LIMIT clause doesn't support OFFSET; you can only limit the number of results. For pagination, you might need alternative approaches like using document IDs as cursors with native Firestore queries.

Question 6

FireSQL or writing raw Firestore queries: which is better?

Accepted Answer

FireSQL is better if you're comfortable with SQL and need expressive queries with features like aggregations or complex WHERE clauses. Native queries are preferable for performance-critical apps or when using Firestore-specific optimizations without abstraction layers.

Question 7

How to include document IDs in FireSQL query results?

Accepted Answer

Use the special field __name__ in your SELECT statement, or set the includeId option when creating the FireSQL instance or in the query method to alias the document ID, as shown in the README examples.

FireSQL

What is FireSQL?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions