I'm currently working on a React Application with Firebase that involves a ton of data manipulation and reading. One specific feature is the ability to autofill a form based on a very large CSV file (about 500 MB).
I am wondering what would be the best option to go about this using React to read the CSV file? I doubt just putting the CSV in the project folder and reading it that way is the best, seeing how that would increase my project by 500 MB. Should I somehow just throw it into a Firestore collection?
Also, if I were to throw it inside the src
project of React, what is a good limit to place on the size of CSV to keep locally?
Cheers in advance