If the author thought about all this in an essay, you can bet Apple did too in their many years working on this. Whether they managed to come up with proper solutions to these issues is another matter, but I'd be hard-pressed to think they've not been acutely aware of all of this and actively worked on it.

I've had no luck blocking YouTube's consent popup with uBlock Origin. From what I remember, it would randomize the element ID and also add a load delay, and if you managed to block it, it would block comments from loading or break scroll etc. With Consent-O-Matic, it works just fine.

Agreed! Here's my current `userChrome.css` to hide the tab bar when Sidebery is open, IIRC adapted from their repo because theirs didn't work fully for me. Admittedly this is hacked together, it was mostly just trial and error, but it works!

    #main-window #TabsToolbar {
      height: 40px !important;
      overflow: hidden;
      transition: height 0.2s ease-in 0s !important;
    }
    #main-window[titlepreface*="‏‏‎ ‎"] #TabsToolbar {
      height: 0 !important;
      min-height: 0 !important;
    }
    #main-window[titlepreface*="‏‏‎ ‎"] #tabbrowser-tabs {
      position: fixed;
      z-index: 0 !important;
    }
    #main-window[titlepreface*="‏‏‎ ‎"] .tab-stack {
      visibility: hidden;
    }
    #main-window[titlepreface*="‏‏‎ ‎"] #toolbar {
      min-height: 0;
    }
    #main-window[titlepreface*="‏‏‎ ‎"] #sidebar-header {
      visibility: hidden;
      height: 0px;
      padding: 0px !important;
      border: 0px !important;
    }
    #main-window[titlepreface*="‏‏‎ ‎"] #titlebar {
      visibility: hidden;
      height: 0px;
    }

To make it work only when Sidebery is open, make sure you add a preface value in the Sidebery settings and use the same value in the css above; in my case I just use an invisible character. Couple it with Ctrl-E keybind to toggle the Sidebery panel, and it's been a big quality of life improvement for me.

My main gripe about the Wikipedia mobile site is that text search doesn't work on the collapsed sections, and there's no way to expand all sections at once. The simplest thing left to do is the request/navigate to the desktop site and use your browser's find text feature then.

  mydf = pd.DataFrame({'a' : [1, 2, 3]})
  print(duckdb.query("SELECT SUM(a) FROM mydf").to_df())

I can see the appeal, but if you're working in Python, something doesn't sit right with me when having to write out variable names as strings. E.g., if I want to refactor the code, my LSP or parser won't pick up those references.

> The SQL table name mydf is interpreted as the local Python variable mydf [...] Not only is this process painless, it is highly efficient.

It might be painless and convenient at first, but I feel like this could get you in trouble down the line. Is there a way to avoid this?

> They want people who have done this in an enterprise setting.

This has been a question I've had too. How do you get to show you have experience in enterprise software/tech if you've not been given the chance to work in a setting that uses something like that before?

It's the chicken and egg problem. Companies are often more concerned with the candidate's experience in specific esoteric technologies for their sector, and will not hire anybody who doesn't fit that yet, instead of also hiring people who can definitely learn that tech pretty quickly based on their experience, or having shown they are experienced learners.

> This has been a question I've had too. How do you get to show you have experience in enterprise software/tech if you've not been given the chance to work in a setting that uses something like that before?

Personally, I believe the answer is right place right time, as disappointing as it may sound. A large amount of people I know working these sort of roles are there because Company X in the domain recruited them from University pipelines where they attended and that seems to be almost exclusively where the companies source “entry level” hires for these domains.

I still think it’s possible to get there from somewhere else, it just requires slightly different skill sets and a lot more work.

Depending on the circumstances, couldn't that be tantamount to constructive dismissal in some countries?

That's honestly not too far from the definition of odious debt.

And the kicker is, as other commenters here have pointed out, it now also depends on the card you're using to pay with, straight up pulling a bait and switch after you try to pay: they don't go through with the charge if they see you're using an American card and then ask for more money.