1000+ terms - better as Dictionary or Resource?

Godot Version

4.3

Question

I am creating a language learning app. This requires approximately 1000 vocabulary words, each with 20 entries under each. So, each word contains: english word, translation, syllables, seen, times seen, added to list, mastered, seedlist… and a bunch of other variables.

About half of the variables for each word need to be changed frequently. I already have a large Google Sheets ready but everywhere I look people keep saying Resources is better than Dictionaries.

I am not sure how easy it is to change resources once they are created. And I know they save as separate files, so it seems like it coudl be a real pain to set up 1000 of them. But, if it is truly better somehow, I want to do it right.

Any thoughts on the best way to attack this? Dictionaries? Resources? Half and half?

your best bet is a csv, you make a spreadsheet and list everything inside, easier to maintain. then you download the spreadsheet as a .csv file
godot has a way to read csv

else you json it

any of them will results in Dictionary inside godot anyway after you successfully read them and when storing it

I have yet to be able to make Godot read my CSVs in a reasonable way. It seems to only want to make it a bunch of translation files. I am not sure how to get it to read it as a dictionary on its own, unless I have to parse it like I do with JSON.

I have the same question. Using Resources I notice it takes a lot of time to initialize every variable in the resources. I’m wondering if it will take the same time using a single variable (an array) that instead of Resources holds dictionaries.