HNHacker News
TopNewBestAskShowJobs

coolgeek

622 karma · joined September 23, 2010

Founder of SRSoterica, maker of peerless spaced repetition flashcard decks for learning concept-intensive subjects.

https://www.srsoterica.com/

submissionscomments
coolgeek··on Better SQL JOINs
You list three proposed benefits. (I'm listing them in the order I will address them):

  1) make non-key joins stand out
  2) conciser syntax
  3) less susceptible to joining on wrong columns
1) I'll concede this. But I don't see enough value in it to add (and force people to learn) an alternative JOIN syntax

2) That's not at all clear from your example. Nor does it necessarily follow from the proposal in general

3) This would be your strongest argument. But it's not really a problem in the real world. If/when this happens, it does so for one of three reasons:

  - the programmer misunderstood the data model
  - the programmer misunderstands JOINs in general - how they work and how to write them
  - the programmer wasn't paying attention to what they were doing - e.g. copy/pasted the wrong thing
All of these are bigger problems - they transcend the the realm of JOINs.

As with 1), I don't see enough value in it to make the overall language (and parsers) more complex.

SQL has lots of warts. It is an unpleasant language. It is a difficult language to learn (initially). But it (mostly) works.

If I was going to advocate for a change like this, I'd propose a new join type called something like FK JOIN:

  SELECT * from table1
  FK JOIN table2
This would work sort of like NATURAL JOIN, but without any possibility of ambiguity (and only on the key column).
coolgeek··on Ask HN: How can I learn problem solving skills starting from zero?
You don't clearly specify which types of problems you need help figuring out how to solve.

So my general advice to you is to minimize the activities you devote attention to. Focus on your classes/studies. Find study groups, or organize them yourself.

Avoid parties/partying. Avoid romantic relationships.

Make a sleep schedule and stick to it. Get fresh air. Engage in outdoor activities - walks, biking, pickup games. Do these things indoors if you can't do them outside.

I'm not sure what you mean by "mental health demons". If they're serious issues, you probably need professional and/or group help with them. Do whatever you need to do to keep them in check.

Good luck

Edit: Stay off social media: FB, Twitter, IG, TikTok, Twitch, etc. Youtube is okay if you restrict yourself to videos that assist your studies.

Avoid political and social issues. Keep your eye on the ball.

coolgeek··on Snapshotting memory to scrape encrypted network requests
> The rise of SPAs has made this approach a bit less impractical

I think you meant "less practical", or "more impractical"

coolgeek··on Better SQL JOINs

  > FROM permission p
  > LEFT JOIN role r WITH p->permission_role_id_fkey = r
<snip>

You're using the alias "r" here for two different things:

  - a table alias for the role table
  - a whatever (foreign key index object?) alias for p->permission_role_id_fkey
> the special but common case when joining on columns that exactly match a foreign key

I've been programming with RDBMSs since 1996. I'd say that approximately 99% of the thousands of JOINs I've written were based on PKs/FKs.

The example that you are attempting to improve already operates on PKs/FKs.

I don't understand the point of this proposed improvement at all

coolgeek··on South Africa’s omicron coronavirus outbreak subsides as fast as it grew
That study only analyzed pediatric cases
coolgeek··on Waffle House Poet Laureate (2019)
> limp (but delicious!) fries

Pssst... you can order them well done... don't tell anybody

https://www.seriouseats.com/the-in-n-out-survival-guide-we-a...

coolgeek··on A Dangerous Court Order Against the New York Times
https://archive.fo/j6Xef
coolgeek··on A few words about that ten-million-dollar serial comma (2017)
While the US Constitution might not strictly define militia as government-sanctioned, nearly every (if not every) state does so either in state level Constitutions or legislation.

Private militias are illegal

coolgeek··on War on racist mountains
The article is paywalled, so https://archive.md/iZkYg

The actual article title is "Cancel culture reaches a peak with war on racist mountains".

