HNHacker News
TopNewBestAskShowJobs

drunkpotato

1,946 karma · joined September 27, 2009

submissionscomments
drunkpotato··on The examples in the textbooks are not representative of real world problems
I found it to be a bit of a chicken-and-egg problem. At the time I learned it, I didn't really understand why relational theory was important. I trusted that it was, I just didn't really grok all of it. But later I found it of immense practical help when writing, and especially debugging, sql queries.

Perhaps the ideal order to learn in would be practical, theoretical, practical (applied theoretical), though that's just a gut feeling.

drunkpotato··on SQLite B-Tree Module
This is just what I’ve heard so take with a grain of salt, but as I understand it sqlite is “mostly” safe to use concurrently. There are situations where it doesn’t behave correctly under concurrent load, the one I’ve heard about being when the sqlite is on a network-mounted drive. I’d love to hear from someone who knows more though.
drunkpotato··on Study conspiracy theories with compassion
Some of his voters were sick of feeling like they were looked down on and treated like shit, a message that was repeatedly amplified and propagandized. It’s an important distinction. Perception is not reality.

Are there “coastal elites” who look down on “flyover country?” Sure. No group is perfectly free of prejudice. It works the other way too; I have family that sneer at educated idiots, latte drinking city liberals and so on.

Try to keep in mind, who or what is emphasizing and amplifying these fault lines, and why? Why is it important to keep insisting on binary labels and othering? From keeping people angry and, thus, engaged?

drunkpotato··on Show HN: Visualize SQL Queries
I mostly work the way you do, but still find explain helpful when my intuition fails. Most notably this usually happens when an index exists but the query manages to miss the index. Most often I experience this when it comes to dates and ORM-built queries that type cast.
drunkpotato··on Cloudflare have made it impossible for me to unsubscribe from marketing emails
That sounds like a magical company.
drunkpotato··on Cloudflare have made it impossible for me to unsubscribe from marketing emails
Please try not to use weasel phrases like "Sorry you are having difficulty..." The poster clearly articulated the very real technical problems they are having with your broken unsubscribe process, doing your debugging work for you, and the phrasing of your response implies that the fault lies with the user. I don't think this was intentional weasel-speak on your part, but do please try to be aware of your audience.
drunkpotato··on Longbet: By 2027, software will be metered/sold by the second
While true, it's not the whole story. lambda is also approximately 1000x more expensive than EC2. So if your lambda is only running 0.1% of the time or less (12 seconds per every 3 hours 20 minutes) you break even. If it runs more than that, lambda is more expensive.

This is just price comparison. There are other reasons, convenience, visibility, integration with other services, to choose lambda sometimes and EC2 other times.

It's important to profile and know what your use case is!

drunkpotato··on Ask HN: How to make the most out of time at university?
Take a healthy variety of non-technical courses as well as your technical courses. They're both important. This is a good time to experiment with a variety of subjects and learn what you enjoy. It could also have a significant impact on your employment; part of standing out in an interview is getting along with the interviewers and sharing unique knowledge and experiences that make you memorable.
drunkpotato··on Understanding Attributes, Dicts and Slots in Python
Nice explanation! I’d add some further reading and practical advice at the end, like using slots=True in dataclasses or attrs classes when higher performance and lower memory usage are required.
drunkpotato··on Last call to voluntarily migrate Java accounts
This is pure, unadulterated, user-hostile bullshit. I paid for Minecraft, not to be dicked around with login systems just because Microsoft bought Mojang and doesn't feel like doing their job.

