The Stack Overflow Podcast - How to write high-performance SQL for your Postgres database

pgnanalyze helps users deliver consistent PostgreSQL performance and availability at any scale. Get started with a free trial or explore their docs. You can also find them on YouTube, where Lukas posts a weekly show called 5mins of Postgres.

Lukas was a founding engineer of Citus Data. Citus is an open-source extension to PostgreSQL that was eventually acquired by Microsoft. Find them on GitHub.

If you’re new to the topic, SQL (Structured Query Language) is a language for querying databases, introduced in the 1970s. 

Find Lukas on LinkedIn, Twitter, or GitHub.

Short Wave - The Tiny Worm At The Heart Of Regeneration Science

A tiny worm that regenerates entire organs. A South American snail that can regrow its eyes. A killifish that suspends animation in dry weather and reanimates in water. These are the organisms at the heart of regeneration science. But exactly how they do these things is still a mystery to scientists. Today on the show, Regina G. Barber talks to microbiologist Alejandro Sánchez Alvarado about this mystery. They get into what regeneration looks like, why humans can't do it (yet) and where the science may lead us in the decades to come.

Listen to Short Wave on Spotify, Apple Podcasts and Google Podcasts.

Have a science mystery? Send us your questions to shortwave@npr.org.


Learn more about sponsor message choices: podcastchoices.com/adchoices

NPR Privacy Policy

NPR's Book of the Day - Novels by Hila Blum and William Landay unravel family mysteries

Today's episode is all about figuring out the moment things went wrong between family members – and how the fallout has long lasting effects on everyone involved. First, NPR's Mary Louise Kelly speaks with author Hilda Blum about her novel How to Love Your Daughter, and what it means for a mother and daughter's bond to be tested over time. Then, Here & Now's Tiziana Dearing asks William Landay about his new thriller, All That Is Mine I Carry With Me, in which a missing woman's children have been raised by the man police believe may have killed her.

Learn more about sponsor message choices: podcastchoices.com/adchoices

NPR Privacy Policy

It Could Happen Here - CZM Rewind: Shinzo Abe, the World’s Most Assassinated Man

In our last episode of the break we revisit the immediate aftermath of the assassination of former Japanese Prime Minister and right-wing fanatic Shinzo Abe at the hands of a contraption wielding Japanese navy quatermaster.

See omnystudio.com/listener for privacy information.

array(3) { [0]=> string(150) "https://www.omnycontent.com/d/programs/e73c998e-6e60-432f-8610-ae210140c5b1/78d30acb-8463-4c40-a5ae-ae2d0145c9ff/image.jpg?t=1749835422&size=Large" [1]=> string(10) "image/jpeg" [2]=> int(0) }

Honestly with Bari Weiss - We’re All “a Little Bit Dumber”: A Night Among GOP Hopefuls

On Wednesday night, Fox Business and Rumble hosted the second Republican presidential debate at the Ronald Reagan Presidential Library in beautiful Simi Valley, California. Bari Weiss and The Free Press’s very own Peter Savodnik watched live in the spin room as the seven candidates—Ron DeSantis, Vivek Ramaswamy, Nikki Haley, Mike Pence, Chris Christie, Tim Scott, and Doug Burgum— took the stage to spar over questions about union strikes, inflation, income inequality, the cost of childcare, the border, China, crime, policing, drugs, gun violence, education, Russia, Ukraine. . . really, nothing new.


But of course, the man they really wanted to spar with and the man leading the polls by a landslide still refuses to play ball. So, we sent TFP reporter Michael Moynihan to check in on the elusive Donald Trump, who spent his night on the other side of the country speaking to a crowded room, which he claimed would be full of striking auto workers. (Though, Moynihan had a hard time finding them.) Trump’s Detroit visit came just one day after President Biden went to the picket line in Wayne County to march with union members outside a General Motors plant—an unprecedented move by a sitting president.


On today’s episode, as the two likely 2024 candidates battled to portray themselves as the voice of blue-collar Americans, what were the seven GOP hopefuls hoping to achieve by squabbling at the Reagan Library instead of marching with striking auto workers? Who were the biggest winners and losers of this very strange tale of two cities? And with nearly 60 percent of GOP voters backing Trump, is anyone emerging as a viable Trump competitor, or is it time to face the fact that we’re tumbling toward a 2020 rematch between two very old men that no one really wants to see happen?


Music in this episode by blue dot sessions

Learn more about your ad choices. Visit megaphone.fm/adchoices

CBS News Roundup - 09/28/2023 | World News Round Up Late Edition

House Republicans move forward with impeachment proceedings. Another possible 2024 GOP Presidential contender? More looting in Philly. CBS News Correspondent Matt Pieper with tonight's World News Roundup.

