'uploading csv file to trigger firestore collection update
I'm trying to make a feature in admin panel (with React and Antd framework).
I currently have around 15000 ~ 20000 user info in a csv file. This csv file is regularly updated. Since I have a pretty huge list I was thinking of creating an upload feature where admin can upload the regularly updated csv file so it is transformed into JSON and only selected fields are stored to firestore. This means everytime I upload a new file, all 15000~20000 (26mb) data records are overwritten. Is it inefficient to create this kind of workflow? There's a chance that these data becomes larger so I can't possibly update them manually.
Can someone give me some advice on how to handle such situation.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|