{
    "type": "entry",
    "published": "2022-09-16T08:51:12-07:00",
    "url": "https://aaronparecki.com/2022/09/16/6/sql",
    "category": [
        "sql"
    ],
    "photo": [
        "https://aperture-media.p3k.io/aaronparecki.com/0faf847ebef3d33e2bf285f969f4e60a13cb764b6ad88ed3a8e0d712ffac17f7.png"
    ],
    "syndication": [
        "https://twitter.com/aaronpk/status/1570802509509464064"
    ],
    "content": {
        "text": "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)?"
    },
    "author": {
        "type": "card",
        "name": "Aaron Parecki",
        "url": "https://aaronparecki.com/",
        "photo": "https://aperture-media.p3k.io/aaronparecki.com/41061f9de825966faa22e9c42830e1d4a614a321213b4575b9488aa93f89817a.jpg"
    },
    "post-type": "photo",
    "_id": "31413099",
    "_source": "16"
}

{
    "type": "entry",
    "published": "2022-09-16T15:30:34+00:00",
    "url": "https://twitter.com/ZoeSchiffer/status/1570797297780535299",
    "quotation-of": "https://twitter.com/RMac18/status/1570712073793044481",
    "content": {
        "text": "Exciting to see more reporting on the people with power at TikTok:\ntwitter.com/rmac18/status/\u2026",
        "html": "Exciting to see more reporting on the people with power at TikTok:\n<a href=\"https://twitter.com/rmac18/status/1570712073793044481\">twitter.com/rmac18/status/\u2026</a>"
    },
    "author": {
        "type": "card",
        "name": "Zo\u00eb Schiffer",
        "url": "https://twitter.com/ZoeSchiffer",
        "photo": "https://pbs.twimg.com/profile_images/1564799885794086914/ZU6qMT_n.jpg"
    },
    "post-type": "note",
    "refs": {
        "https://twitter.com/RMac18/status/1570712073793044481": {
            "type": "entry",
            "published": "2022-09-16T09:51:55+00:00",
            "url": "https://twitter.com/RMac18/status/1570712073793044481",
            "content": {
                "text": "TikTok CEO Shou Zi Chew has been in the job for more than a year, but has done little press. We took a look at how he's been running the world's most popular app, and how he's navigating pressure from the US and his Chinese parent company, ByteDance: nytimes.com/2022/09/16/tec\u2026",
                "html": "TikTok CEO Shou Zi Chew has been in the job for more than a year, but has done little press. We took a look at how he's been running the world's most popular app, and how he's navigating pressure from the US and his Chinese parent company, ByteDance: <a href=\"https://www.nytimes.com/2022/09/16/technology/tiktok-ceo-shou-zi-chew.html\">nytimes.com/2022/09/16/tec\u2026</a>"
            },
            "author": {
                "type": "card",
                "name": "Ryan Mac \ud83d\ude43",
                "url": "https://twitter.com/RMac18",
                "photo": "https://pbs.twimg.com/profile_images/1386038508070924288/Ml-kne2a.jpg"
            },
            "post-type": "note"
        }
    },
    "_id": "31412841",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-16T12:07:30+00:00",
    "url": "https://twitter.com/karabaic/status/1570746196301578243",
    "quotation-of": "https://twitter.com/yvessmith/status/1570727583737868288",
    "content": {
        "text": "Oh jeez. This piece goes off the deep end quickly and the gains speed. The uninformed criticism over the lack of human testing for the bivalent COVID vaccine is where I stopped reading. A hot take uniformed by science or practicality."
    },
    "author": {
        "type": "card",
        "name": "jack the nonabrasive",
        "url": "https://twitter.com/karabaic",
        "photo": "https://pbs.twimg.com/profile_images/1256785873384861696/QfRzUvne.jpg"
    },
    "post-type": "note",
    "refs": {
        "https://twitter.com/yvessmith/status/1570727583737868288": {
            "type": "entry",
            "published": "2022-09-16T10:53:33+00:00",
            "url": "https://twitter.com/yvessmith/status/1570727583737868288",
            "content": {
                "text": "EU Hypocrisy Hits Dizzying New Heights As Commission\u2019s Scandal-Tarnished President Pledges to Wage Global Fight on Corruption dlvr.it/SYR8wJ",
                "html": "EU Hypocrisy Hits Dizzying New Heights As Commission\u2019s Scandal-Tarnished President Pledges to Wage Global Fight on Corruption <a href=\"http://dlvr.it/SYR8wJ\">dlvr.it/SYR8wJ</a>"
            },
            "author": {
                "type": "card",
                "name": "Yves Smith",
                "url": "https://twitter.com/yvessmith",
                "photo": "https://pbs.twimg.com/profile_images/1316923712/Screen_shot_2011-04-16_at_1.04.58_AM.png"
            },
            "post-type": "note"
        }
    },
    "_id": "31409000",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-16T04:41:58+00:00",
    "url": "https://twitter.com/karabaic/status/1570634072329945091",
    "video": [
        "https://video.twimg.com/tweet_video/FcwDXJIaMAEghxf.mp4"
    ],
    "content": {
        "text": "#SpearLives",
        "html": "<a href=\"https://twitter.com/search?q=%23SpearLives\">#SpearLives</a>"
    },
    "author": {
        "type": "card",
        "name": "jack the nonabrasive",
        "url": "https://twitter.com/karabaic",
        "photo": "https://pbs.twimg.com/profile_images/1256785873384861696/QfRzUvne.jpg"
    },
    "post-type": "video",
    "_id": "31403776",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-16T03:16:10+00:00",
    "url": "https://twitter.com/cleverdevil/status/1570612479146991622",
    "content": {
        "text": "Justin Herbert made an absolutely elite throw and I am pretty sure his bones are liquified."
    },
    "author": {
        "type": "card",
        "name": "Jonathan LaCour",
        "url": "https://twitter.com/cleverdevil",
        "photo": "https://pbs.twimg.com/profile_images/1518010782369284096/7Ac_gJRN.jpg"
    },
    "post-type": "note",
    "_id": "31402962",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-16T03:14:02+00:00",
    "url": "https://twitter.com/aaronpk/status/1570611942578081795",
    "content": {
        "text": "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?",
        "html": "Do you ever do the thing in <a href=\"https://twitter.com/duolingo\">@duolingo</a> 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?"
    },
    "author": {
        "type": "card",
        "name": "Aaron Parecki",
        "url": "https://twitter.com/aaronpk",
        "photo": "https://pbs.twimg.com/profile_images/1477113672803622912/ljLUwFLP.jpg"
    },
    "post-type": "note",
    "_id": "31402963",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-15T20:13:58-07:00",
    "url": "https://aaronparecki.com/2022/09/15/36/duolingo",
    "category": [
        "duolingo"
    ],
    "content": {
        "text": "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?",
        "html": "Do you ever do the thing in <a href=\"https://twitter.com/duolingo\">@duolingo</a> 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?"
    },
    "author": {
        "type": "card",
        "name": "Aaron Parecki",
        "url": "https://aaronparecki.com/",
        "photo": "https://aperture-media.p3k.io/aaronparecki.com/41061f9de825966faa22e9c42830e1d4a614a321213b4575b9488aa93f89817a.jpg"
    },
    "post-type": "note",
    "_id": "31402859",
    "_source": "16"
}

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

