How do queries work in Cloud Firestore? | Get to know Cloud Firestore #2

How do queries work in Cloud Firestore? What kinds of queries can you run, and what kind can't you run? And what are composite indexes, anyway? Find out the answers to all of these questions and more on this episode of Get to Know Cloud Firestore. Subscribe to the Firebase channel for more content like this and let us know what you think in the comments below!
Watch Get to know Cloud Firestore #1 → bit.ly/2ssnX7i
More episodes on Cloud Firestore → goo.gle/Cloud-Firestore
Subscribe to Firebase → goo.gle/Firebase

[@MartinRyleOShea]

The best tech evangelist of any tech company. This guy really knows his craft.

[@vaguebrownfox]

He really helps me calm down my anxiety to start a project.

[@Moelgaard85]

Best firestore video so far. Really calls a spade for a spade, talks about what you can do, what will be developed and what you can’t do. And many examples. Perfect. I am so tired of videos where everything is just perfect and avoiding the elephant in the room.

[@srolesen]

YES, this so much!!! so many realtime chat app guides pretending to have ANY useful features for real data usage.

[@GrumpyOldMan9]

He didn't explain how to enable a single composite index for multiple collections.

[@Mrdoctordiv]

Watching this in 2020 with the 2019 update added in.. this. This is quality content. I chose the right platform for my web app.

[@lesmo34]

ikr! I'm seriously troubled by the fact that it says it was published May 2018... you can either edit KZbin videos with some sorcery I don't know, or they have a perfectly nice roadmap way ahead in time... I don't know.

[@HieuNguyen-vk7ix]

@@lesmo34 I mean, FireStore belongs to Google, KZbin belongs to Google too. You know what I mean

[@MatthewChenIsAwesome]

@@HieuNguyen-vk7ix yeah. as of now, IIRC only Google can edit their own videos

[@rajpanchal9226]

@@HieuNguyen-vk7ix They should not do this tho its really dangerous, if suppose there's a really old video and someone describes newly found innovations in it the people who are the inventors of those innovations will have a hard time getting patents for those innovations. In fact if the tech in this video is patented by them in 2019 they might as well get into trouble.

[@lesmo34]

@Casuality videos edited in Creator Studio don't keep their original creation date ;)

[@prashantraghu8536]

Guys please make more such algorithmic videos explaining all the features in somewhat low level. This was simply amazing.

[@crazysoap05]

I don't think they are going to give their secrets away haha

[@OvenBakedCookie]

Todd is bloody amazing. The pacing, examples, emphasis, humour, enthusiasm, level of technical detail; he is the perfect software trainer.

[@DavidUngerMusic]

I love how Todd makes seemingly complex ideas easy to understand. Bravo!

[@jhadesdev9576]

Awesome video, probably the best i have seen on the topic, focuses on the Why and not the How, which is usually what gets overlooked in tutorials

[@quangquang4813]

I have been waiting too long for this episode. :(( This is a great video anyway

[@mgohds]

This is great series. You are doing great job explaining basic behavior and are charismatic in the process which is rare in this kinda videos. Playlists also sure help a lot. Keep up the good work :)

[@albertodeveloper347]

This teacher is VERY friendly!! thank you!! and now I go for vide #3 :)

[@chriscurnow143]

Seeing this video pop up on my alerts made my day. And actually watching it was just as much fun and just as informative as I expected it to be. So.... when's the next one coming??

[@zechcampbell]

Amazing explanations about what Firestore can and cannot do. Wish there were more resources like this.

[@JanM457]

I'm smashed by the fact that Ray's Restaurant scored over 4.5 stars just selling Radishes. What a guy!

[@mandisaw]

Brief, but insightful, and a good bridge for the folks coming from a relational DB background. Structuring data to suit Firestore's query capabilities is the key takeaway here - that should be mentioned in the description. It's easy to miss it thinking "ah, I know how to query" - I know I nearly did.

[@nldr_theunisdk]

The was super informative!! thanks! I am glad that there are more vids about the advanced features. You tend to miss them in the docs.

[@DRocksRecords]

Thanks, im starting to feel more confident about firestore as I watch.

[@nikhilenmudi2490]

Love you analogies and explanation style!

[@abc-yg6tk]

Excellent video. Entertaining, good pacing, explains the algorithms and the why and how. Learnt a lot in 15mins

[@PrashanthHN]

Nice! had been wondering about query efficiencies since a week and this explains it well!

[@BissoliR]

You guys should do a serie about Elasticsearch integration cause it seems a little frustrating not having this option til now. We need 'like' queries indeed.

[@brunodigiorgio1127]

Un capo Robin Williams

[@yashsoni1120]

he is so good at this and everything kind of makes sense now! thanks for the series!!

[@KnO1951]

Great presentation of the occasionally head-spinning content that you have made easy to consume. kudos!!

[@KamelJabber1]

LOVE THE UPDATE! thanks so much for that

[@scottieschneider1925]

Thank you so much for this! Really great information.

[@eliteeth4n]

More "Into the weeds" videos!

[@pasta0328]

You are an excellent teacher

[@Qoor1994]

Todd, you are amazing. Thank you for sharing your technical knowledge!

[@DiegoJaraPalomino]

This is great! Can't wait for the pagination video

[@kaibe5241]

hahaha, the time warps back to update the content is absolutely SUPERB! Bravo!!! *applauds*

[@munzilirrohmah6425]

Hi Todd. This is the most enjoyable tutorial video I've ever seen 😂 Easy to understand and hilarious at the same time

[@BaRzOmk]

Please more videos and Please explain more slower, feels like we are running from firestorm :)) And love all firebase videos... Thanks again...

