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

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.

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

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

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

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

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

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 :)

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

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

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??

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.

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

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

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

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

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.

Love you analogies and explanation style!

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

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

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.

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

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

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

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

Thank you so much for this! Really great information.

LOVE THE UPDATE! thanks so much for that

Un capo Robin Williams

You are an excellent teacher

More "Into the weeds" videos!

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

subtitle broken!

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

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.

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

Very nice video! Thank you guys!

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

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

awesome one more perfectly structured video! top!!!

Thank you! Very helpful!

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

Superb documentation Firebase team!

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

really good information thank you

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

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! 👏👏

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?

Well done video, Thank you.

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

These videos are so entertaining

"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

so exciting thanks

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!

Subtitles are messed up from the 2019 update!

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

Great video.

Actually last three minute help a lottt

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 ?

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.

Will done ... Very nice

great mentor

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 ?

Great vid thanks

Todd is such a great presenter!

excellent video

watching this in quarantine

On my website, it opens with all the items in the database being show. So would it be best to query the data base for the data the user wants and then re-import what that are filtering for, or to import the whole database when the website loads then filter it on a button click using javascript? Sorry if this is a dumb question, I'm new to web development and the whole thing is extremely confusing. Also, I'm using react and redux with firestore. Is this going to be efficient enough to build a website, or should I be using a different stack?

keep them coming

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

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

this guy is hidden gem

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

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

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

Does anyone know if these querying algos and creating index for each field (even mapings) exists in mongodb? Or how different is cloud firestore from mongodb?

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

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?

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?

I read that Firebase stores its offline data in SQLite. Is it possible to do a full text search against this local data or do I need to sync it to a secondary SQLite file to query against? Or is there a better way? The data set is about 100K varchar 100 in size and I need to be able to search "%STR1%" AND "%STR2%" #AskFirebase.

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?

Great walk through, however, my dashboard brings up Datastore (not Firestore) where I can add "entities"; I want to use Firestore and create collections and docs. I have clicked on every dev and admin option and still end up in the same place. What went wrong??

In Kotlin, how can I save a document that contains an enum and then read it back? I'm able to save, but reading it back crashes the app.

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

How come the OR (||) operator doesn't work like stated in 8:03 but when using the "in" operator like where("someProp", "in", ["value1", "value2"]) works in firestore?

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

Is the collection grp query feature alr in?

How about querying a single document. How does that work when separating between document snapshot Id and document id, it fails to find document because the passed id is document Id while it finds document snapshot id.

I wish I’d watched this first

How can we order the document by time

In my app, user can search by name, order by stock or price (asc/desc), filter by category, brand, color, size... timestamp in such case do i have to create 64 (subset of 6) composite indexing? for all the scenarios, where search can be include or not filter can be done or not, timestamp sorting will always be there other sorting can be done or not? its getting very frustrating to achieve this, better to use some other database.

How order by a field which potentially not exist in firestore ? (Can we put a default value in this situation ?)

i love todd he's the best

Is there a way to request the document with the highest value, given a collection?

Composite index link is not working in my Android app And if I add the index manually it just do not works It keeps saying firestore error, index required Also note that I'm using firestore ui

Is there any number of composite indexes limitation?

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

nice plants

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

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

wow this guy rocks