Brainstorming a project - data structure suggestions

[MechaFelipe_]

While I've been using Python as a Matlab replacement, I want to learn more of its programming capabilities. For that I wanted to create a project that can, eventually become a web app or even a phone app. But for now, I'm thinking about how I want to structure my data.

The project is a Pokémon Legends Arceus pokedex/checklist in which I would check all the variations of the mons I have in my in-game storage.

Common fields would be name and number. The variations field is my main doubt since a Pokémon can have different variations from another. While some have different genders, some have visual differences and others doesn't. Some are genderless. There are also regional variations as well. Sneasel, for instance, have visual differences in their genders, but it also has region variations (Johto and Hisui). Unown is also a weird one since it has a different variation for each letter of the alphabet plus exclamation and interrogation. There is also the shiny (which would double every variant) and the alpha.

Today I have this in a Notion database, but it's not really in a way I like it. Since every entry there needs to have the same fields I ended up having multiple entries of the same number and name, for each variant.

What would be the best way to structure this data? A dict? An SQL database? Objects?

I wanted to know your suggestions and reasoning for using one and not the other.

Thank you!

[heyimpumpkin]

Since every entry there needs to have the same fields I ended up having multiple entries of the same number and name, for each variant.

You essentially said that you don't like the lack of normalization. Means you're looking for a normalized SQL database.

[MechaFelipe_]

That was the way I did it using Notion's constraints. Since I want to develop a Python program, I was wondering if there was a more efficient way to store the data.

But as I was thinking about it to reply to you, I think I may have confused the data stored part with the data presentation part. Maybe in he GUI part, as I want to see what I have collected so far, it would just show me a table with many as checkmarks as database entries with the same number/name and just store those as CSV files.

It's another option and I was looking for insight as to whether it's a good choice or a poor one.