64°F

Aaron Parecki

  • Articles
  • Notes
  • Photos
  • est (autumnpilled) https://twitter.com/emilyst   •   Sep 19
    I’m being canceled for this take in the replies. Amazing.

    You can already disable the thing (https://support.apple.com/en-us/HT202743), I just wanted it to have a different sound?
    Aaron Parecki
    I don't understand why people are so upset about a criticism of the usability and accessibility of the feature?
    Portland, Oregon • 68°F
    1 reply
    Mon, Sep 19, 2022 9:47pm -07:00
  • Clifton B 💉💉💉🪀🎮 https://twitter.com/CliftonB   •   Sep 20
    I might get crucified for saying so, but not really at all? Unless you specifically read every word in the prompt, which very few people would.
    Aaron Parecki
    you must be a dog person
    Portland, Oregon • 68°F
    1 like 3 replies
    Mon, Sep 19, 2022 9:38pm -07:00
  • Aaron Parecki https://aaronparecki.com/   •   Sep 19
    Is this the best captcha?
    Aaron Parecki
    I think this might actually be only two different cats??
    Portland, Oregon, USA • 68°F
    2 likes 1 reply
    Mon, Sep 19, 2022 9:34pm -07:00
  • Keith Bennett https://twitter.com/keith51032020   •   Sep 20
    Chance to organize some Cables?
    Aaron Parecki
    Yep and also getting rid of a bunch of stuff at a fire sale next weekend!
    Portland, Oregon, USA • 79°F
    Mon, Sep 19, 2022 6:52pm -07:00
  • Faruk 🚀 ᴵᴾᴴᴼᴺᴱᴰᴼ https://twitter.com/iPhonedo   •   Sep 17
    4 hours later AOD is at 99% the rest is still at 100%

    By the way I deliberately placed AOD right under the light to keep it on at max AOD brightness.

    At this point I feel like I can say it drains ~1% battery max in 4 hours.
    Aaron Parecki
    👏 Doing the grunt work for the rest of us 👏
    Portland, Oregon • 61°F
    6 likes
    Fri, Sep 16, 2022 10:05pm -07:00
  • Joe Kirwin https://twitter.com/JosephKirwin   •   Sep 17
    Is that Tornado Cash? (Honestly I don’t know what their logo looks like, but it could be?)
    Aaron Parecki
    I don't know what Tornado Cash is but it sounds like some blkchain bs?

    This is Dark Sky, Apple acquired them a while ago and finally built all the features natively into iOS 16
    Portland, Oregon • 67°F
    2 likes
    Fri, Sep 16, 2022 5:37pm -07:00
  • Randall Degges https://twitter.com/rdegges   •   Sep 16
    Sounds great! What topics are you going to cover? I’m excited =D
    Aaron Parecki
    I'm excited too! It's going to cover a lot of the requirements in FAPI 2.0, including:

    • PKCE
    • Issuer Identifier
    • Pushed Authorization Requests
    • MTLS + Private Key JWT
    • DPoP
    • Non-Repudiation
    Portland, Oregon, USA • 69°F
    1 like 1 reply
    Fri, Sep 16, 2022 3:08pm -07:00
  • 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
  • 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
  • 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
  • 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
  • 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
  • Melissa Santos https://twitter.com/ansate   •   Sep 16
    YES
    Aaron Parecki
    haha I'm so glad it's not just me 😅
    Portland, Oregon • 67°F
    Thu, Sep 15, 2022 8:16pm -07:00
  • Keith Bennett https://twitter.com/keith51032020   •   Sep 16
    I changed credit cards and they lowered my monthly price to 39.99 for the bundle.
    Aaron Parecki
    yeah I threatened to cancel last year and they lowered it to to $29 for the year or something but I am tired of playing that game and really have only been using Lightroom lately anyway. I switched to the Lightroom-only plan for $9.99
    Portland, Oregon, USA
    2 likes 1 reply
    Thu, Sep 15, 2022 6:18pm -07:00
  • Aaron Parecki https://aaronparecki.com/   •   Sep 15
    oops, no https.

    http://cybersanta.pin13.net

    You can see the replies on Twitter too: https://twitter.com/cybersanta/with_replies
    Aaron Parecki
    Twitter was such a different place back then 😅

    https://twitter.com/search?q=%40cybersanta&src=typed_query
    Portland, Oregon, USA • 73°F
    1 like
    Thu, Sep 15, 2022 6:15pm -07:00
  • Aaron Parecki https://aaronparecki.com/   •   Sep 15
    This reminds me of an experiment I did back in the early days of Twitter when you could use the search API to find literally every tweet.

    http://cybersanta.pin13.net

    I ran this a few years in a row, and by 2010 traffic had picked up enough that I was finally hitting rate limits.
    Aaron Parecki
    oops, no https.

    http://cybersanta.pin13.net

    You can see the replies on Twitter too: https://twitter.com/cybersanta/with_replies
    Portland, Oregon, USA • 73°F
    1 reply
    Thu, Sep 15, 2022 6:13pm -07:00
  • Keith Bennett https://twitter.com/keith51032020   •   Sep 16
    Adobe Audition “Loudness Radar” under audio effects. Included free.
    Aaron Parecki
    I just cancelled my Adobe subscription, good thing I got the hardware version of it then 🙃
    Portland, Oregon, USA • 73°F
    3 replies
    Thu, Sep 15, 2022 5:55pm -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