Ō̴̡̨͍͕̠̹̘͖͓̭̝̰̖͉̬̫͍̝̰̟͖͖̞͇̟̻̫͇̠̯̋̋̂ͅͅA̷̡̧͎̫̬͖̠͍̼̗̠͊̉̏̓̈́̂̀̈́͆͘͜uth @oktadev oauth.wtf oauth.net 🎥 livestreaming youtube.com/aaronpk aaronpk.tv 💛 #indieweb 🐘🦋
Portland, Oregon
Joined April 2008
- Tweets 11,388
- Following 1,223
- Followers 6,415
- Likes 9,609
So awesome that I get to spend my first day of PTO tearing up my desk so the landlord can get to the windows to measure them 🙄
1
1
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
1
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
1
1
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!
oauth2simplified.com
2
15
my problem was I couldn't even figure out how to ask this with words so I wasn't sure what to search for!
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;
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`
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`
3
6
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)?
4
1
3
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?
1
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?
1
2