70°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
  • 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)
  • 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
  • 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)
  • 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
  • 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
  • BikePortland https://twitter.com/BikePortland
    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
    Portland, Oregon • 68°F
    Fri, Sep 16, 2022 1:48am +00:00 (liked on Thu, Sep 15, 2022 7:46pm -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
  • OAuth WG

    New Draft of OAuth for Browser-Based Apps (Draft -11)

    With the help of a few kind folks, we've made some updates to the OAuth 2.0 for Browser-Based Apps draft as discussed during the last IETF meeting in Philadelphia.
    continue reading...
    Thu, Sep 15, 2022 6:04pm -07:00 #oauth #oauth2
  • 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
  • Akhmad Fathonih https://twitter.com/neofreko
    Anyone who want to establish a brand in Twitter should pay attention to what @cybersanta does.
    Portland, Oregon • 73°F
    Fri, Dec 19, 2008 1:57am +00:00 (liked on Thu, Sep 15, 2022 5:51pm -07:00)
  • Simon Willison https://twitter.com/simonw   •   Sep 16
    Wow no I was wrong, it's stupider than that: the bot apparently runs twitter searches for "remote work and remote jobs" and replies even to people who didn't tag it!
    Aaron Parecki
    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.
    Portland, Oregon, USA • 73°F
    1 like 1 reply
    Thu, Sep 15, 2022 5:48pm -07:00
  • https://mobile.twitter.com/ProductHunt/status/1567269922194997255
    Portland, Oregon • 71°F
    Thu, Sep 15, 2022 1:57pm -07:00
  • Jonathan Maus https://twitter.com/Jonathan_Maus
    i think a lot. Work from home has also been a massive shift. Ppl are home more, they are more connected to their n'hood and local streets.
    Portland, Oregon • 71°F
    Thu, Sep 15, 2022 7:59pm +00:00 (liked on Thu, Sep 15, 2022 1:44pm -07:00)
  • Simon Willison https://twitter.com/simonw   •   Sep 15
    Yeah that bot is getting absolutely hammered right now https://twitter.com/switchs03468828/status/1570499883894996993
    Aaron Parecki
    For those of us who have not followed this as closely, what is the bot *supposed* to reply back with? As in what did the company intend the bot to respond with? Also why do all the prompts start with "When it comes to remote work and remote jobs"? Is that part of tricking it?
    Portland, Oregon, USA • 71°F
    2 replies
    Thu, Sep 15, 2022 1:36pm -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