logo
episode-header-image
Sep 2023
24m 44s

How to write high-performance SQL for yo...

The Stack Overflow Podcast
About this episode
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 acqu ... Show More
Up next
May 1
Time is a construct but it can still break your software
Ryan welcomes Jason Williams, senior software engineer at Bloomberg and the creator of Rust-based JavaScript engine Boa, to the show to dive into why date and time handling in JavaScript is so difficult and how the Temporal proposal aims to fix it. They explore the current flaws ... Show More
35m 38s
Apr 28
Your LLM issues are really data issues
Ryan welcomes Harsha Chintalapani, co-founder and CTO at Collate and co-creator of Open Metadata, to the show to discuss why AI and LLMs struggle with real-time, structured production data. They explore how schema changes, inconsistent definitions (like “customer”), and weak gove ... Show More
31m 34s
Apr 24
Lights, camera, open source!
Ryan is joined on the show by Cult.Repo producers Emma Tracey and Josiah Mcgarvie to discuss making documentaries about open-source software and the people behind the major technologies that uphold the internet. They explore why open-source projects and the people who maintain th ... Show More
25m 33s
Recommended Episodes
Oct 2024
Big data is dead, analytics is alive
We are on the other side of “big data” hype, but what is the future of analytics and how does AI fit in? Till and Adithya from MotherDuck join us to discuss why DuckDB is taking the analytics and AI world by storm. We dive into what makes DuckDB, a free, in-process SQL OLAP datab ... Show More
50m 19s
Nov 2024
scikit-learn & data science you own
We are at GenAI saturation, so let’s talk about scikit-learn, a long time favorite for data scientists building classifiers, time series analyzers, dimensionality reducers, and more! Scikit-learn is deployed across industry and driving a significant portion of the “AI” that is ac ... Show More
52m 2s
Oct 2024
839: Prisma ORM: Local First, Typed SQL Queries and Serverless with Søren Bramer Schmidt
Scott and Wes talk with Søren Bramer Schmidt, Founder and CEO of Prisma, about database best practices, including the latest developments in serverless, local-first, and typed SQL solutions. Show Notes 00:00 Welcome to Syntax! 02:55 Søren’s thoughts on GraphQL 03:53 Brough ... Show More
54m 51s
Aug 2024
803: The SQLite Takeover with Turso’s Glauber Costa
Scott and Wes chat with Glauber Costa from Turso about the evolution of databases and the fascinating technology behind Turso. They dive into topics like the benefits of massive multi-tenancy, vector search, and why Glauber made the switch from NoSQL to relational databases. Sho ... Show More
1 h
Jul 2024
SE Radio 623: Michael J. Freedman on TimescaleDB
<p><strong>Michael J. Freedman</strong>, the Robert E. Kahn Professor in the Computer Science Department at Princeton University, as well as the co-founder and CTO of Timescale, spoke with SE Radio host <a title="‌" href= "https://se-radio.net/team/gavin-henry/" target="_blank" r ... Show More
1h 5m
Jan 2025
#704: #704: Scaling your relational database on AWS - Are relational databases cool again?
Are relational databases cool again? In this episode of the AWS Podcast, host Simon Elisha sits down with Josh Hart, Principal Solutions Architect at AWS, to explore how traditional databases are getting a modern makeover. They dive into three game-changing innovations from AWS t ... Show More
23m 43s
Sep 2019
Episode 286: 286: SQL Smart with Nancy Sheleheda
<p>Nancy Sheleheda, Senior Director of Application Development at PCT, joined Brittany to discuss why it is important to learn SQL, to engage in a debate on differences between a developer and a DBA and introduce some great resources to leveling up on SQL.</p> <p>Links for this e ... Show More
30m 28s
Apr 2025
Sequential Scans in Postgres just got faster
This new PostgreSQL 17 feature is game changer. They know can combine IOs when performing sequential scan. Grab my database coursehttps://courses.husseinnasser.com 
27m 36s
Dec 2024
The Art of Database Selection and Evolution
Summary In this episode of the Data Engineering Podcast Sam Kleinman talks about the pivotal role of databases in software engineering. Sam shares his journey into the world of data and discusses the complexities of database selection, highlighting the trade-offs between differen ... Show More
59m 56s
Aug 2024
Picking a database should be simple (Changelog & Friends #56)
Database aficionado, Ben Johnson, joins Jerod to answer the age ol' question: which database should you use? Answering that isn't always easy, which means it's time to play the "It Depends" jingle & weigh (some of) the options. 
1h 6m