I have a database in which I am storing a bunch of companies that can have several different types of codes associated with them — here is a example of a group of codes
I was wondering if storing them in my firebase firestore (the database I am using) wouldn't be the best option due to cost. To avoid multiple document reads, I thought maybe I can store these codes in a json file within my application (on the frontend) and add a field to the companies document linking to their associated code.
I view this as having a json file with a list of all US States with a unique ID and their name/abbreviation... something like:
"name": "New York",
Then storing the state ID in the database basically. The codes are static (don't change) and since the codes are all already public, the json file within my app wouldn't need to be secured. However, I wanted to know best practices for this type of situation or other ideas.