• 58 Posts
  • 618 Comments
Joined 2 years ago
cake
Cake day: June 11th, 2023

help-circle
  • On AniDB I can enter dd.MM.yyyy or yyyy-MM-dd (text input), which I like a lot. I often prefer reading and writing yyyy-MM-dd.

    Some time ago I changed my Windows number format settings to show me yyyy-MM-dd formats. Unfortunately, that broke my webbrowsers date input / datepicker. :( So I had to go back to the standard culture format (de in my case).

    The worst is when you work with dates and don’t know what is what, or when the behavior is unexpected.

    Probably everyone knows about the Excel shitshow of implicitly converted values.

    In SQL Server, what do you think 0000-00-00 is when converted to a date, explicitly or implicitly? Well, unfortunately, yyyyMMdd is a safer format than yyyy-MM-dd.

    SET LANGUAGE 'us_english'
    SELECT CONVERT(date, '2025-12-13')
    --SELECT CONVERT(date, '2025-13-12') -- err
    SELECT CONVERT(datetime, '2025-12-13 07:00:00')
    --SELECT CONVERT(datetime, '2025-13-12 07:00:00') -- err
    
    SET LANGUAGE 'Deutsch'
    SELECT CONVERT(date, '2025-12-13')
    --SELECT CONVERT(date, '2025-13-12') --err
    --SELECT CONVERT(datetime, '2025-12-13 07:00:00') --err !!
    SELECT CONVERT(datetime, '2025-13-12 07:00:00')
    

    No, yyyy-dd-MM is not a common or valid German date format. That’s usually dd.MM.yyyy.

    But worst of all, it changes behavior of the date parsing between date only and date + time types.



  • Your question was very unspecific and broad, and despite that, now it goes into a direction I have not foreseen. Your question would have been much more useful and you would have received a lot better answers if you had provided some context, established a premise, been more specific about what you’re asking.

    You asked about PC. Given that Windows is the prevalent PC operating system, I’ll answer for that.

    While Windows has a Microsoft Store app store now, traditionally and still prevalent, most software and applications is installed and managed not through this “app store”, but manually or with other non-OS-integrated software.

    I feel like the premise of the question is from a very different understanding of how things work or are.


  • I regularly write code.

    My customer gave the go-ahead to use LLM in our project very recently. We’ll be trying it out. I’m interested to scope out its use and limitations especially. I’m skeptical it will increase efficiency for me overall. The project is too complex, my/our requirement on quality too high, and I’m thorough to the last var name and code formatting for readability and obviousness. I’m not sure whether I could find it acceptable to compromise on those.

    Between customer communication, planning, review-prep, guiding and helping my team members, and doing reviews, and other tasks within the company, time for my own work can be reduced by a lot. Still, I have tasks I work on, and that includes coding.


  • Microsoft pushes cloud and AI with increasingly negative side-effects. Eventually, EU regulation steps in to require offline-capable OS with fair and obvious choice. Microsoft tries to argue security, but ultimately fails.

    Microsoft continues to push and connect their services as one, with synergy effects. Eventually EU regulation and prosecution steps in, requiring a neutral OS that must not pre-install software or point to other products in OS settings and apps, etc. Integrations must be openly standardized first, before implementing their own.

    Despite all this, and despite a move from EU and EU-national institutions to sovereignty through shared open source solutions, Microsoft retains their strong/prevalent market position because the market as a whole is not as strategic and concerned, and Microsoft products like office, onedrive, Teams, and their other business software and services remain a predominant and grab-first choice, and the security promise of big enterprise software, battle-tested, with strong established auth etc remains a big selling point for them.











  • When PRs begin with a headline and checklist the GitHub hover-preview becomes useless. When the PR description begins with the summation of the change, it is very useful.

    Most of the time I see headlines and check lists in tickets I create or contributions I create PRs for, I feel stifled and like I have to produce something very inefficient or convoluted.

    The worst I have seen is when, at work, I had to create bug tickets for a new system in a service desk to a third party, and they had a very excessive, guided, formalized submission form [for dumb users]. More than once, I wrote the exact same thing three times into three separate text boxes that required input. (Something like “describe what is wrong”, “describe what happens”, “describe how to reproduce”.) Something that I could have described well, concise, fully and correctly in one or two sentences or paragraphs became an excessively spread, formalized mess. I’m certainly not your average end user, but man that annoyed me. And the response of “we found this necessary” was certainly not for my kind of users, maybe not even experience with IT personnel.

    At work, I’m glad I have a small and close enough team where I can guide colleagues and new team members into good or at least decent practice.

    Checklists can be a good thing, if processes can be formalized, can serve as guidance for the developer, and proof of consideration for the reviewer. At the same time, they can feel inappropriate and like noise in other cases.

    I’ve been using horizontal line separators to separate description from test description and aside/scoping/wider context and considerations - maybe I will start adding headlines on those to be more explicit.