62°F

Aaron Parecki

  • Articles
  • Notes
  • Photos
  • 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)
  • 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
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