It cites several renaming examples - none of which I can see a good faith argument against. (The article itself doesn't seem to cite a particular grievance against any of them either.)

The article ends with this weaselly paragraph:

> Some critics see the ban as an example of “cancel culture”, similar to the removal of Confederate statues. Last year, a referendum was held in Mississippi on the design of the state flag, replacing one that included the Confederate battle flag. Almost three quarters of voters approved the new design.

This is just pathetic.

coolgeek··on Consumer Reports Security Planner
Server not found
coolgeek··on The world as we know it is ending. Why are we still at work?
At the risk of repeating myself:

> The system rewards cheaper and faster. But that's an issue of (primarily financial) incentives, not sociocultural biases.

Abusing other workers is a common phenomena at all levels of a company. Low level team leads (line/operations managers) are almost always of the same "class" as the people under them. They almost always ascend from those lower ranks.

In any given instance of abuse, there may be other factors. But there is always a zero sum financial incentive to do so - to exploit others to benefit oneself.

To be clear, I'm not in any way defending CEOs or any other executives. As a category, they are grossly, inexcusably overcompensated for the value they deliver. I'm just saying that the issue is systemic, pervasive.

coolgeek··on The world as we know it is ending. Why are we still at work?
I agree with your points about unfairness, and that laborers are much more deserving of time off than office workers. But I wouldn't characterize it as class warfare.

In most cases, when physical labor doesn't get performed, people notice. There are consequences that ripple out, affecting other people or systems.

In most cases, when office work doesn't get performed, people don't notice. Things just stay the same.

The system rewards cheaper and faster. But that's an issue of (primarily financial) incentives, not sociocultural biases.

coolgeek··on A visual introduction to machine learning
Part 2: http://www.r2d3.us/visual-intro-to-machine-learning-part-2/

The promised part 3 is still not here :(

coolgeek··on Ask HN: How to deal with bull-shitters?
This generalizes into the area referred to as workplace politics. It is an area filled with many (and many different types of) metaphorical dragons.

If it's your company, you absolutely should and must do what it takes to fix the problem(s). But if it's somebody else's company, you need to think really hard about whether or not the effort - and potential blowback - is worth the cost(s).

Are you going to look back from your (eventual) deathbed and say "I'm proud that I fixed that problem?". Are you going to look back and regret that you didn't?

My guess is that your time, effort and attention would be better spent improving yourself than fixing somebody else's company. (That's not a criticism. I'm just saying that almost anything is a better investment of your time.)

coolgeek··on Anti-Mimetic Tactics for Living a Counter-Cultural Life
Note that mimetic theory [0] differs from memetics [1]. It also differs from mimesis (in general) [2].

The author does not make this mistake (at least not conflating 0 and 1). But unaware readers (and misspellers) are often confused by the distinction.

[0] - https://en.wikipedia.org/wiki/Mimetic_theory

[1] - https://en.wikipedia.org/wiki/Memetics

[2] - https://en.wikipedia.org/wiki/Mimesis

coolgeek··on The Freelance Revolution Has a Supply Problem, Not a Demand Problem
https://archive.ph/HNUS6
coolgeek··on Cheating at a company group activity using Unix tools
I love awk. I've been using it for over 25 years.

But awk is usually not a good choice for processing CSV files.

Your program will fail if any of the fields include embedded commas (which is often the case).

coolgeek··on Calculating my open source blast radius
Blast radius is an excellent metaphor here. And it does indeed pair well with bus factor
coolgeek··on A Future Without Manipulation
This URL 404s
coolgeek··on Regulating Big Tech is not enough. We need platform socialism
> In a forthcoming book, I call this idea platform socialism – referring to the social ownership of digital assets and the democratic control over the organisations and digital infrastructure that have become so critical to our everyday lives.

> Platform socialism is about reclaiming collective self-determination through new forms of participatory and decentralised governance that ensure we no longer put profits over human needs. It focuses on how we can foster citizens’ active participation in the design and governance of digital platforms rather than relying on top-down regulations by a technocratic elite.

Not sure that I could come up with a worse name for this (at least for this side of the pond)

coolgeek··on Julian Assange had a stroke in prison due to ‘stress over future’, fiancee says
I wasn't blaming you! All of these article titles suggest that this is a current event. But the articles themselves disclose that it happened in October.
coolgeek··on Julian Assange had a stroke in prison due to ‘stress over future’, fiancee says
Had, not has. In October. As noted in the very first sentence of the article.
coolgeek··on Show HN: Grand Unified Divisibility Rule: One divisibility rule for all numbers
I haven't finished the article yet. But you've stumbled across something in number theory that I wasn't aware of. (Not that my level of awareness should be anybody's gauge)
coolgeek··on Julian Assange suffers stroke while in prison
Every one of these stories (edit: story titles) suggests that this is a current event. It's not. It happened in October.
coolgeek··on Assange has stroke in prison: Fiancée blames stress caused by extradition battle
> It happened at the time of a High Court appearance via video link from Belmarsh in October.

> A 'transient ischaemic attack' – the interruption of the blood supply to the brain – can be a warning sign of a full stroke. Assange has since had an MRI scan and is now taking anti-stroke medication.

coolgeek··on Julian Assange ‘suffers stroke in jail’
> It's reported the stroke happened at the time of a High Court appearance via video link in October.

...

> Since the mini-stroke, it's understood Assange has had an MRI scan and is taking anti-stroke medication.

coolgeek··on The CIA and the Media (1977)
> was about the same time the current state of vitriolic news media coverage (clearly meant to divide and turn people against each other) began at CNN

If CNN's content was vitriolic and divisive, how would you characterize right-leaning media during the same time?

Also, what are your thought on the fact that Republicans held full control of Congress when the repeal was enacted?

coolgeek··on Met Museum Removes Sackler Name from Wing over Opioid Ties
> Are you thinking of cocaine?

Fentanyl isn't used to cut cocaine. It's used to cut heroin (and possibly other opioids).

Cocaine and heroin have diametrically opposite usage profiles

coolgeek··on Show HN: Grand Unified Divisibility Rule: One divisibility rule for all numbers
I'm not sure if there's a language issue here, or if I'm misinterpreting something, or something else

> For instance, the divisibility rule of 6 is very similar to the divisibility rule of 45732360346.

What does this mean? Are you talking about which numbers factor into these numbers, or which numbers have these numbers as a factor?

The latter meaning is what I've always understood the "divisibility rule" of a number to mean. But it seems like you might be using the term in the first sense.

coolgeek··on We Need to Address Scam Culture
https://archive.ph/pgLFB
← PreviousPage 2 of 19Next →