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.
@gordon well hell yeah if I'm able to contribute! But I haven't learned how to use sql with java yet for example
@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
@fluffy Anyway, thanks for answering!
@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!
@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.
Poke @lanodan_tmp pas de pression pour une réponse, mais je me dis que quelqu'un comme toi qui bidouille a ptet des idées?
@Arr0w_root :shrug:
SQL c’est un truc que j’évite parceque j’aime pas le language, je connais juste quelques bases communes aux différentes implémentations mais c’est quand je suis obligé·e…
@lanodan_tmp ouais, je te feel...
@Arr0w_root my first thought is to export my library from librarything, drop it in sqlite and ask questions
@Arr0w_root nope. But do you want to work on software development?