At my current job, I’m the only one doing any sort of programming work. I basically am the “tech solutions” guy and although we do have an IT department. The work we do is bastly different.
So this is a great oportunity for me to present open source software and, while my current company is a deeply entrenched windows user, I have been able to convince colleages and my boss that sometimes straying from it has lots of benefits (specially in the wallet department).
Without further ado, here are the open source projects I managed to implement onto my fully windows company:
-
A ubuntu LTS web server: One of the bigger projects I was tasked with was making an internal utilities website. As linux is king in the web world it was fairly easy to get this setup approbed and as an added bonus I got to implement a fairly similar ‘0 downtime’ setup I saw showcased on youtube. Using industry standard tools like docker or git and some good ol’ bash. Here we use pgAdmin to connect to the Postgress server and do basic maintenance tasks.
-
Headwind’s mobile device management service: This one I’m fairly proud of, my IT department has 500+ phones to setup each year and all of these were done manually, as they didnt find any provider that didn’t offer a cost-effective solution. With Headwinds model I was able to setup another small test server and showcase it. While the solution aint perfect, I managed to convince my manager that this is something we should go forward with. To be honest, I’m just proud that I saved hours of work for whichever poor interns would have been tasked with manually doing half a thousand phones.
-
Mozilla Thunderbird: This one’s one of those quick and easy fixes. New reports only came in through mail, so I setup a client that downloads these to files the other departments use. Here I am sure I can find a way better solution, specially one that doesnt require a different instance per target folder.
While this is an overall short list, progress is progress and I am constanly on the look for replacements for tools I feel forced to use.
For example, Power Automate. I am looking for a solution that lets me export to an exe and has the strong selector tools it’s using. AutoHotKey seems to be a great replacement but it’s still just relying on screen position which doesnt have the portability I need. Pywinauto has great promise but I havent gotten the downtime to re-implement something working on it.
I demonstrate that Python could easily replace SAS (proprietary and expensive statistical software). There was already plans to move from SAS to Python and I was the first hire specifically to help with this, and after a couple of months they saw that it worked better than expected and the SAS phase out was accelerated.
SAS is mostly always a losing proposition unless you’re actually using the tech support they provide with the licenses. Tho, for statistics at college I used a language called R https://www.r-project.org/ done much with it?
I used R pretty extensively I’m academia too, but Python is way more flexible, and doing statistics is just half the work in an office job.