The OFFICIAL programming thread

Tazz

I fell asleep

Gators1

@Hog said in The OFFICIAL programming thread:

Introducing Python in Excel

Ooh. It’s in beta but is coming to Excel soon I guess.

That will be a huge step forward over VBA if you have any scripts in your worksheets. As a data professional though I am required to say Excel is old school boomer bullshit.

Gators1

@Jam said in The OFFICIAL programming thread:

@Gators1 said in The OFFICIAL programming thread:

@Hog said in The OFFICIAL programming thread:

Introducing Python in Excel

Ooh. It’s in beta but is coming to Excel soon I guess.

That will be a huge step forward over VBA if you have any scripts in your worksheets. As a data professional though I am required to say Excel is old school boomer bullshit.

That’s a very thinly disguised insult!

Even a boomer with failing eyesight can see what you did there!

Its kind of a meme in the data world how we can build a process to get you data super fast on a beautiful dashboard and the users always ask for it to be emailed in Excel.

Kilemall

@Gators1 said in The OFFICIAL programming thread:

@Jam said in The OFFICIAL programming thread:

@Gators1 said in The OFFICIAL programming thread:

@Hog said in The OFFICIAL programming thread:

Introducing Python in Excel

Ooh. It’s in beta but is coming to Excel soon I guess.

That will be a huge step forward over VBA if you have any scripts in your worksheets. As a data professional though I am required to say Excel is old school boomer bullshit.

That’s a very thinly disguised insult!

Even a boomer with failing eyesight can see what you did there!

Its kind of a meme in the data world how we can build a process to get you data super fast on a beautiful dashboard and the users always ask for it to be emailed in Excel.

The earlier was you’d send a Lotus and they want a green bar print out.

Multiplan by floppy if you are really old school.

Gators1

Thats old skool bro.

Jam

And I remember hearing about how Tazz was asked to take a charcoal parchment rubbing of his abacus calculations and send them out by carrier pigeon!

Edit: n/m

Tazz

@Jam said in The OFFICIAL programming thread:

And I remember hearing about how Tazz was asked to take a charcoal parchment rubbing of his abacus calculations and send them out by carrier pigeon!

Interview with Senior Rust Developer

Don’t know if the whole video is worth it but this is a great line:

Ah, Rust is… imagine you would throw all advantages from all languages together. Now your code is unreadable. But it’s memory safe.

I like Rust but it requires a degree of masochism.

Last year the client I’m working for had one of the big IT managed services firms build them an app. They spent I don’t know how much on it but it would have cost a lot. However, It never got through UAT because it ran like shit - like minutes to open and minutes again to do some small task in it.

This year, I’d been asked to look at what could be done to optimize it. Fortunately or unfortunately I’ve been way too busy and was told to focus on my other tasks. Anyway, it came to a head recently where they had to make a call to let the same programmers have another go at trying to get it to run, rewrite it from scratch using basically similar technology or write it in something else altogether. They decided to my great joy they were going to rewrite it altogether in another technology. The first reason for the joy is that, despite not having been given time to actually look at and optimize the existing app, I keep getting dragged into dozens of meetings about the fucking thing, the time cost of which just puts more pressure on me for my assigned work. The second reason is that if they’d got it working, I’d have to integrate its functionality into several other apps that I’m currently responsible for and, having briefly looked at the code, I knew it was a fucking mess. Plus, my existing deadlines are fixed and it would cost me more time I don’t have. Rewriting it from the ground up in some other tech would free me of the fucking thing forever.

Then today, while solving a completely different problem, I learned a technique that could potentially resolve the biggest cause of the above apps slowness. I wrote a message to my boss saying “I don’t want to open a can of worms, but I’ve learned this thing today…”. When I saw that it was sitting on unread a couple of hours later, temptation got the better of me and I deleted the message.

Faarrrrrk. I was off the hook. I don’t have time for this bloody app to keep sucking away time and energy while my I run smack into my own deadlines.

Gators1

Oh you fucking dodged a bullet there Mr Expert. Never give them ideas or you will end up owning the rewrite because you know so much about it. That’s my own particular hell right now and probably will lead me to leve the company before the year is over.

Kilemall

@Gators1 said in The OFFICIAL programming thread:

Oh you fucking dodged a bullet there Mr Expert. Never give them ideas or you will end up owning the rewrite because you know so much about it. That’s my own particular hell right now and probably will lead me to leve the company before the year is over.

You can never leave the IT SME ghetto.

Gators1

@Kilemall said in The OFFICIAL programming thread:

@Gators1 said in The OFFICIAL programming thread:

Oh you fucking dodged a bullet there Mr Expert. Never give them ideas or you will end up owning the rewrite because you know so much about it. That’s my own particular hell right now and probably will lead me to leve the company before the year is over.

You can never leave the IT SME ghetto.

You can if you learn to STFU, which I apparently can’t do.

Gators1

SME = subject matter expert. You are the one with all the knowledge that the company needs to keep running in your area, but you normally don’t get compensated for the value you contribute. Fortunately I do more or less.

