73°F

Aaron Parecki

  • Articles
  • Notes
  • Photos
  • PhotoJoseph https://twitter.com/photojoseph   •   Sep 16
    For anyone into aircraft, the Reno air races are on right now. I was supposed to go this weekend but it’s super smokey in Reno so we’re sitting it out. However, there’s a live stream and an FA-18 is about to do a demo! https://youtu.be/b4aYb7jTNjc
    Aaron Parecki
    whoa that is some serious smoke, I can't believe they still want to fly in that
    Portland, Oregon, USA • 68°F
    1 reply
    Fri, Sep 16, 2022 2:21pm -07:00
  • Ricky Mondello https://twitter.com/rmondello
    We don’t need multi-factor authentication to protect against attacks like the ones in the news. We need unphishable credentials, like passkeys. Security doesn’t need to be cumbersome; “multi” is where lots of mitigations fail in practice. Ditch passwords; don’t bolt onto them.
    Portland, Oregon • 68°F
    Fri, Sep 16, 2022 4:52pm +00:00 (liked on Fri, Sep 16, 2022 2:16pm -07:00)
  • Aaron Parecki
    I'm working on a new video course, (tentatively) called "Advanced OAuth Security"!

    If you'd like to be the first to hear when it goes live, you can sign up for my email list here!

    https://oauth2simplified.com
    Portland, Oregon, USA • 68°F
    15 likes 5 replies
    Fri, Sep 16, 2022 2:13pm -07:00 #oauth
  • Sanjana Curtis! https://twitter.com/sanjanacurtis
    why is everyone looking for planets we are literally on one ?? ur welcome
    Portland, Oregon • 60°F
    Fri, Sep 16, 2022 4:16pm +00:00 (liked on Fri, Sep 16, 2022 9:58am -07:00)
  • Guillermo Arellano https://twitter.com/MeetGuillermo   •   Sep 16
    Who needs StackOverflow when you have Twitter?
    Aaron Parecki
    my problem was I couldn't even figure out how to ask this with words so I wasn't sure what to search for!
    Portland, Oregon, USA • 58°F
    Fri, Sep 16, 2022 9:24am -07:00
  • Paola Villarreal https://twitter.com/paw   •   Sep 16
    Select extract(date from date), sum(success) success, sum(if(success = 0, 1, 0)) fail from tbl group by 1 order by 1
    Aaron Parecki
    Nice!

    Apparently EXTRACT(DATE FROM col) doesn't exist in MySQL, but DATE(col) works instead. So:

    SELECT DATE(date) AS date, SUM(success) AS success, SUM(IF(success, 0, 1)) AS fail
    FROM results GROUP by 1 ORDER BY 1 DESC;
    Portland, Oregon, USA • 58°F
    Fri, Sep 16, 2022 9:16am -07:00
  • Ian Coldwater 📦💥 https://twitter.com/IanColdwater
    If phishing a single employee can lead to everything in your infrastructure being compromised that easily, that employee is not to blame
    Portland, Oregon • 58°F
    Fri, Sep 16, 2022 9:30am +00:00 (liked on Fri, Sep 16, 2022 9:06am -07:00)
  • Aaron Parecki https://aaronparecki.com/   •   Sep 16
    Any clever SQL people out there? Given the raw data on the left, (a table of test results) how do I write a SQL query to give me the results on the right, (the results grouped by date as well as grouped by result)?
    Aaron Parecki
    That was fast, we have a winner!

    SELECT `date`, SUM(IF(success, 1, 0)) AS `success`, SUM(IF(success, 0, 1)) AS `fail`
    FROM `results` GROUP BY `date`

    https://twitter.com/jkphl/status/1570804284060475392
    Portland, Oregon, USA • 58°F
    10 likes 3 replies
    Fri, Sep 16, 2022 9:01am -07:00
  • Joschi Kuphal 吉 https://twitter.com/jkphl   •   Sep 16
    😎 did you try it already? it was off the top of my head …
    Aaron Parecki
    Yep it worked perfectly!
    Portland, Oregon, USA • 58°F
    1 like
    Fri, Sep 16, 2022 9:01am -07:00
  • Joschi Kuphal 吉 https://twitter.com/jkphl   •   Sep 16
    something like this or similar (untested)?:

    SELECT `date`, SUM(IF(success, 1, 0)) AS `success`, SUM(IF(success, 0, 1)) AS `fail` FROM t GROUP BY `date`
    Aaron Parecki
    you win! That's brilliant, I didn't even think about using an `IF`!
    Portland, Oregon, USA • 58°F
    1 like 2 replies
    Fri, Sep 16, 2022 8:59am -07:00
  • Aaron Parecki
    Any clever SQL people out there? Given the raw data on the left, (a table of test results) how do I write a SQL query to give me the results on the right, (the results grouped by date as well as grouped by result)?
    Portland, Oregon, USA • 57°F
    6 likes 3 reposts 12 replies 1 mention
    Fri, Sep 16, 2022 8:51am -07:00 #sql
  • Sarah https://twitter.com/RahisRahisRah
    As a resident with a driveway directly in front of the circle I’m pretty pleased with these accommodations. While ideally they would add abatements and keep the circle, giving us more than painted lines is hopeful. I’m particularly stoked they are taking away parking.
    Portland, Oregon • 56°F
    Fri, Sep 16, 2022 4:36am +00:00 (liked on Fri, Sep 16, 2022 7:50am -07:00)
  • 10:46pm
    Asleep
    6:17am
    Awake
    7h 31m
    Slept
    12m
    Awake for
    Portland, Oregon, USA • 58°F
    Fri, Sep 16, 2022 6:17am -07:00
  • Aaron Parecki
    Contributions from: Australia, France, Germany, Italy, Kuwait, Norway, Switzerland, United Kingdom, United States, Vietnam
    Fri, Sep 16, 2022 4:12am -07:00
  • Matt Boyd https://twitter.com/3PSboyd
    Anyway, proof of stake seems like a much less destructive way to give more money to the people who have the most money than making them feed GPUs into a wood chipper as an intermediate step.
    Portland, Oregon • 64°F
    Thu, Sep 15, 2022 1:39pm +00:00 (liked on Thu, Sep 15, 2022 10:20pm -07:00)
  • Techni-Calli https://twitter.com/Iwillleavenow
    Look, if you can't market your thing without building individual profiles on people made up of data you and your buddies track and swap like you're trading the world's creepiest pokemon cards, maybe you're bad at marketing, idk.
    Portland, Oregon • 64°F
    Thu, Sep 15, 2022 3:57pm +00:00 (liked on Thu, Sep 15, 2022 10:19pm -07:00)
  • BikePortland https://twitter.com/BikePortland   •   Sep 16
    UPDATE: As expected, @PBOTinfo has shared a revised proposal with the neighborhood group. Looks like they’re willing to add one speed bump and a concrete barricade/planter. We’ve added the new plan graphic to our story https://bikeportland.org/2022/09/15/eliot-residents-meet-pbot-in-the-street-to-air-grievances-and-urge-more-traffic-calming-363545
    Aaron Parecki
    This is better, but I'm still concerned about the sharp right turn a bike will have to make to get on to the 7th bike lane when going west on Tillamook. How can I give them this feedback?
    Portland, Oregon • 66°F
    1 like
    Thu, Sep 15, 2022 9:16pm -07:00
  • Aaron Parecki
    Contributions from: Australia, France, Germany, Italy, Kuwait, Norway, Switzerland, United Kingdom, United States
    Thu, Sep 15, 2022 8:31pm -07:00
  • iJustine https://twitter.com/ijustine   •   Sep 16
    It is though
    Aaron Parecki
    we are very special kinds of people
    Portland, Oregon • 67°F
    3 likes
    Thu, Sep 15, 2022 8:19pm -07:00
  • Rachel Tobac https://twitter.com/RachelTobac
    Why are we seeing an increase in SMS-based phishing? Because it's working, becoming increasingly well documented by attackers, and there are now kits that make it easier to develop attacks to steal passwords and MFA codes. Could FIDO security keys have prevented this? Likely yes.
    Portland, Oregon • 67°F
    Fri, Sep 16, 2022 3:16am +00:00 (liked on Thu, Sep 15, 2022 8:17pm -07:00)
older

Hi, I'm Aaron Parecki, Director of Identity Standards at Okta, and co-founder of IndieWebCamp. I maintain oauth.net, write and consult about OAuth, and participate in the OAuth Working Group at the IETF. I also help people learn about video production and livestreaming. (detailed bio)

I've been tracking my location since 2008 and I wrote 100 songs in 100 days. I've spoken at conferences around the world about owning your data, OAuth, quantified self, and explained why R is a vowel. Read more.

  • Director of Identity Standards at Okta
  • IndieWebCamp Founder
  • OAuth WG Editor
  • OpenID Board Member

  • 🎥 YouTube Tutorials and Reviews
  • 🏠 We're building a triplex!
  • ⭐️ Life Stack
  • ⚙️ Home Automation
  • All
  • Articles
  • Bookmarks
  • Notes
  • Photos
  • Replies
  • Reviews
  • Trips
  • Videos
  • Contact
© 1999-2025 by Aaron Parecki. Powered by p3k. This site supports Webmention.
Except where otherwise noted, text content on this site is licensed under a Creative Commons Attribution 3.0 License.
IndieWebCamp Microformats Webmention W3C HTML5 Creative Commons
WeChat ID
aaronpk_tv