![How to write high-performance SQL for your Postgres database](https://www.cdn5.niftycent.com/d/k/o/x/9/G/7/how-to-write-high-performance-sql-for-your-postgres-database.webp)
Ben and Ryan talk with Lukas Fittl, founder and CEO of pganalyze, which provides in-depth Postgres database monitoring and optimization. They talk about why Lukas considers himself a founder-CEO by title but engineer by trade, what’s important to understand about SQL, and the role of AI in database optimization. https://stackoverflow.blog/2023/09/28/how-to-write-high-performance-sql-for-your-postgres-database/
![Being creative with math: The immersive artist who traded a sketchpad for a keyboard](https://www.cdn5.niftycent.com/d/D/y/5/9/Y/0/being-creative-with-math-the-immersive-artist-who-traded-a-sketchpad-for-a-keyboard.webp)
On this sponsored episode, Ben, Cassidy, and Ryan are joined by Luyang Zou, who is a creative coder, artist, architect, and Ambassador for today’s sponsor, Logitech. They chat about the creates amazing immersive spaces that he creates with a keyboard and mouse the process (and Processing), and what software and hardware play a role. https://stackoverflow.blog/2023/09/27/being-creative-with-math-the-immersive-artist-who-traded-a-sketchpad-for-a-keyboard/
![Celebrating 15 Years of Stack Overflow](https://www.cdn5.niftycent.com/d/1/p/M/R/z/N/celebrating-15-years-of-stack-overflow.webp)
From Angular JS to Raspberry Pi, from React to Prompt Engineering, our community has been asking questions and sharing knowledge that helps the entire world build better. https://stackoverflow.blog/2023/09/26/celebrating-15-years-of-stack-overflow/
![Like Python++ for AI developers](https://www.cdn5.niftycent.com/d/e/7/0/v/O/a/like-python-for-ai-developers.webp)
This is part two of our conversation with Chris Lattner, creator of Swift, Clang, and LLVM and CEO/cofounder of Modular AI. https://stackoverflow.blog/2023/09/25/like-python-for-ai-developers/
![Behind the scenes with OverflowAI Search](https://www.cdn5.niftycent.com/d/k/z/6/7/z/v/behind-the-scenes-with-overflowai-search.webp)
Go behind the scenes with how we designed our new search. https://stackoverflow.blog/2023/09/25/behind-the-scenes-with-overflowai-search/
![Mojo: The usability of Python with the performance of C](https://www.cdn5.niftycent.com/d/k/8/V/y/A/A/mojo-the-usability-of-python-with-the-performance-of-c.webp)
Chris Lattner helped create Swift, Clang, and LLVM. Now CEO and cofounder of Modular AI, he tells the home team how they built Mojo, a new programming language for AI developers that can be thousands of times faster than Python. https://stackoverflow.blog/2023/09/21/mojo-the-usability-of-python-with-the-performance-of-c/
![Do you need a specialized vector database to implement vector search well?](https://www.cdn5.niftycent.com/d/1/N/E/O/E/R/do-you-need-a-specialized-vector-database-to-implement-vector-search-well.webp)
Semantic search and augmenting LLMs have sent everyone turning their text into vectors. But where do you store all that vector data? https://stackoverflow.blog/2023/09/20/do-you-need-a-specialized-vector-database-to-implement-vector-search-well/
![Forget AGI. Let’s built ADI: Augmented Developer Intelligence](https://www.cdn5.niftycent.com/d/1/N/E/E/4/o/forget-agi-let-s-built-adi-augmented-developer-intelligence.webp)
This is part two of our conversation with Replit CEO and founder Amjad Masad. https://stackoverflow.blog/2023/09/18/forget-agi-let-s-built-adi-augmented-developer-intelligence/
![Multiplayer programming on mobile: a chat with Replit CEO Amjad Masad](https://www.cdn5.niftycent.com/d/k/X/Z/Z/m/E/multiplayer-programming-on-mobile-a-chat-with-replit-ceo-amjad-masad.webp)
The home team talks with Replit CEO and founder Amjad Masad about the democratization of coding tools; why Replit prioritized a mobile coding app; and the technical challenges of a real-time, multi-user IDE. This is part one of our conversation. https://stackoverflow.blog/2023/09/14/multiplayer-programming-on-mobile-a-chat-with-replit-ceo-amjad-masad/
![How to land the manager-to-IC pivot](https://www.cdn5.niftycent.com/d/e/j/z/z/a/K/how-to-land-the-manager-to-ic-pivot.webp)
The conventional metaphor for career success is a ladder, but there are a lot of problems with this narrative. https://stackoverflow.blog/2023/09/13/how-to-land-the-manager-to-ic-pivot/