Aaron Parecki

Friday, September 16, 2022

• 
• 

  Contributions from: Australia, France, Germany, Italy, Kuwait, Norway, Switzerland, United Kingdom, United States, Vietnam

  Fri, Sep 16, 2022 4:12am -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
• 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)
• 

  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
• 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`
  

  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
• Joschi Kuphal 吉 https://twitter.com/jkphl   •   Sep 16

  😎 did you try it already? it was off the top of my head …
  

  Yep it worked perfectly!

  Portland, Oregon, USA • 58°F

  1 like

  Fri, Sep 16, 2022 9:01am -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)?

  
  

  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
• 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)
• 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
  

  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
• Guillermo Arellano https://twitter.com/MeetGuillermo   •   Sep 16

  Who needs StackOverflow when you have Twitter?
  

  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
• 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)
• 

  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
• 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)
• 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
  

  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
• Colm MacCárthaigh https://twitter.com/colmmacc

  Ok. tweet thread time! Too long ago I promised to write a screed explaining how much I hated mutual-auth TLS and why. I got distracted, and I wasn't happy with the writing, so here it is in tweet thread form instead! But basically: Client certs and Mutual-Auth TLS is TERRIBAD.

  Portland, Oregon • 68°F

  Mon, Oct 29, 2018 9:12pm +00:00 (liked on Fri, Sep 16, 2022 2:39pm -07:00)
• Randall Degges https://twitter.com/rdegges   •   Sep 16

  Sounds great! What topics are you going to cover? I’m excited =D
  

  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
• 

  Contributions from: Australia, France, Germany, India, Italy, Kuwait, Norway, Switzerland, United Kingdom, United States, Vietnam

  Fri, Sep 16, 2022 5:19pm -07:00
• 

  End of an era 🥲

  

  Portland, Oregon, USA • 67°F

  18 likes 7 replies

  Fri, Sep 16, 2022 5:26pm -07:00 #darksky
• 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?)
  

  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
• tim cappalli | 📍 Vancouver 🇨🇦 https://twitter.com/timcappalli

  Overheard at the bar tonight: "do we have any scripts with credentials embedded?" 😭

  Portland, Oregon • 66°F

  Sat, Sep 17, 2022 12:41am +00:00 (liked on Fri, Sep 16, 2022 5:55pm -07:00)
• Sebastian Bille https://twitter.com/TastefulElk

  The single most expensive phrase in software engineering:
  
  "Maybe we should just build it ourselves instead?"

  Portland, Oregon • 62°F

  Fri, Sep 16, 2022 7:52am +00:00 (liked on Fri, Sep 16, 2022 8:23pm -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.

  
  

  👏 Doing the grunt work for the rest of us 👏

  Portland, Oregon • 61°F

  6 likes

  Fri, Sep 16, 2022 10:05pm -07:00