Boss sends e-mail telling everyone we have funding for 1+ year.

Two weeks later 50% of employees laid off.

ლ(ಠ益ಠლ)

The more I work with performance, the less I like generated queries (incl. ORM-driven generators).

Like this other team came to me complaining that some query takes >3minutes to execute (an OLTP qry) and the HTTP timeout is 60 seconds, so.... there's a problem.

Sure, a simple explain analyze suggests that some UIDPK index is queried repeatedly for ~1M times (the qry plan was generated for 300k expected invocations), each Index Scan lasts for 0.15ms. So there you go.. Ofc I'd really like to see more decimal zeroes, rather than just 0.15, but still..

Rewriting the query with a CTE cut down the execution time to pathetic 0.04sec (40ms) w/o any loops in the plan.

I suggest that change to the team and I am responded a big fat NO - they cannot make any query changes since they don't have any control on their queries

....
*sigh*
....
*sigh*
but down to 0.04sec from 3+ minutes....
*sigh*

alright, let's try to VACUUM ANALYZE, although I doubt this will be of any help. IDK what I'll do if that doesn't change the execution plan :/ Prolly suggest finding a DBA (which they won't, as the client has no € for a DBA).

All this because developers, the very people sho should have COMPLETE control over the product's code, have no control over the SQLs.

This sucks!

Why won't you just approve my PR???

Whats wrong with you?!

I don't understand your cryptic one-sentence feedback. I'm not even sure you understand what you're asking yourself.

What the hell does "make it a transaction" mean? Don't give me pseudo-code examples that don't even work fucking asshole!

Its a small change that does NOT need a canary build dammit. Don't go testing the ORM, its a goddamn standard library. Why does working with you make everything so complicated?!?!

The code fucking works! There is no need to make it comply to your specific tastes goddamn it. Working with you is like pulling teeth!

/endrant

What the heck COVID!

All the days have been blending together for the past 6 mo! What day of the week is this? Who am I? What's the meaning of life? Have I ever left the house?

Not going outside, getting alienated from my friends, getting somewhat anxious for no good reason...

Its so weird! This eery, suffocating stillness.

Alas! I hope the day comes soon that I may frolic in the multitudes of people!

Need to rant / maybe some advice.

Working remote is hard.
New company, remote on boarding. I feel like my coworkers are robots, and I'm being tossed into the deep end with minimal guidance.

The codebase is so unnecessarily complicated, its impossible to read. I've been trying to figure out how things work for a whole month, still not sure.

My mentor that is supposed to help onboard me is a robot, and answers questions in a somewhat acceptable manner, but it still feels like a lot of "figuring out" is still left for myself.

My other work partner that is also a newbie like myself is also a robot - doesn't talk or ask many questions whenever we have a sync up meeting.

The codebase is huge and feels quite overwhelming, I don't feel like I got a team "with my back", I don't enjoy work as much as I have before, I barely do any coding (mostly reading code and trying to understand how everything is working by setting breakpoints and debugging tests that take foreeeever to run), and some days I'm seriously considering cutting my losses and jumping ship just to save my sanity.

Am I paranoid? Am I just dumb? Should I just suck it up and be happy I have a job? Is this how Remote work is supposed to feel like? Why does it feel like my soul is dying?

Anyone in similar situations, or who can give some insight/advice/etc, I would highly appreciate it.

And this is supposed to be a good company too from the reviews. I don't know how it can be so crappy in reality. Did I make the wrong choice joining? Should I jump ship sooner rather than later? I've only been here about a month or so, and maybe its too soon? Halp!

My relationship with recruiters have always been a love/hate thing in the past. Some are super pushy and borderline bully you into accepting a job if they can.

A close friend of mine has lost their job recently due to COVID-19 related layoffs, and is now in a very vulnerable position both economically and psychologically. Enter recruiters.

This particular recruiting firm in my city is quite notorious for being unpleasant. I just hate how they treat people, and specially in my friend's case, pushing them for information like their previous salary when the recruiter doesn't even have a job lead!

I know they work commission and really want to close the $$$, but sheesh! So irritating!

Common Table Expression's, especially recursive, are fucking awesome.

*happy tears*

anyone find mysql infinitely more time consuming than postgres? i cant do CTE anymore 🤔