How to write high-performance SQL for your Postgres database

How to write high-performance SQL for your Po...

The Stack Overflow PodcastThe Stack Overflow Podcast

Up next

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

 . 35min 38sec
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

 . 31min 34sec

Recommended Episodes

Big data is dead, analytics is alive
Practical AI

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

 . 50min 19sec
scikit-learn & data science you own
Practical AI

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

 . 52min 2sec
839: Prisma ORM: Local First, Typed SQL Queries and Serverless with Søren Bramer Schmidt
Syntax - Tasty Web Development Treats

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

 . 54min 51sec
803: The SQLite Takeover with Turso’s Glauber Costa
Syntax - Tasty Web Development Treats

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

 . 1h 0min