\n Home\n About\n

\n );\n}\n\nfunction PostComponent({ markdown, link }: { markdown: string; link?: string }) {\n return (\n

\n {link}\n {markdown}\n

\n );\n}\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const referer = req.headers.get(\"referer\");\n let monthHits, todayHits;\n try {\n const hits = await getHits(url.pathname, referer);\n monthHits = hits.monthHits;\n todayHits = hits.todayHits;\n } catch (e) {\n console.log(\"Caught database error: \", e);\n }\n if (url.pathname === \"/\") {\n const files = await listFiles(import.meta.url);\n const posts = files.filter((file) => file.path.startsWith(\"posts/\"));\n const postContents = await Promise.all(\n posts.map(async (file) => readFile(file.path, import.meta.url)),\n );\n\n return html(\n

Alex Wein has some thoughts

\n {postContents.map((markdown, i) => )}\n View source\n

,\n );\n }\n if (url.pathname.startsWith(\"/posts/\")) {\n const markdown = await readFile(url.pathname, import.meta.url);\n return html(\n

\n {markdown}\n

,\n );\n }\n const aboutPaths = [\"/about\", \"/about/\"];\n if (aboutPaths.includes(url.pathname)) {\n const markdown = await readFile(\"/about.md\", import.meta.url);\n return html(\n

\n {markdown}\n

,\n );\n }\n if (url.pathname === \"/2019/03/15/visualizing-visualizers/\") {\n const markdown = await readFile(\"/other-posts/dvs-spin.md\", import.meta.url);\n const response = await fetch(\n \"https://raw.githubusercontent.com/a-lexwein/weblog/refs/heads/master/public/dvs-fragment.html\",\n );\n const fragmentText = await response.text();\n\n const style = `\n body {\n background-color: #E5E5E5;\n }\n svg {\n animation-name: spin;\n animation-duration: 7000ms;\n animation-iteration-count: infinite;\n animation-timing-function: linear;\n transform-origin: 400px 315px;\n }\n @keyframes spin {\n 0% {\n transform: rotate(0deg);\n }\n 16.66% {\n transform: rotate(-120deg); \n }\n 33.32% {\n transform: rotate(-120deg); \n } \n 49.98% {\n transform: rotate(-240deg); \n } \n 66.64% {\n transform: rotate(-240deg); \n } \n 83.3% {\n transform: rotate(-360deg); \n } \n 100% {\n transform: rotate(-360deg);\n }\n }\n `;\n\n const markdownText = renderToString({markdown});\n const fullHtml = `\n \n \n \n \n \n SVG Animation\n \n \n \n ${fragmentText}\n ${markdownText}\n \n \n \n `;\n return new Response(fullHtml, {\n headers: {\n \"content-type\": \"text/html\",\n },\n });\n }\n \n if (url.pathname === \"/dbt\") {\n const markdown = await readFile(\"/other-posts/dbt-cheatsheet.md\", import.meta.url);\n return html(\n

\n {markdown}\n

,\n );\n }\n\n if (url.pathname === \"/robots.txt\") {\n const robots = await readFile(\"/robots.txt\", import.meta.url);\n return new Response(robots, {\n headers: {\n \"content-type\": \"text/plain\",\n },\n });\n }\n\n return new Response(\"Not found\", { status: 404 });\n}\n\nfunction html(children: React.ReactNode) {\n return new Response(\n renderToString(\n \n {children}\n ,\n ),\n {\n headers: {\n \"content-type\": \"text/html;\",\n },\n },\n );\n}",[],[109],"f567b0b8-e1c4-11f0-8911-42dde27851f2","analytics.ts","019b56e8-b381-742c-9558-dac94c36e68b",["D",1766689649541],"script","// inspired by steve's implementation https://www.val.town/x/stevekrouse/stevekrouse_dot_com/branch/main/version/26/code/analytics.ts\n// import { sqlite } from \"https://esm.town/v/std/sqlite?v=5\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\n\nexport async function getHits(url, referer) {\n await sqlite.batch([\n \"CREATE TABLE IF NOT EXISTS blog_hits (id INTEGER PRIMARY KEY AUTOINCREMENT, url TEXT, referer TEXT, timestamp DATETIME DEFAULT CURRENT_TIMESTAMP)\",\n { sql: `INSERT INTO blog_hits (url, referer) VALUES (:url, :referer)`, args: { url, referer } },\n // \"SELECT COUNT(*) FROM blog_hits WHERE strftime('%m', timestamp) = strftime('%m', 'now') AND strftime('%Y', timestamp) = strftime('%Y', 'now')\",\n // \"SELECT COUNT(*) from blog_hits WHERE strftime('%m', timestamp) = strftime('%m', 'now') AND strftime('%Y', timestamp) = strftime('%Y', 'now') AND strftime('%d', timestamp) = strftime('%d', 'now')\",\n ]);\n return {};\n}",[],[117],"f567adc0-e1c4-11f0-8911-42dde27851f2","about.md","019b56e8-b381-742c-9558-d4e7a0c625f4",["D",1766689649541],"## Alex Wein's web site\n\nWelcome to a web site. I live in Oakland, California\nand do business intelligence for a software company.\nPersonal web sites are good things to have.\n\nI'm on [Bluesky](https://bsky.app/profile/alexwein.bsky.social).",[],[125],"f567abb8-e1c4-11f0-8911-42dde27851f2","README.md","019b56e8-b381-742c-9558-d0c9b46cac35",["D",1766689649541],"# myBlog\n\nThis is a simple static blog.\n\nPosts go in the /posts directory.",[],[132],"f567a096-e1c4-11f0-8911-42dde27851f2","Layout.tsx","019b56e8-b381-742c-9558-ce1cc1e061bb",["D",1766689649541],"/** @jsxImportSource npm:react@18.2.0 */\nimport type { ReactNode } from \"npm:react@18.2.0\";\n\nexport function Layout({ children }: { children: ReactNode }) {\n return (\n \n \n \n \n Alex Whines\n \n \n \n {children}\n \n \n );\n}",[],[139],"f5679f24-e1c4-11f0-8911-42dde27851f2","posts","019b56e8-b381-742c-9558-ca3b8639055c",["D",1766689649541],[151,152,153,154,155,156,157,158,159],[146],{"_36":218,"_13":219,"_65":220,"_67":147,"_69":70,"_71":72,"_73":74,"_38":221,"_17":32,"_76":24,"_77":222,"_79":54,"_80":-5,"_105":223,"_18":224},{"_36":211,"_13":212,"_65":213,"_67":147,"_69":70,"_71":72,"_73":74,"_38":214,"_17":32,"_76":24,"_77":215,"_79":54,"_80":-5,"_105":216,"_18":217},{"_36":204,"_13":205,"_65":206,"_67":147,"_69":70,"_71":72,"_73":74,"_38":207,"_17":32,"_76":24,"_77":208,"_79":54,"_80":-5,"_105":209,"_18":210},{"_36":197,"_13":198,"_65":199,"_67":147,"_69":70,"_71":72,"_73":74,"_38":200,"_17":32,"_76":24,"_77":201,"_79":54,"_80":-5,"_105":202,"_18":203},{"_36":190,"_13":191,"_65":192,"_67":147,"_69":70,"_71":72,"_73":74,"_38":193,"_17":32,"_76":24,"_77":194,"_79":54,"_80":-5,"_105":195,"_18":196},{"_36":183,"_13":184,"_65":185,"_67":147,"_69":70,"_71":72,"_73":74,"_38":186,"_17":32,"_76":24,"_77":187,"_79":54,"_80":-5,"_105":188,"_18":189},{"_36":176,"_13":177,"_65":178,"_67":147,"_69":70,"_71":72,"_73":74,"_38":179,"_17":32,"_76":24,"_77":180,"_79":54,"_80":-5,"_105":181,"_18":182},{"_36":169,"_13":170,"_65":171,"_67":147,"_69":70,"_71":72,"_73":74,"_38":172,"_17":32,"_76":24,"_77":173,"_79":54,"_80":-5,"_105":174,"_18":175},{"_36":160,"_13":161,"_65":162,"_67":147,"_69":70,"_71":163,"_73":74,"_38":164,"_17":165,"_76":24,"_77":166,"_79":54,"_80":-5,"_105":167,"_18":168},"c7d92754-e1c8-11f0-942d-42dde27851f2","2025-12-25-chart-games-2025.md","f94a2dc8-e1c4-11f0-8b31-42dde27851f2",10,["D",1766691291102],8,"## The Two Best Data Visualization-Centric Digital Games of 2025\n\nThere have been video games with great uses of data visualization before, but before this year,\nI don't think I'd ever played a game that was **Really About The Charts**.\nAnd this year I played two! And both were kind of awesome in very different ways.\n\n### [Pocket Boss](https://pocketboss.ch/)\n\nMostly by default, Mario von Rickenbach has made the definitive piece of art about working in business intelligence.\n*Pocket Boss* is a mobile game. You play as a data worker, remotely communicating with your boss through chat DMs.\nEach level is a chart your boss needs you to clean up.\n\n![5509C048-FB3C-410B-AD5C-FA26E60D191B_1_105_c.jpeg](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/40002f3a-1294-4e73-4283-eaa867020000/public)\n\nGameplay wise, it has a bit in common with some kids apps I love like Windowsill and Sago Mini. To make the bars on the chart \"go up\" or whatever your current objective is, you tap or drag or swipe. It's tactilely satisfying with just a splash of puzzling.\n\nBut the reason to the play the game is for the writing, which I found very funny and **shockingly relatable**. Although all my managers have been wonderful and open-minded people, in my career in business intelligence, it's hard to totally escape the feeling that the numbers don't matter, we're just making pretty pictures to justify whatever decision management was going to make anyways. *Pocket Boss* deals with these existential questions of the data worker with with\n\n### [Alphadots](https://www.bloomberg.com/games/alphadots)\n\nThere were even more new entrants into the little daily word game racket in 2025.\nBloomberg launched their Games section in September that included *Alphadots*, created by crossword constructor Jeff Chen.\nYou are presented with a crossword-style question mark clue. And the letters are displayed in a line chart, ordered alphabetically along the Y-axis. Hints let you add horizontal baselines.\n\n![345DFBCD-2E4C-419E-B141-320528C9121F_1_105_c.jpeg](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/ea9a172e-739c-40ba-9321-4000807f7600/public)\n\nIt has doesn't have anything to do its chart based nature, but what really keeps me coming back are the consistently solid \"?\" clues. A light, satisfying bit of wordplay every day with a novel solving mechanic. I can't remember another word game I've played where alphabetical order played any role. It adds a unique texture to which puzzles are easy or heard: As are always easy to identify, repeating letters are also crucial information, and most of the your time is spent wondering if those dots in the middle are Ls, Ms, or Ns\n\nAnd it's really a chart game! Unlike *Pocket Boss*, *Alphadots* actually actually asks you to interpret some data. You start with a chart. It might take a little time to decode, but the chart has all the information you need solve the puzzle. It's a good time.",[],[146,161],"f567977c-e1c4-11f0-8911-42dde27851f2","2025-12-24-five-friendly-sql-tips.md","019b56e8-b381-742c-9558-c63cd9bb2b0a",["D",1766689649541],"## [Five Cool Little Bits of \"Friendly\" SQL for wrangling data in DuckDB (or Snowflake)](https://observablehq.com/@a-lexwein/five-cool-little-bits-of-friendly-sql)\nIn a attempt to get out of my not-blogging rut,\nI wrote a little SQL Tips and Tricks post, focusing on some \"friendly\" additions to the query syntax that DuckDB has introduced over the last few years and Snowflake has adopted as well.\n\nI cover the following keywords.\n\n1. `group by all`\n2. terminal commas (this is not a keyword)\n3. `count_if`\n4. `sample`\n5. `values`\n\nSo that I could use interactive queries, I wrote it as an Observable Notebook, the fantastic Javascript focused live coding platform where DuckDB comes standard.\nIn addition to the I've smuggled in a few opinions about SQL style. Check it out.\n\n### https://observablehq.com/@a-lexwein/five-cool-little-bits-of-friendly-sql",[],[146,170],"f567616c-e1c4-11f0-8911-42dde27851f2","2025-04-06-comics-about-comics.md","019b56e8-b381-742c-9558-c1380e1ef9a7",["D",1766689649541],"## The next addition to your data viz bookshelf should be a Comic About Comics.\n\n![IMG_0626.jpg](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/03100f91-56e9-400c-96d9-e7c9d3b7c200/public \"A photograph of the books in this post\")\n\nThere are many wonderful books on/of data visualization, and if you work in data,\nyou probably have a few (hopefully more than just *that one*). You should probably get more.\n\nAs your collection grows, consider that the next great book to inspire the chartmaker in you --\nto further you on your journey to master the craft -- may not be a treatise on chart types or data storytelling,\nbut something possibly even cooler: **A Comic About Comics**.\n\nThese are just the ones I own. You really can't go wrong with any of them.\nAnd even if you have no interest in data viz, this Comics About Comics genre is still a fantastic mind-expanded set of books.\nThis books are really special: they're formally inventive but personal and emotional in their own ways.\nThey provide a wonderful set of boxes to think outside of.\n\n### Scott McCloud's *Understanding Comics* ~~Trilogy~~ Ouvre\n\nI discovered Scott McCloud's work in 2018,\nwhen he was interviewed for [an episode of the design podcast 99% Invisible.](https://99percentinvisible.org/episode/speech-bubbles-understanding-comics-scott-mccloud/)\n\nThat conversation -- but especially his 1993 classic *Understanding Comics* which I read right afterwards -- completely blew my mind.\nThere have been less than a handful of times in my career where I felt that lightbulb above my head go on with anywhere near the wattage of when I digested *Understanding Comics*. \n\nI walked away from *Understanding Comics* with this incredible insight that data visualization was really a form of comics\n(\"sequential art\" if you're worried the person you're talking too thinks \"comics\" is a dirty word).\nCharts -- and especially sequences of charts to make things like dashboards or powerpoint presentations -- very definitely count per McCloud's definition:\n\n> Juxtaposed pictorial and other images in deliberate sequence, intended to convey information and/or to produce an aesthetic response in the viewer.\n\nAt that point in 2018, I had been a data person for several years, always making charts to understand and communicate things both professionally and recreationally for many years.\nI had some successes: charts that helped my colleagues make decisions, charts that made cool nerds on tumblr chuckle, even a few that I didn't think were hideous.\nI didn't yet have a full bookshelf of data viz books, but I had more than one (the first I bought was indeed *that one*).\nDespite not having much academic training in it, I felt like I understood visualization pretty well at that point, but *Understanding Comics*\nmade clear how limited by understanding was (and still is).\nEven more so than the grammar of graphics: to me personally this idea of **Charts Are Comics** has been the most powerful aha moment in my \"career\" as a chartmaker.\n\nIf you've read *Understanding Comics* and got something out of it, I'd encourage you to keep going with McCloud's work.\nAlthough 1996's *Making Comics* did not quite inspire me to start making comics, it has great lessons about composition and visual storytelling.\n2000's *Reinventing Comics* in particular had a lot of resonance for me, as someone who's sequential art (charts) is both made and consumed through screens and computers.\n\nAnd just this week, Scott McCloud released another Comic About Comics: *The Cartoonists Club* with Raina Telgemeier.\nAimed at younger readers, it embeds the most important ideas from *Understanding...* and *Making...*\nand into a narrative about middler schoolers finding their voice and their people.\n*Understanding Comics* never brought me to tears, but I needed a kleenex after finishing *The Cartoonists Club*.\n\nWhile I hadn't considered the relationship between charts and comics until 2018,\nMany others had made the connection and I just wasn't paying attention.\nMcCloud had spoken at the data viz conference Tapestry in 2013,\nand Moritz Stefaner (data viz maker and discusser extroidinaire) interviewed McCloud in 2017 for the [Data Stories podcast](https://datastori.es/102-comics-and-visual-storytelling-with-scott-mccloud/).\nAlso in 2017 in academia, Benjamin Bach worked with Nathalie Henry Riche, Sheelagh Carpendale, and Hanspeter Pfister to publish\n[The Emerging Genre of Data Comics](http://sheelaghcarpendale.ca/innovis/uploads/Publications/Publications/carpendale2017emerging.pdf)\n(which itself is a Comic About Comics!).\nAnd in 2016, comics professor Nick Sousanis gave a [Keynote at Tapestry](https://www.youtube.com/watch?v=7veGaFlu9Xk&t=2698s).\n\n### *Unflattening* by Nick Sousanis\n\nIt is reductive to call *Unflattening* a Comic About Comics: it's definitely a comic,\nbut it's about something a little bigger and a lot more cerebral than McCloud's work (it's a PhD dissertation).\nIt's hard to pin down exactly what to call that (the shapeliness of ideas?).\nThat written words are insufficient to describe the complexity of the topic is another thing the book is kind of about.\n\n*Unflattening* is also a compositional feast: pages flow in all sorts of directions.\nEvery spread maps complex and abstract things to the two-dimensional page in ways that befit the nonlinearity and high dimensionality of those abstract spaces.\nMuch of the hard work of data viz is making invisible abstract things tractable in two dimensions, and *Unflattening* contains lesson after lesson in it.\n\nRJ Andrews deserves a shout-out. RJ recommended Unflattening to me at the Tapestry conference in 2018\n(I gave [my own brief talk](https://www.youtube.com/watch?v=PpAfmTgcGPY) at that Tapestry, invigorated by discovering *Understanding Comics* at the beginning of the year).\nIf you don't have a data viz bookshelf yet,\nI can safely say Andrews's newly remastered [*Info We Trust*](https://visionarypress.com/products/info-we-trust) is the perfect place to start (way better than *that one*).\nRJ's book is of what it's about in the same way all these wonderful Comics About Comics are.\nRJ also has a wonderful write-up that covers this very topic: [\"Books without data for the data professional\"](https://infowetrust.com/project/information-arts)\nthat includes both *Unflattening* and *Understanding Comics*.\n\n### *What It Is* and *Making Comics* by Lynda Barry\n\n*What It Is*, like McCloud's classic, is also about understanding comics, but it's form and content differ dramatically.\nWhile McCloud explicates the conventions of comics with a focus on the prototypical grid of rectangular panels,\nBarry is more interested in asking than answering, and her work is -- gloriously -- too untidy to fit into little boxes.\nEven compared to heady academic work of *Unflattening*, *What It Is* was maybe the most challenging read for me of any of these comics.\nIt's not formless, but it's far from the rectilinearity of most comics I read.\nAll these books are great for leaving on your coffee table, and leafing through random pages, but *What It Is* works particularly well for this.\n\nBarry's *Making Comics* had a magical impact on me: It actually got me drawing!\nI didn't work my way through the whole book, but I tried a several of the exercises.\nAnd for about two months in 2020, I drew a self-portrait on a index card every day (they're hideous and I'm so proud of them).\nBut even if you can't find to courage to draw, *Making Comics* is worth it for how she grounds the craft in modes we all learned as children.\n\nSo read some books, bust out that pen and paper, make some charts, make some comics, make something else.\n\n![IMG_0623.jpg](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/4a0844b9-a977-47c6-a086-fc949432bf00/public \"From Barry's Making Comics: you don't have to have any artistic skill to do this. you just need to be brave and sincere.\")",[],[146,177],"f5674682-e1c4-11f0-8911-42dde27851f2","2025-03-31-old-tumblrs.md","019b56e8-b381-742c-9558-be02186d12e0",["D",1766689649541],"## Some of my better Tumblr posts\n\nAlthough the URL somehow got reshuffled and I have long forgotten the login password, my old Tumblr blog Alex Whines\nis still on the internet. When the tumblr was still active, I kept a list of greatest hits.\nI reproduced the list when I my previous abandoned blog, so it was easy enough to migrate to the new future abandoned blog.\n\nIn addition to all the the fun posts below that I am 98% not ashamed of, my old blog did contain some missteps.\nSorry for the bad opinions and shoddy work!\n\n**Games:**\n- A multi-part analysis of Jeopardy! questions and answers, featuring some fun visualization ([1](http://alexwhines-blog.tumblr.com/post/613905785/helpful-hint-for-when-you-are-a-contestant-on-jeopardy),[2](http://alexwhines-blog.tumblr.com/post/670084704/weve-already-covered-that-whenever-you-dont-know),[3](http://alexwhines-blog.tumblr.com/post/790684867/so-youre-back-on-jeopardy-trebek-is-reading),[4](http://alexwhines-blog.tumblr.com/post/801075069/another-possible-jeopardy-scenario-you-might-as))\n- [Swear words](http://alexwhines-blog.tumblr.com/post/3868278233/scrabble-facts-pt-4) in Scrabble\n- I play a lot of [Boggle](http://alexwhines-blog.tumblr.com/tagged/boggle)\n- Arbitrage [at the boardwalk arcade](http://alexwhines-blog.tumblr.com/post/913999996/hot-investment-tip-boardwalk-arcade-edition)\n\n**Music:**\n\n- [Pitchfork versus Metacritic,](http://alexwhines-blog.tumblr.com/post/809415856/yesterday-something-called-flavorwire-had-a-post) a quantitative analysis, and some more on the [Metacritic data](http://alexwhines-blog.tumblr.com/tagged/metacritic).\n- [A dialogue in song titles](http://alexwhines-blog.tumblr.com/post/1587830624/a-dialogue-in-song-titles-speaker-1-is-in-light)\n- What's the [Scenario](http://alexwhines-blog.tumblr.com/post/2680112431/know-your-scenarios-a-tribe-called-quest)?\n- I also used to maintain a tumblr about [Songs from Treme](https://songsfromtreme-blog.tumblr.com/)\n\n**Nesting and recursion in fun places:**\n\n- One step of the Hokey Pokey is '[do the Hokey Pokey](http://alexwhines-blog.tumblr.com/post/733602356/recursion-in-fun-places-depending-on-how-you)'\n- [Fish fish fish.](http://alexwhines-blog.tumblr.com/post/4619309811/according-to-wikipedia-northern-pike-feed-on)\n- [My idea for a TV show](http://alexwhines-blog.tumblr.com/post/855597954/if-anyone-knows-anyone-at-nbc-ive-got-an-awesome) about 30 Rock and Studio 60\n- If someone was reading The Lion, The Witch, and The Wardrobe in the [fictional universe](http://alexwhines-blog.tumblr.com/post/3094931180/a-thought-continued) of the movie Groundhog Day\n\n**Food:**\n\n- The hole in the [Candy Bar Venn Diagram](http://alexwhines-blog.tumblr.com/post/407296011/hot-investment-tip-candy-bar-edition-hopefully)\n- Diagrams of [Scotch eggs](http://alexwhines-blog.tumblr.com/post/715341118/were-you-aware-of-the-existence-of-scotch-eggs-i) and [Snickers ice cream cones](http://alexwhines-blog.tumblr.com/post/3613407044/the-snickers-ice-cream-cone-lucky-charms)\n- [A guide](http://alexwhines-blog.tumblr.com/post/587595945/the-chinese-spot-across-the-street-from-me-is-only) for price-conscious people who want to buy chicken wings at the intersection of 7th St. and Q St. NW\n- Tale of the Tape: [E.L. Fudge and Double Stuffed E.L. Fudge](http://alexwhines-blog.tumblr.com/post/3374412499/i-made-a-pretty-big-discovery-at-the-supermarket)\n\n**More words:**\n\n- [Moonfish](http://alexwhines-blog.tumblr.com/post/5863557451/selfish-shellfish-sell-fish-shellfish) moon fish.\n- Why *[improbably](http://alexwhines-blog.tumblr.com/post/7824736366/the-word-im-currently-finding-interesting)* is interesting.\n- [Example sentences](http://alexwhines-blog.tumblr.com/post/5655919664/example-sentences) I have produced in school\n- Buffalo people [buffalo people](http://alexwhines-blog.tumblr.com/post/4580679647/buffalo-people-buffalo-people).\n- Hotspots/Potshots, Sleepover/Oversleep, [etc.](http://alexwhines-blog.tumblr.com/post/210515042/this-all-started-when-i-found-headwater-and-missed)\n\n- Just a photograph of [me eating cheese puffs](http://alexwhines-blog.tumblr.com/post/9640074973/a-hypothesis-has-been-floated-that-my-blog-would)",[],[146,184],"f5673034-e1c4-11f0-8911-42dde27851f2","2025-03-29-posts-only-a-mother-could-like.md","019b56e8-b381-742c-9558-bbb80f123db8",["D",1766689649541],"## Posts Only a Mother Could Like\n\nIt's not surprising my Bluesky posts don't get many likes. I don't have many followers and honestly I'm not a great poster.\nI even call myself boring in my bio. With so few likes, every like is meaningful to me.\nEspecially when there's only a single ❤️ on the post.\nI know it's just someone pushing a button, but that little one-to-one connection across cyberspace,\nto say \"I see you, even if nobody else does\", it means something.\n\nBut it means something a little different when that person is your mother.\n\nBelow are the ten posts of mine liked by my mother and nobody else.\n\n| Timestamp | Text |\n|-----------|------|\n| [3/25/2025, 2:16:42 PM](https://bsky.app/profile/alexwein.bsky.social/post/3ll7hjfjewk24) | ranking daily games against funness and the complicity of the publishers is its own knotty puzzle |\n| [3/15/2025, 3:08:07 PM](https://bsky.app/profile/alexwein.bsky.social/post/3lkgfq4tm3k2z) | It seems like all the cool kids are going to this. But also me. |\n| [3/1/2025, 11:55:58 PM](https://bsky.app/profile/alexwein.bsky.social/post/3lje4p4eovk2f) | I forked my last word game and added wikipedia's list of birds alexwein-loopylettersbirds.web.val.run |\n| [2/18/2025, 2:21:10 AM](https://bsky.app/profile/alexwein.bsky.social/post/3lig77ozynk2x) | Weekend word game. Not fun, per se, but more fun than the last time I tried to make this particular game. alexwein-loopyletters.web.val.run |\n| [1/8/2025, 3:13:51 PM](https://bsky.app/profile/alexwein.bsky.social/post/3lfahbmnbnk26) | I got a shout-out for today's Order Up (I submitted something worse and Adam ran with this instead). You're all doing Order Up every day, right? orderup.games |\n| [1/2/2025, 4:19:17 PM](https://bsky.app/profile/alexwein.bsky.social/post/3leri53kqsk2z) | welp...I now have two half-written blog posts. Here's the list though. All definitely word games for sure. |\n| [12/13/2024, 12:57:47 AM](https://bsky.app/profile/alexwein.bsky.social/post/3ld5lcvqyk22w) | I've never had it to drink (so didn't include it) but have always liked the Lil Wayne song \"D'usse\" www.youtube.com/watch?v=TS-h... |\n| [12/12/2024, 9:41:03 PM](https://bsky.app/profile/alexwein.bsky.social/post/3ld5ad4wt3s2e) | My sister's book club needed to know the longest sentence in Henry James's The Golden Bowl. Probably too naive a methodology, but the results seem plausible observablehq.com/@a-lexwein/l... |\n| [12/7/2024, 3:07:33 PM](https://bsky.app/profile/alexwein.bsky.social/post/3lcpxyvnd4k2m) | i'm having a very strong showing so far in december's monthly boggle tournament |\n| [11/8/2024, 4:39:12 PM](https://bsky.app/profile/alexwein.bsky.social/post/3lah7m34lem27) | toying with the idea of accomplishing more than zero tasks today |\n\n[Here's the val](https://www.val.town/v/alexwein/bskySoloLikes) where I pull the data. And [here's a full list](https://www.val.town/v/alexwein/soloLikesDisplay) my posts that have been liked by exactly one person.\n\nI love you too, mom! ❤️",[],[146,191],"f56729fe-e1c4-11f0-8911-42dde27851f2","2025-03-14-pie-charts-why-not.md","019b56e8-b381-742c-9558-b6aaa5d1ce5f",["D",1766689649541],"## A good reason not to use pie charts\n\nHere is a compelling reason not use pie charts when visualizing data:\n\nOne of your stakeholders has an MBA and has read exactly one book on data visualization (you know which one).\nHe thinks pie charts are oh so terrible, and if your reports and dashboards contain pie charts,\ninstead of focusing on the data being communicated, he will complain about the pie charts.\nBecause your goal as somebody making charts is to faciliate understanding, avoiding pie charts altogether\ncan actually be a smart strategy.\nFor all their merits, you never strictly \"need\" pies (or any one chart type).\nIf a chart's form would be a distraction from the data,\nit is maybe not the the right chart.\n\n## A good reason to use pie charts\n\nFuck that guy.",[],[146,198],"f5671496-e1c4-11f0-8911-42dde27851f2","2025-03-09-songbot.md","019b56e8-b381-742c-9558-b1d7e930242b",["D",1766689649541],"## I made a Bluesky bot\n\n[mynewfavoritesong.bluesky.social](https://bsky.app/profile/mynewfavoritesong.bsky.social)\n\nWhen I signed up for Val Town, I had a first project in mind.\nWhile Spotify's algorithms do a serviceable job notifying me of new music by artists I like, it's not really possible to \"follow\" a songwriter.\nHelpfully, Spotify maintains *Written By...* playlists for many songwriters.\nHere's one for [Jonnali Mikaela \"Noonie Bao\" Parmenius](https://open.spotify.com/playlist/37i9dQZF1EFMc5WcffBKFm?si=5d6294f36acf48f8),\nwho has co-writing credits on two of my absolute favorite pop songs of the last 15 years.\n\nBut these first-party playlists aren't in chronological order,\nand I don't know of a good way being notified when songs get added.\nSo it's quite hard to make sure I don't miss out on the latest credit from Sabrina Carpenter's go-to [Amy Allen](https://open.spotify.com/playlist/37i9dQZF1EFAW2Wx2Q7Fjt?si=19a4c0d77645412f).\n\nSo the plan was to build a cron job val that used the Spotify API to poll a playlist on a regular basis, and check whether anything had changed since the last time,\nand then create some sort of alert upon detection of a change.\nIt seemed buildable, even with my modest dev skills.\nI was able to use [some tools](https://www.val.town/v/stevekrouse/spotifyTracks) that [Steve](https://www.val.town/u/stevekrouse) from Val Town built.\nI was ready to request a playlist for the first time, at which point I learned that Spotify somewhat recently enshittified their web API\nsuch that first-party playlists are no longer available.\n\nSo, I'm still looking for a good way to keep up with songwriters.\n\nBut I was able to take the same basic idea and turn in into My New Favorite Song Bot\n(here's [the val with the code](https://www.val.town/v/alexwein/newFavoriteSongBot)).\nIt's the same thing really: a cron val looking for new songs added to a playlist. When it catches something new, it posts to Bluesky.\nI think it's going to break when I add too many songs.\nI also haven't really thought about what happens if I try to add multiple songs at the same time.\n\nBecause another Val Town user named Jonas Merlin had already made a [Bluesky bot template](https://www.val.town/v/jonasmerlin/bluesky_bot_template),\nthe whole process was quite tractable. It's been working so far! Every time I've added a song, the Bluesky post has dutifully showed up.\n\nI'm a little ambivalent about how having a Favorite Songs bot might impact my relationship to music.\nAnd I haven't really decided how good a song needs to be for me to add it to the playlist. Or what consitutes \"new\".\nThere are seven songs so far; I seem to be on a pace of about one song a week.\nAlso Spotify is maybe evil, and even if it isn't, it is still probably bad for the world and I shouldn't use it and you shouldn't either.\nBut I do, and you can listen to the full playlist [here](https://open.spotify.com/playlist/0P2hUZ6RymtSZcUhCii77t?si=c6c20c26fa434f50).",[],[146,205],"f5670960-e1c4-11f0-8911-42dde27851f2","2025-03-09-sandwich-rules.md","019b56e8-b381-742c-9558-aedf874452c5",["D",1766689649541],"## How to Play \"Is It A Sandwich?\":\n\n- **Number of Players:** 2+\n- **Play time:** 1 minute - ?\n- **Ages**: 2+\n\n### The Object of the game\n\nThe object of **\"Is It A Sandwich?\"** is to just sort of have a conversation.\n\n### Beginning the game\n\nDecide who goes first or just start talking.\n\n### A typical round\n\nA player proposes a candidate.\nEvery player begins discussing whether or not that candidate is a sandwich.\nAfter some debate, players make a judgment that **Yes** the candidate is a sandwich\nor **No**, it is not a sandwich. Players are allowed to change their mind as debate unfolds.\nThe round ends when a player proposes a new candidate to debate.\n\n(Note: although the round ends when someone proposes a new candidate, players may revisit the candidates from previous rounds at any point to reopen debate or change their judgment.)\n\n### Scoring\n\n1. Each player starts with zero points.\n2. If every player reaches consensus that the candidate is a sandwich, everybody adds **+0 points** to their score.\n3. If one player successfully convinced another to change their mind, the convincer adds **+0 points** to their score and the convincee loses **-0** points.\n4. If one player points out the logical inconsistency of the judgments of another player, both players add **+0 points**.\n\n### Ending the game\n\nThe game ends when the food arrives. There is no winner. There are no losers.",[],[146,212],"f566fe8e-e1c4-11f0-8911-42dde27851f2","2025-03-09-future-abandoned-blog.md","019b56e8-b381-742c-9558-a8d5f6fe0b53",["D",1766689649541],"## My future abandoned blog\n\n\"I should blog more\" is a thought I have pretty regularly.\nHaving ideas worth sharing and crafting in them into something that others might find interesting has\nalways been a very rewarding experience.\n\nBut the thing is: Writing is really hard.\n\nAnd I'm not feeling too optimistic that it's about to get any easier for me. Or even that I have ideas worth sharing.\nWhich means posts here will be a combination of infrequent and of poor quality.\nBut I'm trying again. Here is my space for blogging.\n\n- I work in business intelligence, but it is unclear if I'm any good at my job. I probably will write about charts and analytics occasionally.\n- I also enjoy playing word games and have dabbled in making a few (they are also of poor quality). I might write about word games.\n- In previous incarnations of my blog, there's been plenty of \"here's a song I like\" or \"here's a show I watched\". That might happen, too.\n\nYou should probably blog more, too! Writing time is time well spent.\n\n(This site was built in Val Town. Thanks to [Steve](https://www.val.town/x/stevekrouse/markdownBlogStarter) from Val Town for getting me started.)",[],[146,219],["D",1766689649541],[228,229],[19],{"_36":82,"_13":83,"_65":84,"_67":68,"_69":70,"_71":72,"_73":74,"_38":233,"_17":32,"_76":24,"_77":86,"_79":54,"_80":-5,"_105":234,"_18":235},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":230,"_17":32,"_76":24,"_77":78,"_79":54,"_80":-5,"_105":231,"_18":232},["D",1766689649541],[],[19,64],["D",1766689649541],[],[19,83],["D",1741530120955],"legacyEnvVars","httpPrivacy","description","me writing about things maybe","imageUrl","userId","b85dcfbf-50f1-466c-9e2b-28ac90e0dd23","pinnedFileId","955d7b6e-1855-4b84-a436-6ce9b2f43845","pinPreview","pinMigrated","screenshotVersion",82,"likeCount","tursoName","ddc30ef2fcf111ef8cc6569c3dd06744","tursoHostname","ddc30ef2fcf111ef8cc6569c3dd06744-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789513278143],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_284":280},"org",{"_11":12,"_277":278,"_279":280,"_242":243,"_281":282,"_283":54},"branch",{"_17":163,"_13":16,"_36":70,"_43":44,"_46":37,"_48":273,"_274":56,"_275":44,"_276":59,"_60":14,"_57":12},97,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","Alex Wein","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycjh6emNHdk9mMnY5djU3OFZBbEdleGhQZFAifQ","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":44,"_13":14,"_38":386,"_52":-5,"_237":54,"_55":56,"_238":56,"_239":240,"_241":-5,"_242":243,"_244":245,"_246":74,"_247":-5,"_248":249,"_250":32,"_58":59,"_251":252,"_253":254,"_255":387,"_257":32,"_258":259,"_260":259,"_261":262,"_263":262,"_264":262,"_265":259,"_266":259,"_267":388,"_269":389,"_271":390,"_53":54},[329,332,342,343,344,345,346,347],"files",[329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347],"counts",{"_320":32,"_321":163,"_322":72,"_35":323,"_324":325},[316,317],{"_36":88,"_13":19,"_65":68,"_67":-5,"_69":70,"_71":72,"_73":74,"_38":89,"_17":32,"_76":90,"_77":-5,"_79":54,"_80":-5,"_18":315},"upstreamProject",{"_36":308,"_13":309,"_239":310,"_241":311,"_55":56,"_267":312},"upstreamBranch",{"_36":37,"_38":306,"_40":307,"_13":42,"_43":44,"_17":45,"_46":47,"_48":49,"_50":51,"_52":-5,"_53":54,"_55":56,"_57":12,"_58":59,"_60":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1741530120955],["D",1781616277460],"8e7382ae-d835-11ef-bbbf-e6cdfca9ef9f","markdownBlogStarter","Starter template for a markdown blog","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/44a31e5c-3e8a-48a8-d067-5785c0b08200/square512?exp=1789588799&sig=de7d1935a5b87fcc61575c9dfa63849bf4ae903ea73a89f2e025b69fd96d7a49",{"_11":313,"_284":314},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",[19],{"_36":82,"_13":83,"_65":84,"_67":68,"_69":70,"_71":72,"_73":74,"_38":85,"_17":32,"_76":24,"_77":86,"_79":54,"_80":-5,"_18":319},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":75,"_17":32,"_76":24,"_77":78,"_79":54,"_80":-5,"_18":318},[19,64],[19,83],"pulls","branches","forks",{"_326":72,"_328":32},"connections",{"_326":32,"_327":32},"count","unfilledCount","emptyCount",{"_36":88,"_13":19,"_65":68,"_67":-5,"_69":70,"_71":72,"_73":74,"_38":225,"_17":32,"_76":90,"_77":-5,"_79":54,"_80":-5,"_105":384,"_18":385},{"_36":82,"_13":83,"_65":84,"_67":68,"_69":70,"_71":72,"_73":74,"_38":233,"_17":32,"_76":24,"_77":86,"_79":54,"_80":-5,"_105":382,"_18":383},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":230,"_17":32,"_76":24,"_77":78,"_79":54,"_80":-5,"_105":380,"_18":381},{"_36":145,"_13":146,"_65":147,"_67":-5,"_69":70,"_71":72,"_73":74,"_38":148,"_17":32,"_76":90,"_77":-5,"_79":54,"_80":-5,"_105":378,"_18":379},{"_36":218,"_13":219,"_65":220,"_67":147,"_69":70,"_71":72,"_73":74,"_38":221,"_17":32,"_76":24,"_77":222,"_79":54,"_80":-5,"_105":376,"_18":377},{"_36":211,"_13":212,"_65":213,"_67":147,"_69":70,"_71":72,"_73":74,"_38":214,"_17":32,"_76":24,"_77":215,"_79":54,"_80":-5,"_105":374,"_18":375},{"_36":204,"_13":205,"_65":206,"_67":147,"_69":70,"_71":72,"_73":74,"_38":207,"_17":32,"_76":24,"_77":208,"_79":54,"_80":-5,"_105":372,"_18":373},{"_36":197,"_13":198,"_65":199,"_67":147,"_69":70,"_71":72,"_73":74,"_38":200,"_17":32,"_76":24,"_77":201,"_79":54,"_80":-5,"_105":370,"_18":371},{"_36":190,"_13":191,"_65":192,"_67":147,"_69":70,"_71":72,"_73":74,"_38":193,"_17":32,"_76":24,"_77":194,"_79":54,"_80":-5,"_105":368,"_18":369},{"_36":183,"_13":184,"_65":185,"_67":147,"_69":70,"_71":72,"_73":74,"_38":186,"_17":32,"_76":24,"_77":187,"_79":54,"_80":-5,"_105":366,"_18":367},{"_36":176,"_13":177,"_65":178,"_67":147,"_69":70,"_71":72,"_73":74,"_38":179,"_17":32,"_76":24,"_77":180,"_79":54,"_80":-5,"_105":364,"_18":365},{"_36":169,"_13":170,"_65":171,"_67":147,"_69":70,"_71":72,"_73":74,"_38":172,"_17":32,"_76":24,"_77":173,"_79":54,"_80":-5,"_105":362,"_18":363},{"_36":160,"_13":161,"_65":162,"_67":147,"_69":70,"_71":163,"_73":74,"_38":164,"_17":165,"_76":24,"_77":166,"_79":54,"_80":-5,"_105":360,"_18":361},{"_36":138,"_13":139,"_65":140,"_67":-5,"_69":70,"_71":72,"_73":74,"_38":141,"_17":32,"_76":120,"_77":142,"_79":54,"_80":-5,"_105":358,"_18":359},{"_36":131,"_13":132,"_65":133,"_67":-5,"_69":70,"_71":72,"_73":74,"_38":134,"_17":32,"_76":24,"_77":135,"_79":54,"_80":-5,"_105":356,"_18":357},{"_36":124,"_13":125,"_65":126,"_67":-5,"_69":70,"_71":72,"_73":74,"_38":127,"_17":32,"_76":24,"_77":128,"_79":54,"_80":-5,"_105":354,"_18":355},{"_36":116,"_13":117,"_65":118,"_67":-5,"_69":70,"_71":72,"_73":74,"_38":119,"_17":32,"_76":120,"_77":121,"_79":54,"_80":-5,"_105":352,"_18":353},{"_36":108,"_13":109,"_65":110,"_67":-5,"_69":70,"_71":72,"_73":74,"_38":111,"_17":32,"_76":112,"_77":113,"_79":54,"_80":-5,"_105":350,"_18":351},{"_36":100,"_13":101,"_65":102,"_67":-5,"_69":70,"_71":72,"_73":74,"_38":103,"_17":32,"_76":24,"_77":104,"_79":54,"_80":-5,"_105":348,"_18":349},[],[101],[],[109],[],[117],[],[125],[],[132],[],[139],[],[146,161],[],[146,170],[],[146,177],[],[146,184],[],[146,191],[],[146,198],[],[146,205],[],[146,212],[],[146,219],[333,334,335,336,337,338,339,340,341],[146],[],[19,64],[],[19,83],[330,331],[19],["D",1741530120955],["D",1789513278143],{"_11":12,"_284":280},{"_11":12,"_277":278,"_279":280,"_242":243,"_281":282,"_283":54},{"_17":163,"_13":16,"_36":70,"_43":44,"_46":37,"_48":273,"_274":56,"_275":44,"_276":59,"_60":14,"_57":12},"ctx",{"_267":-5,"_303":424,"_425":426,"_427":428,"_429":54,"_430":54,"_431":54,"_432":74,"_433":-5,"_434":-7,"_435":-7,"_436":32,"_437":54,"_438":54,"_439":-5,"_440":54,"_441":54,"_442":54,"_443":-5},"ENV",{"_395":396,"_397":398,"_399":42,"_400":401,"_402":403,"_404":405,"_406":407,"_408":409,"_410":411,"_412":413,"_414":415,"_416":417,"_418":419,"_420":421,"_422":423},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]