I'm developing an app to help on events how much sales a single event has done and some other features that doesn't matter directly to the problem. So, I've done an attempt to use Firestore to save my data, but something is saying to me that I was using the wrong way. Every event has something around 2k ~ (20k ~40k) entries of sales entries. Firebase Realtime Database doesn't seem a good idea because of data duplication needed for the relations I need to create. The most important part of the Techstack I'm using:
- React Native
- React Native Firebase (native solution for react native on firebase)
- Redux
The problem is that whenever I try to retrieve those documents for, let's say a custom report for my clients, the app just crashes or freezes entirely. Talking to other developers, they said to me that maybe Firestore is not a good solution for my case because of this 'sort of' big data retrieving.
Structure
Organizations/organization_id
- Org_name
- members (Array of userIds)
Events/event_id/
- Event Name
- Event sales data (Array)
- Event product list (Array)
- Event Date
- Event attendees (Array of Attendees (name, pin (int))
- Organization name
I've checked also that Firestore has a limit of 20k registries or entries per document (something like this). A friend of mine who have more experience told me that an SQL database an a normal API would probably solve the problem, but maybe require more work as I am a single developer.
Do you think that Firestore is a good solution and I was probably using the wrong way?
Or would say that Firestore is not the case for this problem where I would have to save and retrieve data with such relationships?
