Gordon, who’m’st migrating utilise witches.town. Vous pouvez læ suivre et interagir si vous possédez un compte quelque part dans le "fediverse".

Hey computer nerd pals, it's important for me to know how to use sql properly for my course, but I know if I have no reason to use it in my personal life it'll be complicated for me to learn.
Do you use sql and databases in a personal context? If so how? I'm looking for ideas.

@Arr0w_root I want to use SQL for several projects : a music database of all the music I've got, a database to monitor the animal I see, and I considered using it for a game.

@fluffy For music I think it's great idea.
Do you mind me asking about how you will use that in your game? I'm also interested in video game developments at least in a professional context

@Arr0w_root I had several kind of objects : regions of the world, tiles of the region, NPCs, and tools and materials. But since I hadn't described exactly how would tools would be (different properties if weapons, magical, ...), I preferred using the python module pickle.

@fluffy *take notes* I haven't learned python (yet?) but I'll keep that at the back of my mind

@Arr0w_root With using pickle, I just write
p = pickle.Pickler(file)
p.dump(obj)
And the object is saved, without having to consider how it is implemented, and loading it just reproduces the original object. This is great for POO !

@fluffy Oh ça c'est l'acronyme français il semblerait xD
Ca m'a l'air assez simple en effet!

Gordon, who’m’st migrating @gordon

@Arr0w_root @fluffy attention, sérialization (module pickle, dans ce cas) ≠ SQL. Ce dernier est bien loin de n’être qu’un support de stockage, c’est un *système de gestion* de base de données, avec des propriétés extrêmement puissantes

@gordon @Arr0w_root Oui c'est vrai, l'usage dépend beaucoup du but du programme.