❗❗❗❗❗❗❗❗❗❗❗URGENT❗❗❗❗PLeSE READ ASAP❗MY REQESTS ARE MORE IMPORATNT THAN YOUR TIME❗❗ CC: yourboss,your mum,your uni prof
So much this.
I’m in my first professional role and the first project was completed and aside from my boss I was the only other dev. So I was naturally excited for their (clients) feedback on it.
Well fast forward a couple of months where they really didn’t interact with the application much and then came the queries and then not understanding how to use it. Find boss sets aside 10 days for me to write some documentation with screenshots of all the journeys (free of charge).
Again, tumbleweeds. Then all of a sudden it’s boom emails a plenty.
Can you fix this, this is a major bug kinda emails. Like it isn’t a bug, you don’t know how to use it.
Now we are dumbing down the software to make it more align with what the business is used to, which is fine but even my boss has said (as I over think and want to reply to things instantly) that just because they have come to life doesn’t mean we drop everything else to tend to them now.
Welcome to the professional world where everything is iterative and and 95% of your clients (internal or external) are data illiterate and don’t want to learn whatever self service tools you build.
Yeah it’s going to wild I can already tell. I know your right to as it’s only a small company I work for, less than 10 of us and they all complain about stupid things the clients do.
I have a colleague who is the contact for a dude that takes a picture of a site with his phone, so he photographs the monitor. Which I know isn’t that unusual, but wait.
He then emails this to himself, perhaps to have it on his desktop. Proceeds to print off the image, but not just the image, but the image as it appears in the email. THE ACTUAL EMAIL.
Then he will annotate the printout and I shit you not, will take another photo, but this time of the printout. Inception level shit.
He then sends that in by
carrier pigeonemail.deleted by creator
Sorry to break this to you…but this won’t be the last time that happens. In fact, it’ll probably happen on more projects than not.
deleted by creator
Dump all your data in a data lake, throw a thousand GPUs in there too, and you’ll have your answer in 2 hours max.
Thanks, I’ll tell the client it’ll be ready in 2h.
Mr. Manager calling from a group
Hi everyone, I know we’re all busy, but I just wanted to align on this 2 hr estimate. Can we put our heads together and do this faster somehow?
No, but since we wasted an hour talking about it, the estimate is now 3 hours. Do you want to have more meetings about it?
Two thousand GPUs
And the data they want is the entire FY, is 3,000,000 records and they need every single data attribute making the file like 250 MBs. Then you put it in their SharePoint and they get mad they can’t just view it in the browser despite the giant “This file is too large to view online, download it” message.
“Just email it to me!”
Newspaper: Hackers are announcing a trove of personal data leaked from [company] after a forwarded spreadsheet inadvertently contained more data than the sender realised.
Hey! I just started looking at SQL and this is the first SQL joke I’ve ever seen or at least ever gotten!
So, congratulations me!
deleted by creator
Same feel as “how long is this going to take to pull?” Well I don’t know if part of what you’re asking for exists, how clean it is, and if can join the data you’re talking about, so anywhere from 5 minutes to never?
deleted by creator
Man I don’t regret leaving this behind at my last job. You start out by doing someone a one-off like “sure I can pull the top 5 promotional GICs broken down by region for your blog article - I love supporting my co-workers!”
Then requests become increasingly esoteric and arcane, and insistent.
You try to build a simple FE to expose the data for them, but you can’t get the time approved so you either have to do it with OT or good ol’ time theft, and even then there’s no replacement for just writing SQL, so you’ll always be their silver bullet.
At that point you teach them how to do it themselves. Isn’t there a way to give them an account that only has read access so they can’t inadvertently screw up the database?
I like that idea, and it actually did work for our Marketing guy (Salesforce has a kind of SQL). Near the end there, I just had to debug a few of his harder errors, or double check a script that was going to be running on production.
Never thought of it for Postres or Mysql, etc, but I suppose there’s got to be an easy enough way to get someone access
phpmysqladmin 😆
In Oracle you’d just set up a user that has limited access and give them those credentials. Creating a few views that pulls in the data they want is a bonus.
deleted by creator
If it’s regular, I recommend
cron
+mailutils
. Have the cron job call a script with a variable sleep in it if you want to make it look more manual.
At work, I am currently dealing with a table that has no primary key, no foreign key, duplicate (almost) serial numbers, booleans stored as strings, and so on. It’s a nightmare of a table.
Entity framework is acting like I’m on meth for using such a table.
My all-time favorite database table was a table named STATE, meant to store all US states. It had 531 rows.
Relatable. 🤣
well, there’s confusion, paranoia, agitation and so many others…
Confusion … Your medical condition Disorganized
I’ve been there and you know what’s worse about it? When you fix it only you or a handful of people notice the astronomical labor you did.
“It worked before why did you change it? You are just doing busywork”
Yeah. Luckily the work I am doing is to fix some really bad work that the entire company has been complaining about. So once it’s fixed it will hopefully be a little bit more recognition than that. Plus my boss is pretty level headed.
But who fucking knows? There is always the likelihood that people will say things along those lines. And it ain’t my job to fight them on that.
Worked on a enterprise medical database, had thousands of tables, and some of the most corrupt data possible. This triggers me :(
Me this morning. I’m gonna take a look at why this Jenkins pipeline is failing. This one job starts a dozen others. Half are failing. For different reasons. After starting rewriting a job that someone half assed. Realize the original error was caused by missing input but some are still valid. Still can’t figure out why my rewritten program is erroring. Get pulled away because another program did something weird… I completed nothing today but worked a ton.
My day…
You have perfectly described my day almost everyday.
It’s OKAY to say no.
I’ve gotta get better at this…
Well if organizing things in pristine tables makes things quick, why can’t we have nice things?
Because Jen in accounting doesn’t believe in it, and Tom the CIO likes his data stored raw in TXT Amphibious Delineated. Then our biggest client prefers data as Jason so we swapped half of our database to that to speed things up.
But the real problem is high turnover because we don’t pay anyone enough to work on things they are proud of. After 2 years we stop doing even 3% COL raises so they go elsewhere. So every 2-4 years each position gets a new opinionated asshole.
our biggest client prefers data as Jason so we swapped half of our database to that
the app I work with currently stores json as the only column in a sql table and it hurts me so very much. like watching someone pick up a screwdriver and try to bash a nail in with the handle.
Garcia From Criminal Minds: consider it done 😂
Enhance
You wanna know why this dashboard takes a full minute to load? It’s because it joins every table in the fucking database because some people can’t be bothered to look at a separate page for certain information.