66°F

Aaron Parecki

  • Articles
  • Notes
  • Photos
  • 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
  • Aaron Parecki
    Do you ever do the thing in @duolingo where you're given a sentence in the language you're learning and you immediately understand it in your native language and then mistakenly think the task is to type it back in the foreign language?
    Portland, Oregon, USA • 67°F
    4 likes 5 replies
    Thu, Sep 15, 2022 8:13pm -07:00 #duolingo
  • Aaron Parecki
    Is installing a Unifi Door Access system for my front door overkill? Yes.

    Do I want to do it anyway? Absolutely.
    Portland, Oregon, USA • 64°F
    11 likes 3 replies
    Thu, Sep 15, 2022 10:38am -07:00 #homeautomation
  • Aaron Parecki
    Turns out if you buy someone an @AlaskaAir flight with your airline miles, it gets added to your own Alaska account, and then you get push notifications when their flight starts boarding and have a mild panic because you thought you were supposed to be at the airport
    Portland, Oregon, USA • 69°F
    8 likes 1 reply
    Wed, Sep 14, 2022 7:23pm -07:00 #travel
  • Aaron Parecki
    Just published a new version of OAuth 2.0 for Browser-Based Apps!

    https://www.ietf.org/archive/id/draft-ietf-oauth-browser-based-apps-11.html

    If you have feelings about tokens in browsers, please feel free to chime in on the discussion! You can comment on the mailing list or open issues on the GitHub repo linked from the doc!
    Portland, Oregon, USA • 67°F
    19 likes 3 reposts 1 reply
    Tue, Sep 13, 2022 11:26am -07:00 #oauth
  • Aaron Parecki
    The last car I owned was a 1985 Volvo, and this is just one of the many reasons I have no interest in owning a car ever again https://twitter.com/motherfuton/status/1569123477143318528
    Portland, Oregon, USA • 63°F
    1 like
    Tue, Sep 13, 2022 9:20am -07:00 #ux
  • Aaron Parecki
    The list of supported SD cards for the Hyperdeck recorders was updated recently, and there are only 3 SD card brands on the list now 😬

    The good news is the ProGrade V90 cards are on that list, and they just went on sale for 15% off!

    https://geni.us/Jorc
    Portland, Oregon, USA
    2 replies
    Mon, Sep 12, 2022 6:42pm -07:00 #blackmagic #hyperdeck #sdcard
  • Aaron Parecki
    Well today was weird
    Portland, Oregon, USA • 75°F
    6 likes 6 replies
    Sat, Sep 10, 2022 9:51pm -07:00 #climate #aqi #pdx
  • Aaron Parecki
    People comparing this to "every NFL match" as if that somehow makes any of it okay??? https://twitter.com/jimbarrett/status/1567852793406410753
    Portland, Oregon, USA • 69°F
    5 likes 2 replies
    Thu, Sep 8, 2022 9:16pm -07:00
  • Aaron Parecki
    As I'm sure comes at no surprise, given the deadline is next week, the FAA is delaying the enforcement of Remote ID for another 3 months to give drone manufacturers more time to figure things out. https://twitter.com/faadronezone/status/1567651060378107904
    Portland, Oregon, USA • 70°F
    4 likes 2 replies
    Thu, Sep 8, 2022 8:41pm -07:00 #remoteid
  • Aaron Parecki
    I know I shouldn't make jokes about the Queen but there is literally nowhere higher to punch up
    Portland, Oregon, USA • 78°F
    12 likes 3 replies
    Thu, Sep 8, 2022 6:25pm -07:00
  • Aaron Parecki
    adding something to my todo list seems to be the best way to make sure I put it off as long as possible
    Portland, Oregon, USA • 72°F
    24 likes 1 repost 2 replies
    Wed, Sep 7, 2022 8:18pm -07:00 #productivity
  • Aaron Parecki
    Alright, who's ready to watch 90 minutes of Apple ads! Let's goooooo #AppleEvent
    Portland, Oregon, USA • 69°F
    12 likes 1 repost 1 reply
    Wed, Sep 7, 2022 10:00am -07:00 #apple #appleevent
  • Aaron Parecki
    Sometimes I get annoyed that it takes me 10 hours to make a video that takes you 10 minutes to watch.

    So my goal with every video is that it gets at least as much total watch time as it took me to make it, then it's worth it.
    Portland, Oregon, USA • 71°F
    31 likes 5 replies
    Mon, Sep 5, 2022 8:43pm -07:00 #video
  • Aaron Parecki
    I just spent 4 hours downloading and organizing files off of 6 different SD cards with footage from the last year. How did I let it go this long??
    Portland, Oregon, USA • 71°F
    5 likes
    Mon, Sep 5, 2022 12:08pm -07:00 #organizing
  • Aaron Parecki
    oauth
    Portland, Oregon, USA • 86°F
    15 likes 4 replies
    Thu, Sep 1, 2022 2:27pm -07:00 #meme
  • Aaron Parecki
    Dear Brands™

    If you work with a PR agency for your outreach to creators, *please* give them an email address at your company domain, otherwise when I get an email "on behalf of X brand" I have no way of verifying this is legitimate, and this is exactly how channels get hacked.
    Portland, Oregon, USA • 76°F
    11 likes 2 replies
    Wed, Aug 31, 2022 9:08pm -07:00 #youtube
  • Aaron Parecki
    well I did my (very small) part and migrated my two websites off of Cloudflare today. I'm sure my origin server can handle the extra 26gb/mo of traffic itself just fine.
    Portland, Oregon, USA • 85°F
    18 likes 1 repost 7 replies
    Wed, Aug 31, 2022 1:00pm -07:00 #cloudflare
  • Aaron Parecki
    So... how long until I can train an AI model with a bunch of talking head videos of myself and then type out a script and have it generate a video of me speaking? Seems like we're not that far off.

    Sure would speed up the process of filming all this course content.
    Portland, Oregon, USA • 98°F
    4 likes 1 repost 5 replies
    Tue, Aug 30, 2022 4:44pm -07:00 #ai
  • Aaron Parecki
    I just updated my PHP emoji detector library to Emoji 14.0! Better late than never! My new favorites:

    🫠 Melting Face (how I feel when it is continuously this hot in Portland)
    🪫 Low Battery (me after a long day of travel)

    https://github.com/aaronpk/emoji-detector-php
    Portland, Oregon, USA • 97°F
    2 likes 1 repost
    Tue, Aug 30, 2022 4:18pm -07:00 #emoji
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