{
    "type": "entry",
    "published": "2022-09-15T18:04:51-07:00",
    "summary": "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.",
    "url": "https://aaronparecki.com/2022/09/15/30/browser-oauth",
    "category": [
        "oauth",
        "oauth2"
    ],
    "syndication": [
        "https://mailarchive.ietf.org/arch/msg/oauth/-tMD2ahhs8CmlgMp-Uh2E8k76gg/"
    ],
    "name": "New Draft of OAuth for Browser-Based Apps (Draft -11)",
    "author": {
        "type": "card",
        "name": "Aaron Parecki",
        "url": "https://aaronparecki.com/",
        "photo": "https://aperture-media.p3k.io/aaronparecki.com/41061f9de825966faa22e9c42830e1d4a614a321213b4575b9488aa93f89817a.jpg"
    },
    "post-type": "article",
    "_id": "31401677",
    "_source": "16"
}

{
    "type": "entry",
    "published": "2022-09-15T23:11:26+00:00",
    "url": "https://twitter.com/afitnerd/status/1570550892163923969",
    "photo": [
        "https://pbs.twimg.com/media/Fcu3tg1XEAIvjfU.jpg"
    ],
    "content": {
        "text": "Watching @rdegges talk about Developer Horror Stories. Great stuff! #DevSecCon",
        "html": "Watching <a href=\"https://twitter.com/rdegges\">@rdegges</a> talk about Developer Horror Stories. Great stuff! <a href=\"https://twitter.com/search?q=%23DevSecCon\">#DevSecCon</a>"
    },
    "author": {
        "type": "card",
        "name": "Micah Silverman - #StopWar",
        "url": "https://twitter.com/afitnerd",
        "photo": "https://pbs.twimg.com/profile_images/1169746170740137984/R7RpX8Q7.jpg"
    },
    "post-type": "photo",
    "_id": "31400247",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-15T22:25:00+00:00",
    "url": "https://twitter.com/afitnerd/status/1570539204555186177",
    "content": {
        "text": "Going live in 5 minutes! #DevSecCon : youtube.com/watch?v=3biG2c\u2026 #DevSecCon",
        "html": "Going live in 5 minutes! <a href=\"https://twitter.com/search?q=%23DevSecCon\">#DevSecCon</a> : <a href=\"https://youtube.com/watch?v=3biG2cnMSJg\">youtube.com/watch?v=3biG2c\u2026</a> <a href=\"https://twitter.com/search?q=%23DevSecCon\">#DevSecCon</a>"
    },
    "author": {
        "type": "card",
        "name": "Micah Silverman - #StopWar",
        "url": "https://twitter.com/afitnerd",
        "photo": "https://pbs.twimg.com/profile_images/1169746170740137984/R7RpX8Q7.jpg"
    },
    "post-type": "note",
    "_id": "31399795",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-15T21:33:54+00:00",
    "url": "https://twitter.com/afitnerd/status/1570526346803294212",
    "content": {
        "text": "Got VA Beach and NYC in the house! Come join us - in person at 15 W. 38th St., floor 2 or online at: youtube.com/watch?v=3biG2c\u2026 #DevSecCon",
        "html": "Got VA Beach and NYC in the house! Come join us - in person at 15 W. 38th St., floor 2 or online at: <a href=\"https://youtube.com/watch?v=3biG2cnMSJg\">youtube.com/watch?v=3biG2c\u2026</a> <a href=\"https://twitter.com/search?q=%23DevSecCon\">#DevSecCon</a>"
    },
    "author": {
        "type": "card",
        "name": "Micah Silverman - #StopWar",
        "url": "https://twitter.com/afitnerd",
        "photo": "https://pbs.twimg.com/profile_images/1169746170740137984/R7RpX8Q7.jpg"
    },
    "post-type": "note",
    "_id": "31398987",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-15T21:33:08+00:00",
    "url": "https://twitter.com/matthewmcvickar/status/1570526151180947456",
    "photo": [
        "https://pbs.twimg.com/media/FcuhNV-aAAACB4M.jpg"
    ],
    "content": {
        "text": "Awesome, we\u2019ve reached the point of begging drivers to stop at red lights."
    },
    "author": {
        "type": "card",
        "name": "Matthew McVickar",
        "url": "https://twitter.com/matthewmcvickar",
        "photo": "https://pbs.twimg.com/profile_images/1381462476080828418/kiDKMIEj.jpg"
    },
    "post-type": "photo",
    "_id": "31398988",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-15T21:24:22+00:00",
    "url": "https://twitter.com/cleverdevil/status/1570523945300004866",
    "content": {
        "text": "Miami's best WR is out against the Aggies this weekend, and they're going to be playing with a chip on their shoulder after getting embarrassed last week. There is a reason A&M was highly ranked pre-season \u2013 they're talented. Time for the rest of the WR room to prove itself.",
        "html": "Miami's best WR is out against the Aggies this weekend, and they're going to be playing with a chip on their shoulder after getting embarrassed last week. There is a reason A&M was highly ranked pre-season \u2013 they're talented. Time for the rest of the WR room to prove itself."
    },
    "author": {
        "type": "card",
        "name": "Jonathan LaCour",
        "url": "https://twitter.com/cleverdevil",
        "photo": "https://pbs.twimg.com/profile_images/1518010782369284096/7Ac_gJRN.jpg"
    },
    "post-type": "note",
    "_id": "31398730",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-15T21:18:48+00:00",
    "url": "https://twitter.com/Johannes_Ernst/status/1570522545367154696",
    "content": {
        "text": "Congratulations to everybody involved in the #EthereumMerge. As changing engines in a flying airplane goes, this was a real complicated one. More like changing all engines of an entire fleet of airplanes at the same time, without knowing all the airplanes involved.",
        "html": "Congratulations to everybody involved in the <a href=\"https://twitter.com/search?q=%23EthereumMerge\">#EthereumMerge</a>. As changing engines in a flying airplane goes, this was a real complicated one. More like changing all engines of an entire fleet of airplanes at the same time, without knowing all the airplanes involved."
    },
    "author": {
        "type": "card",
        "name": "Johannes Ernst",
        "url": "https://twitter.com/Johannes_Ernst",
        "photo": "https://pbs.twimg.com/profile_images/1482154224800526337/NjdX1tt7.jpg"
    },
    "post-type": "note",
    "_id": "31398731",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-15T17:50:19+00:00",
    "url": "https://twitter.com/jaredcwhite/status/1570470080613617665",
    "quotation-of": "https://twitter.com/morewry/status/1570414928313589761",
    "content": {
        "text": "Worth reading this whole thread. The value of having stable, long-lasting standards is not to be underestimated. \ud83d\udc47"
    },
    "author": {
        "type": "card",
        "name": "Jared White",
        "url": "https://twitter.com/jaredcwhite",
        "photo": "https://pbs.twimg.com/profile_images/1562139062152007680/P8B7FtDQ.jpg"
    },
    "post-type": "note",
    "refs": {
        "https://twitter.com/morewry/status/1570414928313589761": {
            "type": "entry",
            "published": "2022-09-15T14:11:10+00:00",
            "url": "https://twitter.com/morewry/status/1570414928313589761",
            "in-reply-to": [
                "https://twitter.com/joelmoss/status/1570326380595875841"
            ],
            "content": {
                "text": "I can't agree that's a good point at all.\n\nStandards innovative and improve. If they didn't, they would never change. They demonstrably change.\n\nIs changing *frequently* a virtue? Being able to change when needed is important. But we have a massive amount of tech to support",
                "html": "I can't agree that's a good point at all.\n\nStandards innovative and improve. If they didn't, they would never change. They demonstrably change.\n\nIs changing *frequently* a virtue? Being able to change when needed is important. But we have a massive amount of tech to support\n<a class=\"u-mention\" href=\"https://twitter.com/jaredcwhite\"></a>\n<a class=\"u-mention\" href=\"https://twitter.com/joelmoss\"></a>"
            },
            "author": {
                "type": "card",
                "name": "Rhy Moore",
                "url": "https://twitter.com/morewry",
                "photo": "https://pbs.twimg.com/profile_images/1463177806796320769/yueOtc0k.jpg"
            },
            "post-type": "reply"
        }
    },
    "_id": "31394777",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-15T17:38:18+00:00",
    "url": "https://twitter.com/aaronpk/status/1570467055446691841",
    "content": {
        "text": "Is installing a Unifi Door Access system for my front door overkill? Yes. \n\nDo I want to do it anyway? Absolutely."
    },
    "author": {
        "type": "card",
        "name": "Aaron Parecki",
        "url": "https://twitter.com/aaronpk",
        "photo": "https://pbs.twimg.com/profile_images/1477113672803622912/ljLUwFLP.jpg"
    },
    "post-type": "note",
    "_id": "31394648",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-15T10:38:15-07:00",
    "url": "https://aaronparecki.com/2022/09/15/15/",
    "syndication": [
        "https://twitter.com/aaronpk/status/1570467055446691841"
    ],
    "content": {
        "text": "Is installing a Unifi Door Access system for my front door overkill? Yes.  \n\nDo I want to do it anyway? Absolutely.",
        "html": "Is installing a Unifi Door Access system for my front door overkill? Yes.  <br /><br />Do I want to do it anyway? Absolutely."
    },
    "author": {
        "type": "card",
        "name": "Aaron Parecki",
        "url": "https://aaronparecki.com/",
        "photo": "https://aperture-media.p3k.io/aaronparecki.com/41061f9de825966faa22e9c42830e1d4a614a321213b4575b9488aa93f89817a.jpg"
    },
    "post-type": "note",
    "_id": "31394468",
    "_source": "16"
}

