teaearlgraycold's recent activity

  1. Comment on Dear Dad, please don’t vote for Donald Trump this time in ~misc

    teaearlgraycold
    Link Parent
    I don’t have a lot of experience here, but what I have seen is that the most you can do to change a mind is to occasionally nudge it in the right direction. That means maintaining a good...

    I don’t have a lot of experience here, but what I have seen is that the most you can do to change a mind is to occasionally nudge it in the right direction. That means maintaining a good relationship. I don’t think that’s necessarily anyone’s responsibility, though. People are free to shelter themselves from toxicity.

    5 votes
  2. Comment on Hi, How Are You? - Mental Health Support & Discussion Thread (October/November 2020) in ~talk

    teaearlgraycold
    Link Parent
    Not sure if you’re interested in any input here, but this sounds like a good description of how I feel when I experience a panic attack.

    I have something that I could only call “electric shocks that feel like death”

    Not sure if you’re interested in any input here, but this sounds like a good description of how I feel when I experience a panic attack.

    3 votes
  3. Comment on youtube-dl's GitHub repository has become inaccessible due to a DMCA takedown from RIAA in ~tech

    teaearlgraycold
    Link Parent
    I don’t spend much time on the successor, redacted. Does it not have something similar?

    I don’t spend much time on the successor, redacted. Does it not have something similar?

    3 votes
  4. Comment on You will soon need a Microsoft account to play Mojang games (including Minecraft Java edition) in ~games

    teaearlgraycold
    (edited )
    Link Parent
    Yes but it's not on your computer. Maybe I want the app to modify my local filesystem.

    Yes but it's not on your computer. Maybe I want the app to modify my local filesystem.

    1 vote
  5. Comment on You will soon need a Microsoft account to play Mojang games (including Minecraft Java edition) in ~games

    teaearlgraycold
    Link Parent
    Except filesystem support. Native library support. Independence from addons that could give you a broken experience.

    Electron apps don't really offer anything that a regular browser window couldn't

    Except filesystem support. Native library support. Independence from addons that could give you a broken experience.

    3 votes
  6. Comment on You will soon need a Microsoft account to play Mojang games (including Minecraft Java edition) in ~games

    teaearlgraycold
    Link Parent
    Yeah this would be far more palatable if it was a requirement for upcoming Minecraft versions.

    Yeah this would be far more palatable if it was a requirement for upcoming Minecraft versions.

    4 votes
  7. Comment on For those new to working-at-home since the pandemic began: What purchases/subscriptions have most improved your life? in ~life

    teaearlgraycold
    Link Parent
    Some of the motorized ones are trouble anyway. At work the desks we used had no way to detect if something was caught under them. Occasionally people would leave their chairs underneath the desk...

    Some of the motorized ones are trouble anyway. At work the desks we used had no way to detect if something was caught under them. Occasionally people would leave their chairs underneath the desk and hit the sitting position button by accident. You end up with everything on the desk now on the floor.

    3 votes
  8. Comment on Among Us but as a multiplayer text adventure game in ~games

    teaearlgraycold
    Link
    This looks really cool. The code looks nice as well. I'd be interested in coordinating a group play of this. I can host if there's interest.

    This looks really cool. The code looks nice as well. I'd be interested in coordinating a group play of this. I can host if there's interest.

    5 votes
  9. Comment on Do you use the ignore feature? What type of posts do you ignore? in ~tildes

    teaearlgraycold
    Link Parent
    Seems to me like it's useless for you to have that power if you ask Deimos before taking the action.

    Seems to me like it's useless for you to have that power if you ask Deimos before taking the action.

    1 vote
  10. Comment on Inside the Republican plot for permanent minority rule in ~misc

    teaearlgraycold
    Link Parent
    Why wouldn't the Republicans just add more justices to the Supreme Court?

    Why wouldn't the Republicans just add more justices to the Supreme Court?

  11. Comment on Revamped PlayStation Store ditches PS3, Vita, PSP content in ~games

    teaearlgraycold
    Link Parent
    I had so much fun running homebrew on my PSP. That ecosystem is something that could never happen on purpose. You had a massive electronics company with some good 1st party IP and adoption from...

    I had so much fun running homebrew on my PSP. That ecosystem is something that could never happen on purpose. You had a massive electronics company with some good 1st party IP and adoption from 3rd party vendors building software for a not-too-unpopular architecture (MIPS). Then it turned out this WiFi-enabled device had fairly poor security, which meant hardware that was already in the hands of tons of people gained a second software delivery channel.

    People have tried many times to capture that with purpose-built open devices. But they don't have the money behind them to reach critical mass.

    3 votes
  12. Comment on 'Person in jetpack' spotted flying again near LA airport in ~news

    teaearlgraycold
    Link
    This is the headline that makes me want to see the reaction from people 20 years ago. Interestingly, we've already had a taste of this with cheap drones. A lot of people fly them illegally. If jet...

    This is the headline that makes me want to see the reaction from people 20 years ago.

    Interestingly, we've already had a taste of this with cheap drones. A lot of people fly them illegally. If jet packs become more accessible I see incidents like this becoming more common place. The average person hasn't seen an a comparable increase in their ability to do stupid things since the invention of the car.

    2 votes
  13. Comment on First it was toilet paper—now we’re running out of fridges. Here’s why in ~finance

    teaearlgraycold
    Link Parent
    Or you could buy a $20 electric kettle and put it on your counter.

    Or you could buy a $20 electric kettle and put it on your counter.

    7 votes
  14. Comment on Smart watch recommendations? in ~tech

    teaearlgraycold
    Link Parent
    Thanks for this recommendation. I've been looking for something exactly like this.

    Thanks for this recommendation. I've been looking for something exactly like this.

    1 vote
  15. Comment on AMD Ryzen 5000 and Zen 3 on Nov 5th: +19% IPC, claims best gaming CPU in ~tech

    teaearlgraycold
    Link
    Why is AMD's stock value down if Zen 3 looks so good?

    Why is AMD's stock value down if Zen 3 looks so good?

    3 votes
  16. Comment on I am not a "Cyclist" in ~life

    teaearlgraycold
    Link Parent
    I combine exercise and errands all of the time. I don't personally use an e-bike though as I have time to spare and want to maximize the exercise part.

    I combine exercise and errands all of the time. I don't personally use an e-bike though as I have time to spare and want to maximize the exercise part.

    1 vote
  17. Comment on Why do you wanna be a parent? in ~talk

    teaearlgraycold
    Link Parent
    I was definitely more trouble as a teenager than I was as a child. But I feel like myself and my brothers do not fit that mold.

    I was definitely more trouble as a teenager than I was as a child. But I feel like myself and my brothers do not fit that mold.

  18. Comment on President Trump and first lady Melania have tested positive for coronavirus in ~news

  19. Comment on Simple anomaly detection using plain SQL in ~comp

    teaearlgraycold
    Link
    -- Wrong! SELECT date_trunc('minute', timestamp) AS period, status_code, count(*) AS entries FROM server_log GROUP BY period, status_code; -- Correct! WITH axis AS ( SELECT status_code,...

    Note that the table has a row for every minute, even if the status code was never returned in that minute. Given a table of statuses, it's very tempting to do something like this:

    -- Wrong!
    SELECT
       date_trunc('minute', timestamp) AS period,
       status_code,
       count(*) AS entries
    FROM
       server_log
    GROUP BY
       period,
       status_code;
    

    This is a common mistake and it can leave you with gaps in the data. Zero is a value, and it holds a significant meaning. A better approach is to create an "axis", and join to it:

    -- Correct!
    WITH axis AS (
       SELECT
           status_code,
           generate_series(
               date_trunc('minute', now()),
               date_trunc('minute', now() - interval '1 hour'),
               interval '1 minute' * -1
           ) AS period
       FROM (
           VALUES (200), (400), (404), (500)
       ) AS t(status_code)
    )
    SELECT
       a.period,
       a.status_code,
       count(*) AS entries
    FROM
       axis a
       LEFT JOIN server_log l ON (
           date_trunc('minute', l.timestamp) = a.period
           AND l.status_code = a.status_code
       )
    GROUP BY
       period,
       status_code;
    

    If I understand correctly, the problem the author is highlighting here is that in the "wrong" result set you'll skip over time frames without any data. Wouldn't this just come down to what tool you use to visualize your data? I would expect many visualizers would fill in the gaps with 0s.

    1 vote
  20. Comment on Trump’s taxes show chronic losses and years of income tax avoidance in ~news

    teaearlgraycold
    Link Parent
    They already loved him in 2016 when he said avoiding taxes makes him smart. “This will really upset the reasonable people.” says the person that has sabotaged their ability to reason.

    To see how he avoids paying taxes while Americans everywhere struggle to pay their bills?

    They already loved him in 2016 when he said avoiding taxes makes him smart.


    “This will really upset the reasonable people.” says the person that has sabotaged their ability to reason.

    5 votes