• 0 Posts
  • 117 Comments
Joined 10 months ago
cake
Cake day: February 7th, 2025

help-circle



  • I also spent two weeks as a live-in cat sitter for a friend on vacation. He (the cat, not the friend) would yell at me, and when I approached him, 1/5 times he’d lead me to his bowl. The other 4, he’d walk to the couch then look at me expectantly. If I laid down, he’d hop on my chest, then flop over into my arm and start purr-snoring within a minute.

    Hell Yeah

    I miss him. But it’s a good pain.





  • The balance to be struck is the golden zone between overcoddling and undersupporting. Kids need help getting “close enough” to figure out the rest on their own, gradually less so as their abilities expand.

    In some ways, I was coddled and never learned how to do stuff. In others, I was neglected and had no idea where to begin to solve things, so I just didn’t. Neither is great.

    as I don’t have any kids.

    You don’t need to have kids to engage with the topic of how best to deal with them. It’s a valuable skill to have when dealing with children, whether your own or someone else’s. In fact, some parents probably should have engaged with the topic more before they squeezed one out. That shit is complicated and I wouldn’t want to just figure it out on the fly.



  • My school made open source a requirement. The funny part was having to argue with the people we were developing this for about opening the source. They were planning to make it a commercial app and were concerned that this would hamstring their monetisation.

    One of them also somehow expected an app developed by students to have innovative value that would need to be kept closed source because otherwise people would steal it. In particular, he threw out the idea that he was hoping to eventually include an AI – long before the LLM hype – to help people, and that would obvioisly be such a technical achievement that it needed to be protected.

    I needed the project, otherwise I’d have told him in no uncertain terms why I think leaving people alone with an AI assistant instead of forcing them to consult a specialist is a really dumb idea in healthcare.











  • This might require a bit of background knowledge about Power Query in Excel and Power BI, specifically the concept Query Folding.

    Power Query is a tool to define and run queries against a host of data sources and spit out tabular data for use in Excel (as tables) or Power BI (as Tabular Data Model). The selling point of it is the low-code graphical presentation: You transform the data by adding steps to the query, mostly through the menu ribbon. Change a column type? Click the column header > Data Type > select the new type. Perform a join? Click “Merge Queries”, select the second query, select the respective key column(s) to join on and thr join type – no typing needed. You get a nested table column you can then select which columns to expand or aggregate from.

    Each step provides you with a preview of the results, and you can look at, edit, delete or insert earlier steps at will. You can also edit individual steps or the whole query through a code editor, but the appeal is obviously that even non-programmers can use it without needing to code.

    Of course, it’s most efficient to have SQL transformations done by the database server already. Bur Power Query can do that too: “Query Folding” is the feature that automatically turns a sequence of Power Query steps into native SQL. A sequence like “Source, Select Columns, Filter Rows, Rename Columns” will quite neatly be converted into the SQL equivalent you’d expect. Merges will become Join, appending tables becomes Union, converting a text to uppercase becomes UPPER and so on.

    If at some point there is a step it can’t fold, it will use a native query to load the data up to that point, then do the rest in-memory. Even if later steps were foldable, they’ll have to be done in-memory. You can guess that this creates a lot of potential for optimising longer queries by ensuring as much or it as possible is folded and that the result is as “small” as possible – as few rows and column as feasible etc.

    Now, when I tell you that there is a table in one of our sources with a few large text columns you almost never need, you may be able to smell the smoke already. A colleague of mine needed help with his queries being slow to load. He had copied some code from Stackoverflow or what have you that joins a query with itself multiple times to resolve hierarchies. In theory, it was supposed to be foldable, provided the step it runs off of is. The general schema of my colleague’s query went Data Source -> non-foldable type conversion -> copied code -> filtering (ultimately keeping about 20% of rows) -> renaming columns -> removing columns. Want to guess which columns were loaded, processed with each join, explicitly renamed and only then finally understood to be useless and discarded?

    “I always do the filtering last, don’t want to miss anything.”

    This is your regularly scheduled reminder that MS (and our corporate BI team) can present Power Query as self-service data transformation tool all it wants, that still doesn’t mean it’s actually designed for use by non-data techies.