I have two distinct collections stored within my Firestore database.
The first collection is users, and it can be visualized as shown here:
https://i.stack.imgur.com/AKlyM.png
The second collection is posts, represented by the following structure:
https://i.stack.imgur.com/fVvI8.png
In my database setup, I am storing a reference to the user document within each post entry. Whenever I retrieve a particular post, I also want to fetch detailed information about the respective users. However, the current implementation requires me to perform additional operations like the one depicted below:
const [userPosts, setUserPosts] = useState([]);
useEffect(async function () {
if (initialized && user) {
let snap = await firebase.firestore().collection('posts').where("author", "==", firebase.firestore().collection('users').doc(user)).get();
let docs = snap.docs.map(doc => doc.data());
for (let i = 0; i < docs.length; i++) {
let doc = docs[i];
docs[i] = { ...doc, author: (await doc.author.get()).data().email }
}
setUserPosts(docs);
}
}, [user]);
This method proves to be inefficient since it necessitates fetching the user document for every post individually.
Would you recommend a more efficient approach?