We had a reorg and the new management isn’t great. My new boss is a complete moron, not having the technical knowledge to do the job or even any management skills whatsoever. He basically delegated day to day management of the group to me and has no clue what we are doing. A couple weeks ago after hours right before we were both about to go on vacation, we had a teams conversation where he announced he was going to delegate this massive cloud migration/rebuild/refactor project to me while he “concentrates on the big picture and governance”. As you would expect I had a lot of filthy language to say about that, but didn’t respond on the chat. We have not discussed it but my answer is going to be no given that’s his fucking job and it’s too big an ask. So it might be coming to a head for me and at this point I really don’t care if they fire me. I would like to make to to November because they gave me a nice equity bonus that vests then. After that I will probably just quit on my own. If I had just STFU from the start and just asked him what he wanted me to do all the time, then he would be fired already and maybe I wouldn’t be in this position.

Kilemall

@Gators1 said in The OFFICIAL programming thread:

@Kilemall said in The OFFICIAL programming thread:

@Gators1 said in The OFFICIAL programming thread:

Oh you fucking dodged a bullet there Mr Expert. Never give them ideas or you will end up owning the rewrite because you know so much about it. That’s my own particular hell right now and probably will lead me to leve the company before the year is over.

You can never leave the IT SME ghetto.

You can if you learn to STFU, which I apparently can’t do.

I’ve had SME fuck me over with oh I don’t remember how to do that. I consider it shitbag behavior.

I just say I don’t want to cover X. I get consideration because many things I do pony up and save the company thousands.

Gators1

@Kilemall said in The OFFICIAL programming thread:

@Gators1 said in The OFFICIAL programming thread:

@Kilemall said in The OFFICIAL programming thread:

@Gators1 said in The OFFICIAL programming thread:

Oh you fucking dodged a bullet there Mr Expert. Never give them ideas or you will end up owning the rewrite because you know so much about it. That’s my own particular hell right now and probably will lead me to leve the company before the year is over.

You can never leave the IT SME ghetto.

You can if you learn to STFU, which I apparently can’t do.

I’ve had SME fuck me over with oh I don’t remember how to do that. I consider it shitbag behavior.

I just say I don’t want to cover X. I get consideration because many things I do pony up and save the company thousands.

Yeah, agree. Though I am kind of in a unique situation where my boss is incapable of doing his job and is relying on me to do everything and advise him on what he should be doing. He needs to be fired and am not sure why his boss hasn’t come to the same conclusion yet. It’s not just about withholding knowledge, it’s about me being asked to do his fucking job. Had I not engaged and effectively extended his tenure, we would have been done with him and moved on by now. I should have gone to his boss with this but I have no relationship with her to speak of and honestly don’t really like her. So I will have to find a new job and the company will be fucked because I walk out the door with all the knowledge they need to execute on this project.

tigger

@Hog said in The OFFICIAL programming thread:

Last year the client I’m working for had one of the big IT managed services firms build them an app. They spent I don’t know how much on it but it would have cost a lot. However, It never got through UAT because it ran like shit - like minutes to open and minutes again to do some small task in it.

This year, I’d been asked to look at what could be done to optimize it. Fortunately or unfortunately I’ve been way too busy and was told to focus on my other tasks. Anyway, it came to a head recently where they had to make a call to let the same programmers have another go at trying to get it to run, rewrite it from scratch using basically similar technology or write it in something else altogether. They decided to my great joy they were going to rewrite it altogether in another technology. The first reason for the joy is that, despite not having been given time to actually look at and optimize the existing app, I keep getting dragged into dozens of meetings about the fucking thing, the time cost of which just puts more pressure on me for my assigned work. The second reason is that if they’d got it working, I’d have to integrate its functionality into several other apps that I’m currently responsible for and, having briefly looked at the code, I knew it was a fucking mess. Plus, my existing deadlines are fixed and it would cost me more time I don’t have. Rewriting it from the ground up in some other tech would free me of the fucking thing forever.

Then today, while solving a completely different problem, I learned a technique that could potentially resolve the biggest cause of the above apps slowness. I wrote a message to my boss saying “I don’t want to open a can of worms, but I’ve learned this thing today…”. When I saw that it was sitting on unread a couple of hours later, temptation got the better of me and I deleted the message.

Faarrrrrk. I was off the hook. I don’t have time for this bloody app to keep sucking away time and energy while my I run smack into my own deadlines.

You’re working for the wrong company…

Why I use Vim in 2022

At work, I alternately have to use VS Code which does have vim key bindings and Eclipse which doesn’t. So I’ve been switching between the two for over a year and get reminded daily that I am, without exaggeration, 2x to 10x faster in VS Code. Not because of the editor, but because I can use vim mode in it.

Seriously, learn vim even if you don’t use end up using the vim editor. You need to commit to it and it will really suck for a week or two but it’s like the difference between “hunt and peck” and touch typing for the productivity boost it will give you. That’s assuming you already touch type that is; if not, you should learn that first anyway.

Gators1

notepad.exe doesn’t have any stupid keybinds to remember. Now that’s efficient!

Best program Microsoft ever developed