To learn more about listener data and our privacy practices visit: https://www.audacyinc.com/privacy-policy

Learn more about your ad choices. Visit https://podcastchoices.com/adchoices

The Gist - A Constitution Ripe For Authoritarian Exploitation

We're joined again by Heather Cox Richardson to continue discussing her new book Democracy Awakening: Notes on the State of America. Rutherford B. Hayes gets taken down a peg. Also on the show, the second Republican debate wasn't great. Plus, pods about getting frisky with a dolphin, and a nudist colony serving as a witness protection program.

Interested in checking out Mike's live appearance on The Wrong Take with Lou Perez in Rutherford, New Jersey on Friday. Click here.


Produced by Joel Patterson and Corey Wara

Email us at thegist@mikepesca.com

To advertise on the show, visit: https://advertisecast.com/TheGist


Subscribe to The Gist Subscribe: https://subscribe.mikepesca.com/

Follow Mikes Substack at: Pesca Profundities | Mike Pesca | Substack

Learn more about your ad choices. Visit podcastchoices.com/adchoices

Consider This from NPR - Here’s How a Government Shutdown Could Impact Millions of Americans

The federal government will shut down on October 1st if Congress doesn't pass funding legislation for the next fiscal year before then.

That looks increasingly likely as House Republicans continue to hold out for deep spending cuts before agreeing to any deal to keep the government running.

A shutdown could potentially affect millions of Americans, among them some of the country's most vulnerable people.

Host Ari Shapiro speaks with a trio of NPR correspondents about the potential impact of a government shutdown.

Email us at considerthis@npr.org.


Learn more about sponsor message choices: podcastchoices.com/adchoices

NPR Privacy Policy

This Machine Kills - 286. No King But Ludd (ft. Brian Merchant)

We are joined by Brian Merchant—LA Times tech columnist, author of Blood in the Machine, dear friend of TMK, general in the Ludd Army—to talk about his extraordinary new book. Brian has produced a masterwork on the history and legacy of Luddism. A deeply researched, thrilling narrative, filled with sharp insights, this book is the definitive story of the Luddite Rebellion and the birth of industrial capitalism. ••• Blood in the Machine: The Origins of the Rebellion Against Big Tech | Brian Merchant https://www.hachettebookgroup.com/titles/brian-merchant/blood-in-the-machine/9780316487740/ Subscribe to hear more analysis and commentary in our premium episodes every week! https://www.patreon.com/thismachinekills Hosted by Jathan Sadowski (www.twitter.com/jathansadowski) and Edward Ongweso Jr. (www.twitter.com/bigblackjacobin). Production / Music by Jereme Brown (www.twitter.com/braunestahl)

Lex Fridman Podcast - #398 – Mark Zuckerberg: First Interview in the Metaverse

Mark Zuckerberg is CEO of Meta. Please support this podcast by checking out our sponsors:
LMNT: https://drinkLMNT.com/lex to get free sample pack
InsideTracker: https://insidetracker.com/lex to get 20% off
Eight Sleep: https://www.eightsleep.com/lex to get special savings
AG1: https://drinkag1.com/lex to get 1 month supply of fish oil
NetSuite: http://netsuite.com/lex to get free product tour

Transcript: https://lexfridman.com/mark-zuckerberg-3-transcript

EPISODE LINKS:
Mark’s Facebook: https://facebook.com/zuck
Mark’s Instagram: https://instagram.com/zuck
Mark’s Threads: https://threads.net/@zuck
Meta AI: https://ai.meta.com/
Meta Quest: https://www.meta.com/quest/
Meta Connect 2023: https://www.metaconnect.com

PODCAST INFO:
Podcast website: https://lexfridman.com/podcast
Apple Podcasts: https://apple.co/2lwqZIr
Spotify: https://spoti.fi/2nEwCF8
RSS: https://lexfridman.com/feed/podcast/
YouTube Full Episodes: https://youtube.com/lexfridman
YouTube Clips: https://youtube.com/lexclips

SUPPORT & CONNECT:
– Check out the sponsors above, it’s the best way to support this podcast
– Support on Patreon: https://www.patreon.com/lexfridman
– Twitter: https://twitter.com/lexfridman
– Instagram: https://www.instagram.com/lexfridman
– LinkedIn: https://www.linkedin.com/in/lexfridman
– Facebook: https://www.facebook.com/lexfridman
– Medium: https://medium.com/@lexfridman

OUTLINE:
Here’s the timestamps for the episode. On some podcast players you should be able to click the timestamp to jump to that time.
(00:00) – Introduction
(08:38) – Metaverse
(23:01) – Quest 3
(37:50) – Nature of reality
(42:28) – AI in the Metaverse
(59:26) – Large language models
(1:05:23) – Future of humanity