I am building a chat app with Flutter. It works fine but I'm struggling to make a screen with previous conversations. Something like this:
In my Firestore model I have collections and documents based on user ids... For example userA-userB. This collection contains documents with timestamp as a name. Inside the document there is content which I'd like to show.
As a backend for my app I use MySQL. Would it be best idea to store recent conversation data in MySQL. Like userName, userAvatarUrl, date and content. And then show it... Or is it possible to do directly from Firestore schema shown in the picture above?

