Model Relational Data in Firestore NoSQL 

Oops, meant to say "no greater than 1MB" at 1:10 - I hope this gives you some ideas for basic relational modeling in Firestore, but there are more advanced techniques that I will cover in the future.

This is perhaps the only channel where I watch in 1x and pause often.

I am a Spanish speaker and I appreciate your speech clarity and the knowledge of this channel. Thank you so much.

Hands-down best video series on Angular and Firebase! Keep up the Firestore videos! We'll definitely need it since it's still in beta.

For anyone watching this in Feb 2019 and following along, there is no more "object" field for the documents. It's now called "map".

Jeff, you make learning more fun for me. Thanks

of all modeling videos, this one is the best. Thank you so so much!

Great video Jeff, thank you! This was an excellent topic to cover. It confirmed what I already learned from talking to you in Slack, and gave me some extra insight.

Awesome videos man, simple and straight to the point! Keep it up

Exactly the information I needed. The user -> tweets model is applicable to so many other applications.. like stores -> products. Which is how this helped me resolve my data structure. Thanks!

6 years old and it still helped me plan out the structure for my project. Thank you!

I just started working with databases and found firebase and your videos make understanding it so much easier and quicker. Great work!

Actually taught me NoSQL and Firestore at the same time. Amazing videos as usual.

OMG, seeing this for the first time in my life to try to do something using flutterflow and firestore. Glad to finally see some noSQL stuff (I'm VERY SQL oriented for over 20 years using relational databases).

Still useful today. Wow your videos have come far, and so has your voice!

Your content is super awesome! Maybe you could one day do a video on how to get data from firestore to datastudio, I bet it would be incredibly useful not only for me. Keep it like that.

Always a very good content by the way. Thanks for sharing. I am a very satisfied Pro Member and highly recommend it to all.

That's a great introduction to the NoSQL mindset thanks you

The best explaination on Data modeling in Firestore👏👏

Nice and helpful tutorial and hard to find one like this addressing data modeling specifically for firebase! But I have to watch at 0.5 speed to fully understand the content lol!

Great explanation mate. Just what I needed.

I just watch your half of your videos because of the voice combined with the background jingle :P no joke, love them

Hands down the best RU-vid channel for coding

Hey Jeff, great video. Why don't you use the 'reference' data type? for a user document rather than creating a new field?

Wow I just implemented this approach using exactly the same method for a similar situation. I had problem with Firebase9 since I couldnt nest the likes inside a document inside a post So I decided to do take the easier approach and I was hoping the I didnt ruin my project. But after I watched your suggested video I feel 100x more confident about it. Thanks alot ❤️❤️

Exactly what i needed, thank you. Realized that I should just go with a SQL db

finally i understand now how the noSQL work. thank for your awesome video.

5:20 It is now possible to make queries across collections and subcollections with the same name using collection group queries.

I agree, one of better videos that explains how to apply relational techniques to Firebase. This is what SQL developers are looking for to come over to Firebase.

thanks, answered really well the question, how we solve complex situations in noSql .... by yourself !

Hey, What about lookup tables? How will you model those with firestore ?

how would you get all tweets along with up to date user data such as user name and age not just user id ... like joins in sql

G’day, a noob query: @7:00 - There was a mention to check if an user has hearted a post by checking whether the document exists for userid_tweetid. Doing this operation at scale, wouldn’t it easily consume lot of GET requests?Would it be a better alternative to write the hearted tweet id per user basis to Firestore and sync the same in realtime back to the client so that the client always have the list of tweets thus making the check locally than to reach the server?

easy to understand. good job!!

Damn... this channel is A+ class.

No one can beat you sir

Hi Jeff, for the trick mentioned in 7:20 - Does a firestore call to check if the user has liked a post need to be made for every tweet he views? Will this not exponentially increase the read costs?

whaou!!! wath a nice topic on a nice video, thanks

Hi, I'm new to coding. Are these videos good for people trying to build a firebase database in Swift?

awesome as always

Jeff, you are awesome!!!

great Video .. Thanks from Germany Leonardo

awesome video bro, thank you very much

It would be helpful to see examples of typical queries. How would we get the tweets a specific user has liked? All of the tweets liked by that user? The tweets of user A that were liked by user B? I think I understand the concepts here but it hasn't quite clicked in my mind. Probably I just need to try some of these exercises myself.

Did collection group queries made the part about the tweets obsolete?

Eu estava com duvidas quanto a construção dos relacionamentos, foi de grande ajuda esse video. (I was in doubt as to the construction of the relationships, this video was very helpful.) - Follower of Brazil

Hey, one question tho. I understand why we normalized the structure so that we can query all the tweets in a single day if we want to. But what about if the user wants to see all of his tweets? Are we looking at some data duplication in this case?

I'm building an app with Angular and Firebase but would like to learn as much about Firebase (noSql) data modeling first. Any resources you can point me to. Thanks!

Hi, this was a nice intro video for me. Do you plan to make longer video tutorials on this Firebase topic?

at 7:10 .. Does that mean we will need to make a document id for each user with a specific tweet? that a huge data

episode 63? is this part of some series? if so where can I find the full series or playlist?

Not an Angular guy but i use Firestore often this is truly amazing thanks alot

Bro you deserve a subscribe!

6:52 How do you get the user info from 'tweets' collection if there's no join? example output will be: USER ONE - 'User tweet this one.' , USER TWO - 'This is other tweet from this user'

Great explaination

3:34, you can now actually do this! Firebase is really growing and allows you to defined those queries.

7:16 will using a composite id of the User and Tweet lead to issues involving hotspotting? "Avoid high read or write rates to lexicographically close documents" - Firestore best practices doc. I'm currently in the process of implementing some backend logic that uses this idea, but I'm concerned that this idea won't work in the long run.

this guy is on speed

thank u it helps me a lot

Early in the video OP showed creating a document with userId and instructorId properties and claimed this was many-to-many. That's not mtm it's just two foreign key references from the same document to two documents in presumably the same collection. Maybe what OP meant to do was make the userId property and array of userId? Does firebase support multiple indexable values for a single field like elasticsearch?

How do you model the data if you want to show only the tweets tweeted by users you follow?

Thank you keep it up! Any hints on when geofiltering will be available? :)

