Which data storage method to use to store and easily add data?

Question

SQLite

Good morning, Habr users.

I have an idea for a windows application. The point is that you need to check the user's answer with the translation. That is, "checking" knowledge in foreign language. The application will use the words from the textbook, but it will also need to be able to create its own "dictionaries". In general, I need help, because I do not quite understand in what format to store words with translation. Because using dict = {"translation":"translation"} in the code itself is not very convenient. Yes, there are many words. Tell me, what is better to use so that such a database of words can be easily edited? There was an option with a JSON file (and I don’t know other options), but I am also considering other options. Thanks

Answer 1

Not everything is as simple as {"translation":"translation"}.
Natural language words have more characteristics:
https://en.wikipedia.org/wiki/Natural_language_pro...
(there is also a Russian version of the article, but the English one is more complete)

Answer 2

JSON is fine

Answer 3

I understand that you decided to automate the translation, but you yourself are somehow not friends with the translation. Sadly. What is written in the article proposed in one of the answers is directly and directly related to programming, and not to linguistics.
In general, the organization of successful storage of information in systems related to translation and / or simply language processing is much more difficult than it seems to beginners. Linear structures very rarely work normally here, since the structure of words in any language is a complex graph, and in different languages ​​for the same word it can turn out to be completely different.
The problem is obvious - you took the task "too tough". Start with something simple, see how data can be stored at all and how it is implemented in Python. Then carefully read the article, but not one - similar to the one that you have already been recommended. Then see how all this is organized in other systems similar to yours. Be surprised by the variety and choose the option that is most appropriate for your task. And you are implementing it. Yes, it will take some time, but at least it will be useful for you, and you will understand the problem.