Firestore schema design for nested objects

[5785...@gmail.com]

Hello there, 

since I would like to use Firestore in my next project app, I'm here to ask advices about schema.
My app lets users create their gym training programs and at the moment I built a local database (mobile app) where every program has an array of WEEKS, every week an array of DAYS and every day an array of EXERCISES. This way I can keep track of last training completed and let user continue with the next one.
With this schema in mind, in Firestore should be something like:

Programs (collection)

-Program1 (document)

--Weeks (collection)

---Week1 (document)

----Days (collection)

-----Day1 (document)

------Exercises (collection)

-------Exercise1 (document)

        Exercise2

        Exercise3

        .......

        .......

What do you think ?

As an alternative, I could use an object to represent a Program (with its weeks, days and exercises in it): maybe it would result in less read requests when a user wants to see the entire program but the risk is to exceed the max document size allowed.

Many thanks for any suggestion,

Alessandro

[Samuel Stern]

Hi Alessandro,

The schema you have suggested looks good, and it's probably the same suggestion I would have made.  The main consideration here is to consider your reading patterns.  Do you frequently need to load the entire Program at once?  If so this structure will not be efficient.  But if your app needs to load each piece of the program only in response to a new user action (maybe they click into a week first, then into a day, then into an exercise) then your structure will not result in many extra reads.

- Sam

--
You received this message because you are subscribed to the Google Groups "Firebase Google Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebase-tal...@googlegroups.com.
To post to this group, send email to fireba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/firebase-talk/e1c6b895-114c-45bf-9d3e-c33141a0db6b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[5785...@gmail.com]

Hi Samuel, 
thanks for spending your time helping me: I'm glad that you validated my model!
Kind regards

Alessandro

[Rodrigo Sol]

Hi There,

Is there any way to fetch the root document its subdocuments at once?

Thanks

--

You received this message because you are subscribed to the Google Groups "Firebase Google Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to firebase-talk+unsubscribe@googlegroups.com.

To post to this group, send email to fireba...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/firebase-talk/79da6187-f956-466a-966f-153005b0ebe9%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Rodrigo Sol


rod...@rarolabs.com.br
http://www.rarolabs.com.br
+5531 71718438

[5785...@gmail.com]

Hello Rodrigo, 

for what I red on documentation, I don't think it's possible and Samuel stressed it in his answer.

What's your schema? Maybe someone could give you an advise.

For example I was exploring the possibility to mix Firestore with Realtime database to satisfy my use case