Apparently someone used my email address already (gmail, because they won't accept school alumni email addresses!) so I was shunted into an "account recovery" hell full of questions I can't answer because I wasn't the one who signed up for a Microsoft account using my email address! How did they let that happen? Have they no validation on email addresses, but want blood work to recover an account?

I am livid. This is an atrocious experience and a nice preview of the hellish future of automated society we're hurtling into. Welcome to John Scalzi's "Automated Customer Service."

Screw you, Microsoft. Thanks for reminding me why I don't purchase your shit products.

drunkpotato··on I Quit Shopify After Five Months
I've been interviewing for multiple companies at all scales for over a decade in the US. Hiring lawsuits just haven't been a factor.

It was years ago, but I think I might have taken a half hour interview training session at a large company that was along the lines of "Don't ask about age, marital status, kids, etc, but it's fine if the candidate brings it up first. Use your best judgment." That was about it. I could also be mis-remembering and that could just have been something my manager at the time told me before throwing me into the interview rotation.

So I think calling it a legal minefield is stretching reality by quite a lot.

drunkpotato··on Spotify deletes 70 Joe Rogan episodes
The government didn't ask Spotify to censor Joe Rogan. The surgeon general didn't ask Spotify to censor Joe Rogan. Not even the extremely uncharitable, biased take in that trash you linked to goes so far as to claim that.

If the government had made a law making it illegal for Spotify to carry Joe Rogan, that would have been censorship. None of the conditions were even close.

Spotify is a private institution, and has the option of carrying content, or not, at their editorial discretion. You can disagree with their choice, and if you do, the proper redress is to put pressure on Spotify, not to claim it's government censorship, which it's not.

drunkpotato··on Amazon Pip Horror Story
Whether someone is in a rut or not is a separate issue than whether they've worked with terraform. The key here isn't what technology they've used, it's a mindset towards automation.

I recently came off a project that was technically using "GitOps" but where every deployment involved copying and pasting dozens of files across 3 or 4 repos, and the whole thing was very error prone, and if you didn't change exactly the right things your service would just silently fail to deploy, or be unreachable, with zero feedback.

I've worked at a company with a bespoke CI/CD system hacked together with PHP scripts and Jenkins servers, but where every single process was ruthlessly automated, reversible, with multiple layers of fallback, failure recovery, garrulous feedback, and built-in approvals that you could automate, or if you didn't remember, you'd get a helpful reminder in email and a link to a page to fill in the required information. People could, and did, know how to do a deployment on it their first or second day.

Guess which one was more pleasant to deploy with?

It's the automation mindset that's important. You can find people with the right mindset who haven't had a chance yet to play with ansible or terraform, and you can find people who manage to create nightmarish complexities of manual processes out of ansible and terraform. Unfortunately, I haven't yet found this to correlate much with years of experience.

drunkpotato··on Reduced-hours software development engineer position at Amazon
Sounds more like experienced than cynical to me. In my experience, job descriptions and even the answers you get during interviews are not so much outright lies, as aspirational fabrications you have to take with a grain of salt.
drunkpotato··on America’s Covid job-saving programme gave most of its cash to the rich
It seems like you have a problem and a solution both staring right at you.
drunkpotato··on Don't forget Microsoft
Oh, thanks for the context! I never owned a Windows phone, I just played with ones other people had, same for Android. And from a total beginner perspective, Windows phone seemed a lot easier and more intuitive, but I can believe that with more use its annoyances would become more clear.

That's interesting about Microsoft really trying for mobile. My recollection is that they didn't put much effort into it, but clearly I was just unaware of it. Which is, perhaps, a sign? For all its investment, perhaps it didn't have the right marketing, as I was never aware of Microsoft's efforts for Windows Phone the same way that I am for Android and iPhone.

drunkpotato··on Don't forget Microsoft
It was pretty good. Seemed better than Android at the time. I'm not sure why Microsoft didn't put as much oomph into it as they did for, say, the Xbox, but if they had it might be a major player now.
drunkpotato··on Ask HN: At a peak of my dev career, I hate my life
I'm not sure why you don't think board game groups are a good idea. The attendees seem like a pretty good mix of people to me.

When I first moved to my current city, I joined one, and met a couple who became some of my best friends here. I never would have met them were it not for the group. I realize that not everyone will have the same experience, I just don't see why "recommend board game groups" is rejected as bad advice.

drunkpotato··on Citizen developers are rapidly becoming the vanguard of corporate digitisation
Jira isn't nearly as bad as it's made out to be, only because it's so, so, so much worse. It makes simple things obtuse and absurdly difficult, all in the name of flexibility that is more liability than feature. I hate Jira with the burning passion of a thousand fiery suns.

I've used a bespoke ticketing system. I've used Trello. I've used stickies on a whiteboard. They each had their pros and cons, but every single one of them was infinitely better than the shithole that is Jira.

drunkpotato··on How bad have universities got?
What was the Facebook group? "Apparently inappropriate" is too vague to know what the problem was!
drunkpotato··on How bad have universities got?
This surprises me. I've never heard of anyone losing an internship or co-op position for such a reason. I can't think of it happening anywhere I've worked. As both of us have anecdotes however, perhaps some data on this could be enlightening.
drunkpotato··on How bad have universities got?
A decently nuanced take. We don't want universities to be an echo chamber, however, neither do I want it to be a place where we pretend that "both sides" are equally valid. Rather, a spirit of inquiry should be welcome, and congealing around a left-authoritarianism is not healthy either.
drunkpotato··on Workers are calling out sick in droves
For a store that's true, but it's also happening in residential care facilities where it can be a matter of neglecting care or even life or death when they are severely under-staffed, and the staff who do come in have more work, longer hours, and more patients per nurse than they can handle. Should an infected but asymptomatic person come to work and risk spreading it to their patients? Is that worse than the patient getting neglected and at risk or dying because of a staffing shortage? I don't know the answer.
drunkpotato··on Kirby’s Adventure – Nintendo Developer Interview (1993)
A generation later my kids are loving Kirby on the NES Classic Mini, so I'd say they succeeded!
drunkpotato··on Google Had Secret Project to ‘Convince’ Employees ‘That Unions Suck’
It's a common trope to say it's their duty to shareholders, but it's not. Their duty is to be diligent and transparent to their shareholders, but not to pursue short-term profits at any and all costs no matter what. Specifically, there is no legal requirement or duty for companies to be anti-union.
drunkpotato··on Unvaccinated workers who lose jobs ineligible for unemployment benefits (Canada)
You get a ticket, and too many of those tickets and you lose your license, so yes.
drunkpotato··on Ask HN: Has remote work made you move to a new location or consider it?
Yes, but to be closer to my parents, and to nature.

I didn’t like WFH at first to be honest. But I’ve grown used to it and appreciate the flexibility especially with kids.

drunkpotato··on Once poor, always poor?
You get out of a college education what you put into it. I wouldn't recommend it just for a job, and the debt is an unfortunate modern heavy consideration to keep in mind. However, consider that it can be a force multiplier for your income for life, and give you the time/motivation to study things you may not otherwise come across, which can open you up to new opportunities and expand your network.

Also, people who come to college later in life tend to do better than average, because they want to be there, and have more maturity and discipline to do the work necessary.

I'm not saying college is the right choice for you, you do have important considerations that you're clearly weighing against each other. But, I am saying it may have more in the "pro" column than you credit it for, and there are also some non-loan subsidies that open up for students as well.

But yeah, student loans suck. A lot. For sure!

drunkpotato··on Exiled from the Metaverse before it even started: Facebook bans are for life
Now that you mention it, things have been more pleasant recently!
drunkpotato··on AWS Account Takeover via Log4Shell
AWS is so difficult to use securely by default that there is an entire thriving industry of vendors who will analyze your permissions and try to bring them down to meet the standard of principal of least privilege. I'm not at all surprised that there are many insecure environments and privilege escalation exploits; AWS is almost aggressively hostile to any attempts to use it securely.
← PreviousPage 3 of 14Next →