I introduce myself: I am Galician and citizen of the World. Proud father. I love science (specially astronomy), technology, nature and photography. I play padel and surf and whenever I can I escape with my camper van.

www.xurxia.net

  • 6 Posts
  • 21 Comments
Joined 1 year ago
cake
Cake day: July 1st, 2023

help-circle













  • After preview it will be a paid subscription additional to Office365, the same strategy as Office Copilot. I hate this policy of pay for a product then still paid for more functionalities… at the end of the year you will have paid a lot.

    Microsoft says Python in Excel will be included in a Microsoft 365 subscription during the preview, but “some functionality will be restricted without a paid license” after the preview ends.


  • I fully agree with the post. Except for a fast prototyping or a short personal script where it could be not necessary, type hint is a must. The subject is not only to guarantee that the program now runs without errors, but it will be still working right in the future too, even after a developer (either the original or other) make changes to the code.




  • Hi,

    I have used goto instruction a lot when I started to program in Basic ( an Amstrad CPC 🥹). In this context goto had logic. But in modern languages like python I think it is a very bad idea:

    • Understand the logic is more complex
    • Functions and methods are a better and more powerfull alternative
    • It is dangerous: add or remove a new line of code could have bad consequences

    Regards






  • You can use global variables, it is true, but I prefer singleton because I have all config variables and logic encapsulated in a class. The first time the singleton object is created it reads all the config variables from a file, and with its methods get and set manages them. The Config class doesn’t know the parameters names of the config file neither the number, it dynamically reads the file and creates the attributes, so It is a very reusable code that when you program using OOP is a more natural way than implementing like a module.

    Related to this, I group config variables by sections so it is more clearly for me, then the singleton object dynamically creates an array for each section, and a variable into the array for every variable in this section of the config file. Access to the config info is as easy like this:

       conf = Config()
       conf.get('DB', 'server')
       conf.get('DB', 'login')
       conf.get('DB', 'password')