[@MrRantelo]

We can no longer watch in 2x speed :(

[@IljaDidDevs2]

Would be awesome to have similar video done for security rules :)

[@marriagebureaufreematrimon5751]

really good information thank you

[@rammalvarez2664]

Very nice video! Thank you guys!

[@noamgonen6243]

love your technical jargon. Googling Giant Pain in the .... right now

[@27sosite73]

awesome one more perfectly structured video! top!!!

[@luundalite7962]

Watching in 2021 but no future guy from 2020 though. Great content. Amazingly intuitive.

[@OfferoC]

Awesome. Please continue to go in depth on fire store.

[@vinfragwarrior]

"the time it takes to run a query is proportional to the number of results, NOT the number of documents you're searching through" MY LIFE IS A LIE. This goes against everything I thought I knew hahaha

[@MrAlexMN]

Well done video, Thank you.

[@rawtale97]

Had to go through variouse tutorials before understanding how I should make a propper query for Firebase, I think there might be a lack of examples in the docs and also in this video.

[@Joyceview]

😂 Love it! Both the tech and the show!!!

[@josefsantamaria]

In your older videos you made an example of how to structure events with attendees etc it would be very helpful if you could make one of those with Firestore!

[@RossRawlins]

Great video.

[@andyfusniak]

Great video. As querying a collection automatically generates an index, this raises a whole bunch of questions... How can we see what indexes are in use? Does a one-off query cause an index to be built and maintained for the lifetime of a collection? What is the storage cost penalty for each index? Can we remove an index? Does having more indexes slow down document write speed, or are indexes eventually consistent?

[@Frank_van_Puffelen]

Wow, lots of great questions. I'll try to answer what I can quickly: 1) there is no way to see what indexes are used. But while it would be interesting to see the query plan, you can't affect it. No matter how you write the query, the indexes used will be the same. 2) If you don't need a composite index anymore, you can delete it from the console. 3) there is no charge for index storage. 4) yes, you can remove any composite index from the console 5) I haven't gathered any such performance metrics for this yet. I you get to them, I'd love to see the results.

[@davisyeung937]

Awesome video! It will be great if there is a detailed video explaining the suggested way of doing "full text searching" in firestore.

[@choibaksa85]

subtitle broken!

[@zensic]

Thank you! Very helpful!

[@AlexPaluzzi]

Please more videos like this. More code too. Would love to see some stuff from scratch.

[@1002CK]

Actually last three minute help a lottt

[@cyrilledakhlia3761]

Excellent content that makes it so fun to learn and makes me want to learn more about it! One of the best content I've seen! 👏👏

[@romualdbarbe1070]

Thanks a lot I'm waiting for the episode about searching in text :) Apparently we can do it with algolia, is there a way to perform a search with synonims ?

[@simbarashemaunga5575]

Great vid thanks

[@tomascarignano5002]

Superb documentation Firebase team!

[@TheGrafox]

Will done ... Very nice

[@greenhelix]

so exciting thanks

[@101nka]

These videos are so entertaining

[@musicandoutdoors]

Agreed with the comments, this video taught me to fish instead of giving me a fish. I understand much better now

[@townheadbluesboy]

keep them coming

[@cutiko]

The indexing link works like a charm.. except while using multiple accounts. Yes, it is an edge case and would dismiss it normally but I start to get tangled with this because in my new gig they made a mail account for me, which I have to use for the project. So when copy/paste the link, it doesn't work because is by default grab my main account. I'm doing a work around on this by pasting the link on an incognito tab or opening it in another browser.

[@Balaji-qx3ul]

Best with play speed of .75 :) excellent tutorial.

[@Elyx0]

Subtitles are messed up from the 2019 update!

[@osmanmusse9432]

great mentor

[@bazoozoo1186]

this guy is hidden gem

[@TheTiagoslater]

excellent video

[@ME-oe9gq]

watching this in quarantine

[@connorflewitt8377]

Todd is such a great presenter!

[@codewithtae6637]

According to the docs, you can do "OR" queries. At the time of this writing, the "OR" query is in "preview".

[@thedevguild7525]