Does it work the same way in Datastore in google cloud?

Hi Jeff, wondering if it is better using userId as the "Document ID" for "tweets" and any other collection related to the user. This way you can use: /user/{userId} to show user information /tweets/{userId} to list every users' tweets /following/{userId} to list every followed user /followed/{userId} to list every user following the user

At 6:12 it is stated that we can return tweets by multiple users and then at 6:20 it is stated that we can also scope a query to a specific user. My question is... is it possible to scope the query to multiple users (a friend list), lets say an array or user ID's?

Does the size of my db change the response time? Or has Google abstracted it enough to not make a difference?

I remember we use this technique with Firebase Realtime Database before Firestore and i can't see any news except modification on query code, any way thank you a lot for your tutorials.

Nice explanation

NoSQL feels so primitive compared to relational dbs. I quite like its simplicity but do feel uneasy by the lack of relations

Do you know of any technique to reduce the number of document reads when querying a collection of posts? currently working on an app and it seems wasteful that just strolling through a paginated profile of a user can cause upwards of 100 reads when you have many posts.

Thank you so much bro I was lost

I am so surprised that this is the same way that i was thinkink to use firestore database😁

Wow loved it

Great tutorial! Can you please post a tutorial for 2 cascade dropdown list with array object thank you very much

I thought you'd demonstrate the use of 'reference' field type... any thoughts on that? Keep up the great work! :)

Is there any ways to check the size of the document?

So how would you get a list of tweets a user hearted?

great video

Amazing!!

Is you??😳 5 yrs back ur voice 🤐🔥❤️

RU-vid recommends me this video while I am working on a Firestore implementation in Android. I wonder if they can view my PC.

Very good job explaining this. but one thing for sure it doesn't need to be in 9 mins

does this create lot of document read and the cost will be pricey

I dont get, that wont scale if you assign ID manually

Can firebase auto generate object id (let say userID) for me, or i have to type it down manually. I know that firebase can create the key ID but how can i get that ID and put it in other object?

Great video! Keep it up! :)

So, if I am creating a quiz app, and I in the end want to query what the average score of ALL users are, I basically have to have my questions as a root document, and add users ID's to each questions answer as an array? I.e. Question 1 > Option A > User 1, User 2, User 3. Then Question 1 > Option B > User 4, User 10, User 101. Then Question 2 > Option C > User 1, User 3, User 101. Or am I missing the point here? Really struggling with how to design a database where I can store users answers to the questions, but not only that, storing which question each user bookmarked for later review, and also make it possible for users to see statistics per chapter, counts of bookmarks per chapter/total questions, correct answers per chapter/total questions etc.

const ref = db.collection('assign'); ref.where( 'email', '==', user.email ) How to compare assign.email and user.email in this case ? I want user.email to become a variable that changes from user to user that will display only the email that match.

new to firebase..... dose it increase read and write count...or increase billing

What if a user changes profile pic, so when loading the tweets, for each tweet we have to make a query to the user collection to get the profile pic? If I am pulling 50 tweets, I will potentially make 50 additional queries to fetch users later username and profile pic with the current Firestore limitations. Any efficient way of achieving this?

Awesome video +++++++++++++ 😃

I am working on a project where videos will be displayed and users will be able to comment on videos. How will be the relational database for it on firestore.

amazing

@Fireship why not putting hearts collections under each user ? With and object {tweetId1 : true, tweetId558: true}. I would kindly like to know if this can cause issue or not ? Because liked tweets are linked to the users, so creating a collections under users/${userId} make sense no ? Instead of having it outside create the need to link it. And has you said even if the collections is big it's not a problem (if the user like tons of tweets should not be an issue). Cloud functions triggered where like or unlike will work the same for total count.

At 8:03 you said "at episode 63" which video is it

Can someone link me the video that is episode 63 that is referenced please :)

Hi, I just purchased Pro membership. But I cannot see member login section on your site? But I can access Pro member content. Could you tell me how that happened?

you are awesome

I am not getting how to reach out to you on slack

Thanks ... Most cases is shopping cart ... Can you make structure and queries for that in the future ... Thanks again