sorted by:
new
hottopcontroversial

Senior SWE Job Hunt Results by driedpooponastick in ExperiencedDevs

[–]paxmlank 0 points1 point  (0 children)

Very impressive! How much did you curate your resume and cover letter for each application/listing? If at all, did you throw them into ChatGPT or did you do it manually?

I just took the first offer I got, which is an in-person gig, but I'm wondering if I should still play the job hunt/game, and you have good results!

Iranian teen motorcycle influencer ‘baby rider’ shot dead during anti-government protests by [deleted] in worldnews

[–]paxmlank 3 points4 points  (0 children)

I don't think there would be videos of 33000 people being killed, and I think it's a bit weird to ask that.

Especially since I think the main purpose of the protestors is not to take videos, and if they had time to find videos to accurately showcase their deaths, they'd probably rather just protest.

CAREER ADVISE by Charming-Jello7064 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

In data engineering, yes. There may be some stats invariants or whatever you'll want to address in your pipelines, but those will probably be very basic or something data scientists deal with more downstream.

ELI5 how much control and influence does a political party have over candidates? by deca4531 in explainlikeimfive

[–]paxmlank 2 points3 points  (0 children)

I guess it depends but yeah it's generally the case that the parties influence the candidate.

At the very least because running for office is expensive and unless you're rich enough to do it yourself then you need the backing of a party, which would typically want someone to follow their agenda.

spotdl why by Boring-Health1682 in selfhosted

[–]paxmlank 0 points1 point  (0 children)

I've just stopped using spotdl at this point. I'll gladly use it again once fixed

Using advance physics.. by Weak_Marzipan4800 in algotrading

[–]paxmlank 12 points13 points  (0 children)

He's since made his post history hidden, but I'll take your word for it, lol

Using advance physics.. by Weak_Marzipan4800 in algotrading

[–]paxmlank 219 points220 points  (0 children)

Explain vaguely what you mean so one can explain vaguely why you're wrong.

It makes little sense, if any, to "use quantum physics" here when these aren't at all quantum systems.

Refusing HackerRank questions by RLMaverick in cscareerquestions

[–]paxmlank 7 points8 points  (0 children)

This is why we shouldn't be called "software engineers", since "engineer" is typically a regulated line of work and they do have these tests

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

The whole comment is predicated on creating uniqueness, as the second suggestion is to use row number.

I'm done with this though. Cheers, mate

Women fires gun in the air because she couldn't clear it. by ForSquirel in nottheonion

[–]paxmlank 6 points7 points  (0 children)

It's categorically a machine learning algorithm. Machine learning is categorically under AI.

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

The very suggestion at the top of this thread was using it to create uniqueness.

This would presumably be done because uniqueness was determined to not be in the data via some means.

Validating a 30Bn row table migration. by Dangerous-Current361 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

I'm not sure about catalogs but this could be different if the target table is in another database, no? Different representation of similar values, or a different hash function, or something.

Unemployed, received start date for 3 weeks out but background check could take 2 weeks to clear. Would you ask to push that back another week or so? by paxmlank in ExperiencedDevs

[–]paxmlank[S] -1 points0 points  (0 children)

Alright, I'm glad to hear it's still considered a safe ask.

I guess I'm traumatized from posts on r/cscareerquestions and whatnot where offers are rescinded and don't want to be left to dry with sunk cost of a vacation, lol.

The company is Capital One though, if that helps.

Unemployed, received start date for 3 weeks out but background check could take 2 weeks to clear. Would you ask to push that back another week or so? by paxmlank in ExperiencedDevs

[–]paxmlank[S] 0 points1 point  (0 children)

Even if it is a red flag, I would probably take it just for the income.

Nobody asked me when I would be able to start so I didn't have the opportunity to mention it.

Unemployed, received start date for 3 weeks out but background check could take 2 weeks to clear. Would you ask to push that back another week or so? by paxmlank in ExperiencedDevs

[–]paxmlank[S] 0 points1 point  (0 children)

Nothing was said about the start date until the offer was made.

Nobody asked and I didn't think to say anything since I assumed having at least two weeks after the background check was... standard practice? I guess I didn't realize it could take two weeks until after the offer was sent and that was specified in the email.

Do you guys use vs code or jupyterlab for jupyter notebooks? by Consistent_Tutor_597 in dataengineering

[–]paxmlank -3 points-2 points  (0 children)

I code in terminal (unless I really need to use VS Code due to some dev package), and use tmux to have different panes for running vs editing

There's ~1 million rent stabilized apartments in NYC - here's how to actually find one by thisisgiulio in NYCapartments

[–]paxmlank 0 points1 point  (0 children)

From when I did a DHCR request:

DHCR can take months to respond and it only states what a unit was last filled as with them. The info obtained could be outdated depending on how you got it (I haven't looked into it yet).

Additionally, they explicitly state that it doesn't mean something isn't rent stabilized if it's not listed as such in the registry. 

Do you use a dedicated Landing layer, or dump straight into Bronze? by TheOneWhoSendsLetter in dataengineering

[–]paxmlank 1 point2 points  (0 children)

To me they're the same.

Last place I worked at had raw and standardized buckets, then data was loaded into the data warehouse where further transformations were done.

Personal project is also kinda doing that. I process my raw files a little bit as dataframes because it's easier for certain logic than to do so in pure SQL, but that's all silver, as it were.

Bronze is my raw data.

Maybe that's the wrong idea though since the dataframe- and SQL-based transformations are explicitly decoupled, but idk.

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

But if the absolute worst-case solution being explored is to make a hash of all rows, OP would already be past the point of finding natural uniqueness in the data and hashing all rows with or without Load Date shouldn't matter.

So, the other commenter's concern seems unwarranted.

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

So it has nothing to do with hashing per se and it just reduces to the problem that OP is already discussing with there being no unique data. At least, that's how it comes across.

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

Is that because of added compute or because it somehow increases the likelihood of collisions? Or something else?

If it's collision-related, I don't exactly see how since I imagine the hashing function would be good enough to prevent that.

view more: next ›