Wow did they update the video? I understand it is posted in 2018 but in 2:11, todd mentioned/"joke" it is the year 2019

[@MrRousina]

Lol I am just wondering the same, like was that in the original video or is it updated somehow xd

[@davidpui4675]

How do you create a denormalized query output which can be populated from different nest collections ? Also can you also join results from different nested collections from different Firestore Projects ?

[@NicoloZanetti]

I can't say that I fully understood the difference between an equality and inequality search, I got an idea, but I wouldn't be sure about what I would code. If I start from the Restaurant in S. Francisco (iii), and then I Zig to the Japanese one with the same id (iii), and then the next Japanese one (ttt) which sends me back to the ones in S. Francisco (ttt), how can I be sure that I haven't skipped some in the S. Francisco list between iii and ttt? This would assume that the Japanese restaurants are also sorted by City, but with other fields and possibly changes happening is this really always true and reliable? Did I just describe that it could be an "inequality" search where there's no certain relationship between the order of the two fields?

[@PlayerHeader]

same question here

[@littleElmimo123]

I wish I’d watched this first

[@jasonsebring3983]

i keep wondering when this will have full text search and geo search otherwise you can scale with mongo and elastic and they work better but ive found also needings joins with mysql so you need many dbs for the task at hand and this aint it yet

[@nickadams2361]

wow this guy rocks

[@raghav4296]

Wow, Indeed a great video!! Since there is no full text search supported as mentioned 6:30 isn't it a common use case for most apps, as in this case, the user may not type the restaurant name correctly all the time.Any simpler way of doing this other than hooking up a elastic search/Algolia?

[@UsmanAli-ox3mn]

Overloaded.... I have to watch this multiple times.... still good video

[@PlayerHeader]

i love todd he's the best

[@PlayerHeader]

Ahh now I understand it 10:45. If we have this indexes for zip code, which is a string, then firebase puts in to the index table all zip codes side by side (groups them) and orders them by their doc_id, so that aaa is the first and xxx the last. But if we have some stuff like the avg_rating, and do > or

[@Nevalkar_]

Please google, raise the salary of this guy. He makes me laugh in every video and his knowledge is very deep. Congrats!

[@joaocoelho2929]

Raul Heredia don’t worry, he makes enough

[@rubencg195]

When are the OR, IN, CONTAINS and other similar conditions going to be available? It really limits the usability of the platform.

[@paulmacfarlane6089]

A little bit late on this, but an "or" condition can now be accomplished using the "in" query operator, and specifying the potential alternatives in an array (although right now they limit it to 10 possibilities). From the docs: citiesRef.where('country', 'in', ['USA', 'Japan']); you can also use array-contains-any citiesRef.where('regions', 'array-contains-any', ['west_coast', 'east_coast']);

[@PlayerHeader]

9:30 - I don't understand why this ain't working but the example with San Franciso and Japanese is working at 8:40

[@tranquillityEnthusiast]

How can we order the document by time

[@activewire-play7109]

Just a question, the composite index is a string and we are checking for a number comparison. is that a right example?

[@tobiabocchi9102]

Thank you Edward Alderson, aka mr Robot

[@rasulbc]

thanks for telegram notification sound on 0:16

[@wadexyz]

nice plants

[@locusm]

This series could be updated and have its own playlist

[@locusm]

Ah - some dude dropped in with an update :)

[@azka9075]

what do you mean when you said we are limited to 200 of these things during the collection group query limitations part, do you mean we can only create 200 collection groups at most?

[@jazelleanncapuli8346]

how can you query timestamp? or date? any help appreciated.

[@aungkhant502]

Update: != query on a single field is now supported since Sept 2020.

[@yeeen123]

Is the collection grp query feature alr in?

[@afghanapp3242]

Now I know how important Data structures and Algorithms have been.

[@BissoliR]

When you come from an Oracle PL/SQL background and find your self trying to do some advanced queries and sometimes even simple ones you will be very frustrated.. hahaha

[@thedevguild7525]

Hi Todd, may i ask how is the index/ document id created/name? 5:44 Please correct me if i am wrong, I believe that how indexing work is create individual tables for each field name e.g. address - 1 table and crusine - 1 table. 9:48 Within each table is the value and its location

[@albertarthur5745]

assited me to work on research

[@johnbalvin5401]

11:26 great avance as it's ancestor datastore cloud.google.com/datastore/docs/concepts/queries#datastore-datastore-basic-query-go that would requires and index.yaml that was a little pain in the butt

[@sasimarian142]

Is there any number of composite indexes limitation?

[@imatricepte94]

damn that video is so good it anwsers all my questions ! how come the complexity of a nosql database does not depends on the number of elements we are searching through ?

[@imatricepte94]

well my question has been answered immediately in the video lmao

[@joshuaoba2526]

At 2:50 , when you say “ 200 of this things “ do you mean 200 Collection group queries or 200 Documents to search through per Collection group query or 200 results per Collection group query