{
    "type": "entry",
    "published": "2022-09-15T17:29:16+00:00",
    "url": "https://twitter.com/anomalily/status/1570464781773209600",
    "quotation-of": "https://twitter.com/anomalily/status/1570459944276885506",
    "content": {
        "text": "Also if you are an editor for a pub that thinks this should be covered, I'm available for freelance reporting and I have 90% of the research done and the sources already."
    },
    "author": {
        "type": "card",
        "name": "Lillian Karabaic",
        "url": "https://twitter.com/anomalily",
        "photo": "https://pbs.twimg.com/profile_images/1455236306162761732/jPv9ROKG.jpg"
    },
    "post-type": "note",
    "refs": {
        "https://twitter.com/anomalily/status/1570459944276885506": {
            "type": "entry",
            "published": "2022-09-15T17:10:03+00:00",
            "url": "https://twitter.com/anomalily/status/1570459944276885506",
            "content": {
                "text": "What is happening with the texas judge's health care ruling is terrifying, and why you should care about it if you care about american health care: a \ud83e\uddf5"
            },
            "author": {
                "type": "card",
                "name": "Lillian Karabaic",
                "url": "https://twitter.com/anomalily",
                "photo": "https://pbs.twimg.com/profile_images/1455236306162761732/jPv9ROKG.jpg"
            },
            "post-type": "note"
        }
    },
    "_id": "31394432",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-15T16:39:29+00:00",
    "url": "https://twitter.com/ChrisAldrich/status/1570452251558432769",
    "quotation-of": "https://twitter.com/sdfahrenthold/status/1570091977794031616",
    "content": {
        "text": "\"Conversations with the texts\" is spectacular writing advice. \nDon't forget to have a conversation w/ your notes (your past self) to accelerate your combinatorial creativity & originality. \nLuhmann (1981) describes this well. luhmann.surge.sh/communicating-\u2026",
        "html": "\"Conversations with the texts\" is spectacular writing advice. \nDon't forget to have a conversation w/ your notes (your past self) to accelerate your combinatorial creativity &amp; originality. \nLuhmann (1981) describes this well. <a href=\"http://luhmann.surge.sh/communicating-with-slip-boxes\">luhmann.surge.sh/communicating-\u2026</a>"
    },
    "author": {
        "type": "card",
        "name": "Chris Aldrich",
        "url": "https://twitter.com/ChrisAldrich",
        "photo": "https://pbs.twimg.com/profile_images/890299009381916672/CafdvvxN.jpg"
    },
    "post-type": "note",
    "refs": {
        "https://twitter.com/sdfahrenthold/status/1570091977794031616": {
            "type": "entry",
            "published": "2022-09-14T16:47:53+00:00",
            "url": "https://twitter.com/sdfahrenthold/status/1570091977794031616",
            "photo": [
                "https://pbs.twimg.com/media/FcoVJZUaIAkcEy1.jpg"
            ],
            "in-reply-to": [
                "https://twitter.com/sdfahrenthold/status/1570090306858811393"
            ],
            "content": {
                "text": "ORIGINALITY. When writing from original materials it's easy to get bogged down in whether what you have to say is original. This anxiety can lead new authors to doubt their contribution to their field.\n\nBut having a conversation partner in your topic is actually ideal!\n\n(2/5)"
            },
            "author": {
                "type": "card",
                "name": "Stacy Fahrenthold",
                "url": "https://twitter.com/sdfahrenthold",
                "photo": "https://pbs.twimg.com/profile_images/1390343821859332096/NF7Hm8Gv.jpg"
            },
            "post-type": "reply"
        }
    },
    "_id": "31393158",
    "_source": "2773"
}

{
    "type": "entry",
    "published": "2022-09-15T11:09:53-0400",
    "url": "https://martymcgui.re/2022/09/15/110953/",
    "category": [
        "caturday"
    ],
    "video": [
        "https://res.cloudinary.com/schmarty/video/upload/vc_h264/mmmgre/ab/ae/90/1e/0cc72d8d958032cb72ec67b9a93f5943e5c4101ba75b4515ac5ed5bc.mov"
    ],
    "content": {
        "text": "Where have you been hiding during eternal Caturday?",
        "html": "<p>Where have you been hiding during eternal Caturday?</p>"
    },
    "author": {
        "type": "card",
        "name": "Marty McGuire",
        "url": "https://martymcgui.re/",
        "photo": "https://martymcgui.re/images/logo.jpg"
    },
    "post-type": "video",
    "_id": "31392756",
    "_source": "175"
}