News for hackers. Stuff that matters.
Re:Cloud Firestore: A New Document Database for Apps by paulsharratt on Wednesday October 04, 2017 @12:17AM (#15398213)
Good work guys, sounds like good progress!

I'm struggling to see what this is giving me that I didn't have with RTDB though

The queries seem to be doing what orderByChild equalTo startAt endAt limitToFirst and limitToLast were already allowing.

Is there mostly a performance gain, or am I missing something that I can do now that I couldn't do before?

Cheers

Re:Cloud Firestore: A New Document Database for Apps by paulsharratt on Wednesday October 04, 2017 @12:28AM (#15398253)
I'll answer myself here for anyone else trying to figure out what we can do with queries now:

---

We can now apply a filter and sort in the same command

We can chain filters, though they can only apply to one field if they specify a range

We can make a query that will only return documents, not the subfield data (i.e. what a lot of us were doing with the deprecated REST interface shallow=1)

Queries in large data sets will be faster I guess?

Things it'd still be nice to see -

References that allow you to pull down related documents with a single query

OR queries

---

It's been a bit of rollercoaster seeing this announcement..

"Oh wow we can do proper queries now! Oh wait no, the queries don't seem to allow more than what we had before.. oh wait there are some improvements, it's a bit better now.. oh the shallow querying will be super handy! and they do geopoints.. but don't appear to have any way of searching for radius.. but they say they will soon"

Anyway, good work all the same :)