Podcasts about postgres

Dharshan Rangegowda, founder of ScaleGrid, left a decade-long engineering career at Microsoft to solve a painful database operations problem he had lived firsthand. After early missteps selling to enterprises, he shifted to helping developers manage MongoDB, Redis, and Postgres on the cloud, bootstrapping the business from scratch. ScaleGrid grew steadily through product depth, technical support, and Dharshan's mastery of SEO—becoming the top organic result for many key searches. The company expanded into multiple database engines, added a distributed engineering team, and reached 20 employees by 2021, serving both SMB developers and some enterprise teams.  Dharshan sold a majority stake to Spotlight Equity Partners during the pandemic after receiving an unsolicited offer, later stepping out of day-to-day operations while remaining on the board.  In this conversation, Dharshan shares hard-earned lessons about product-led growth, support as strategy, SEO as a long-game advantage, and how bootstrapped founders can build meaningful outcomes in massive markets.  Key Takeaways SEO Power: SEO remains a long-term growth engine for bootstrappers because big VC-backed companies rarely have the patience to compound it. Support as Strategy: Deep, responsive technical support became ScaleGrid's differentiator and directly informed product innovation and content. Start at the Edges: Enterprises won't buy from a one-person startup, but edge users with urgent problems will — and they become your early beachhead. Bootstrap Constraints: Founder over-frugality can limit growth; strategic delegation and early team building prevent burnout and plateauing. This Interview Is Perfect For Bootstrap SaaS founders Technical founders selling to developers Founders stuck in early traction or slow growth Anyone considering a PE exit or multi-year acquisition process Quote from Darshan Rangegowda, founder of ScaleGrid "You can't take random people and make them an entrepreneur. You have to want to be an entrepreneur and want to be on your own. You have to enjoy the freedom and the risk and the upside that comes with it and the unmitigated downside as well. You have to accept and be comfortable with it.  "You want to be on your own so you can try things. You are constantly looking at problems and new solutions. You want to be around people who like that sort of process: Here's a new problem and here's a new solution.  "But the most important thing you have to do as an entrepreneur is you have to add value to your customers. And most people forget that." Links Dharshan Rangegowda on LinkedIn ScaleGrid on LinkedIn ScaleGrid website Spotlight Equity Partners (acquirer) Allied Advisers (M&A advisor) AngelPad Accelerator Podcast Sponsor – Designli This podcast is sponsored by Designli, a digital product studio that helps entrepreneurs and startups turn their software ideas into reality. From strategy and design to full-scale development, Designli guides you through every step of building custom web and mobile apps. Learn more at designli.co/practical. The Practical Founders Podcast Tune into the Practical Founders Podcast for weekly in-depth interviews with founders who have built valuable software companies without big funding. Subscribe to the Practical Founders Podcast using your favorite podcast app or view on our YouTube channel. Get the weekly Practical Founders newsletter and podcast updates at practicalfounders.com. Practical Founders CEO Peer Groups Be part of a committed and confidential group of practical founders creating valuable software companies without big VC funding.  A Practical Founders Peer Group is a committed and confidential group of founders/CEOs who want to help you succeed on your terms. Each Practical Founders Peer Group is personally curated and moderated by Greg Head.

Nik and Michael discuss the various changes to EXPLAIN that arrived in Postgres 18. Here are some links to things they mentioned: EXPLAIN (official docs) https://www.postgresql.org/docs/current/sql-explain.htmlUsing EXPLAIN (official docs) https://www.postgresql.org/docs/current/using-explain.html EXPLAIN glossary (pgMustard site) https://www.pgmustard.com/docs/explainPostgres 18 release notes https://www.postgresql.org/docs/release/18.0/Enable BUFFERS with EXPLAIN ANALYZE by default (commit) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c2a4078ebOur (first) BUFFERS by default episode https://postgres.fm/episodes/buffers-by-default Show index search count in EXPLAIN ANALYZE (commit) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0fbceae841cb5a31b13d3f284ac8fdd19822ecebOur episode on Skip scan with Peter Geoghegan https://postgres.fm/episodes/skip-scanWhat do the new Index Searches lines in EXPLAIN mean? https://www.pgmustard.com/blog/what-do-index-searches-in-explain-meanpg_stat_plans presentation by Lukas Fittl https://www.youtube.com/watch?v=26coQV3f-wkImprove EXPLAIN's display of window functions (commit) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=8b1b34254Show Parallel Bitmap Heap Scan worker stats in EXPLAIN ANALYZE (commit) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=5a1e6df3bAdd information about WAL buffers being full (commit) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=320545bfc ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

In this episode, Gajus Kuizinas, co-founder and CTO of Contra, joins Aaron to talk about building the engineering world you want to live in, from strict runtime-validated SQL with Slonik to creating high-ownership engineering cultures. They dive into developer experience, runtime assertions, SafeQL, and even “Loom-driven development,” a powerful review process that lets teams move fast without breaking things.Follow Gajus:Twitter/X:  https://twitter.com/kuizinasSlonk: https://github.com/gajus/slonikScaling article: https://gajus.medium.com/lessons-learned-scaling-postgresql-database-to-1-2bn-records-month-edc5449b3067Follow Aaron:Twitter/X:  https://twitter.com/aarondfrancis Database School: https://databaseschool.comDatabase School YouTube Channel: https://www.youtube.com/@UCT3XN4RtcFhmrWl8tf_o49g  (Subscribe today)LinkedIn: https://www.linkedin.com/in/aarondfrancisWebsite: https://aaronfrancis.com - find articles, podcasts, courses, and more.Chapters:00:00 – Introduction01:03 – Meet Gajus and Contra01:48 – What Contra does and how it's different05:34 – Why Slonik exists & early career origins07:47 – The early Node.js era and frustrations with ORMs09:50 – SQL vs abstractions and the case for raw SQL10:35 – Template tags and the breakthrough idea12:03 – Strictness, catching errors early & data shape guarantees13:37 – Runtime type checking, Zod, and performance debates16:02 – SafeQL and real-time schema linting17:01 – Synthesizing Slonik's philosophy21:29 – Handling drift, static types vs reality22:52 – Defining schemas per-query & why it matters27:59 – Integrating runtime types with large test suites31:00 – Scaling the team and performance tradeoffs33:41 – Runtime validation cost vs developer productivity35:21 – Real drift examples from payments & external APIs38:21 – User roles, data shape differences & edge cases39:51 – Integration test safety & catching issues pre-deploy40:52 – Contra's engineering culture41:47 – Why traditional PR reviews don't scale43:22 – Introducing Loom-Driven Development45:12 – How looms transformed the review process52:38 – Using GetDX to measure engineering friction53:07 – How the team uses AI (Claude, etc.)56:26 – Closing thoughts on DX and engineering philosophy58:05 – Contra needs Postgres experts59:00 – Where to find Gajus

Presque tous les devs l'utilisent… Sans rien y comprendre.

Episode SummaryIn this conversation, Robby sits down with software engineer and author Chris Zetter to explore what building a relational database from scratch can teach us about maintainability, architectural thinking, and team culture. Chris shares why documentation often matters more than perfectly shaped code, why pairing accelerates learning and quality, and why “boring technology” is sometimes the most responsible choice. Together they examine how teams get stuck in local maxima, how junior engineers build confidence, and how coding agents perform when asked to implement a database.Episode Highlights[00:01:00] What Makes Software MaintainableChris explains that well-maintained software is defined by how effectively it helps teams deliver value and respond to change. In some domains—like payroll systems—the maintainability burden shifts toward documentation rather than code organization.[00:03:50] Documentation vs. Code CommentsHe describes visual docs, system diagrams, and commit–ticket links as more durable sources of truth than inline comments, which tend to rot and discourage refactoring.[00:05:15] Rethinking Technical DebtChris argues that teams overuse the metaphor. He prefers naming the specific reason something is slow or brittle—like outdated libraries or rushed decisions—because that builds trust and clarity with product partners.[00:07:45] Where Core Debt Really LivesEarlier in his career he obsessed over long files; now he focuses on structural issues. Architecture, boundaries, and naming affect changeability far more than messy internals.[00:08:15] Pairing as the Default ToolChris loves pairing for its speed, clarity, and shared context. Remote pairing has removed obstacles like mismatched keyboard setups or cramped office seating. Tools like Tuple and Pop keep it smooth.[00:10:20] The Mob Tool and Fast Driver SwitchingHe explains how the Mob CLI tool makes switching drivers nearly instant, which keeps energy high and lets everyone work in their own editor environment, reducing friction and fatigue.[00:13:45] Pairing with Junior EngineersPairing helps newer developers avoid painful pull-request rework and builds confidence. But teams must balance pairing with opportunities for engineers to build autonomy.[00:20:50] Getting Feedback SoonerChris emphasizes speed of feedback: showing progress early to stakeholders prevents wasted days—and sometimes weeks—of heading in the wrong direction.[00:21:10] Boring Technology as a FeatureAfter being burned by abandoned frameworks, Chris champions predictable, well-supported tools for the big layers: language, framework, database. Novelty is great—but only in places where rollback is cheap.[00:23:20] Balancing Professional Development with Organizational NeedsDevelopers want experience with new technology; organizations want stability. Chris describes how leaders can channel curiosity safely and productively.[00:27:20] Build a Database ServerChris's book, Build a Database Server, is a practical, language-agnostic guide to building a relational database from scratch. It uses a test suite as a feedback loop so developers can experiment, refactor, and learn architectural trade-offs along the way.[00:31:45] What Writing the Book Taught HimCreating a database deepened his appreciation for Postgres maintainers. He highlights the number of moving parts—storage engine, type system, query planner, wire protocol—and how academic papers often skip hands-on guidance.[00:33:00] Experimenting with Coding AgentsChris tested coding agents by giving them the book's test suite. They passed many tests but produced brittle, incoherent architecture. Without a feedback loop for quality, the agents aimed only to satisfy test conditions—not build maintainable systems.[00:36:55] Escaping a Local Maxima Through a Design SprintChris shares a story of a team stuck maintaining a system that no longer fit business needs. A design sprint gave them space to reimagine the system, clarify naming, validate concepts, and identify which pieces were worth reusing.[00:40:40] Rewrite vs. RefactorHe leans toward refactor for large systems but supports small, isolated rewrites when boundaries are clear.[00:41:40] Building Trust in Legacy CodeWhen inheriting an old codebase, Chris advises starting with a small bug fix or UI tweak to understand deployment pipelines, test coverage, and failure modes before tackling bigger improvements.[00:43:20] Recommended ReadingChris recommends _Turn the Ship Around! for its lessons on empowering teams to act with intent instead of waiting for permission.Resources MentionedBuild a Database ServerChris Zetter's blogThe Mob Programming CLI ToolTuplePopTurn the Ship Around!Thanks to Our Sponsor!Turn hours of debugging into just minutes! AppSignal is a performance monitoring and error-tracking tool designed for Ruby, Elixir, Python, Node.js, Javascript, and other frameworks.It offers six powerful features with one simple interface, providing developers with real-time insights into the performance and health of web applications.Keep your coding cool and error-free, one line at a time! Use the code maintainable to get a 10% discount for your first year. Check them out! Subscribe to Maintainable on:Apple PodcastsSpotifyOr search "Maintainable" wherever you stream your podcasts.Keep up to date with the Maintainable Podcast by joining the newsletter.

For memberships: join this channel as a member here:https://www.youtube.com/channel/UC_mGuY4g0mggeUGM6V1osdA/joinExploring Cloud Databases, Scalability, and Simple Engineering with Sam Lambert, CEO of PlanetScaleIn this episode of The Geek Narrator podcast, we welcome Sam Lambert, CEO and Co-Founder of PlanetScale, known for creating the world's fastest and most scalable cloud database. Sam shares his insights on databases, operational excellence, and simple engineering. We discuss topics such as scalability, Postgres versus MySQL, and replication. Sam also talks about handling complexity in engineering, the unique features of Vites, and how PlanetScale achieves high availability. Don't miss this deep dive into the future of cloud databases. Like, share, and subscribe to support the channel!Chapters:00:00 Introduction and Episode Overview01:13 Meet Sam Lambert: Background and Career02:42 Balancing Work and Social Media05:48 The Philosophy of Simple Engineering14:21 The Slotted Counter Pattern at GitHub18:27 Postgres vs MySQL: Design Flaws and Philosophical Differences28:58 Sharding and Scaling with Vitess37:01 Database Branching and Schema Changes38:50 Common Practices in Startups39:07 Challenges with Data Branching40:45 Legal and Ethical Considerations42:31 Staging Environments vs. Dev Branches45:26 Trade-offs in Cloud Databases52:41 Replication and Durability01:00:02 Ensuring High Availability01:08:04 Backup Strategies and Testing01:10:41 Conclusion and Final ThoughtsLearn about PlanetScale: https://planetscale.com/For memberships: join this channel as a member here:https://www.youtube.com/channel/UC_mGuY4g0mggeUGM6V1osdA/joinDon't forget to like, share, and subscribe for more insights!=============================================================================Like building stuff? Try out CodeCrafters and build amazing real world systems like Redis, Kafka, Sqlite. Use the link below to signup and get 40% off on paid subscription.https://app.codecrafters.io/join?via=geeknarrator=============================================================================Database internals series: https://youtu.be/yV_Zp0Mi3xsPopular playlists:Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_dModern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsNStay Curios! Keep Learning!

Nik talks Michael through a recent benchmark he worked with Maxim Boguk on, to see how quickly they could provision a replica. Here are some links to things they mentioned:Ultra-fast replica creation with pgBackRest (blog post by Maxim Boguk and Nik) https://postgres.ai/blog/20251105-postgres-marathon-2-012-ultra-fast-replica-creation-pgbackrestCopying a database episode https://postgres.fm/episodes/copying-a-databaseAdd snapshot backup support for PostgreSQL in wal-g (draft PR by Andrey Borodin) https://github.com/wal-g/wal-g/pull/2101Multi-threaded pg_basebackup discussion 1: https://www.postgresql.org/message-id/flat/CAEHH7R4%3D_GN%2BLSsj0YZOXZ13yc%3DGk9umJOLNopjS%3DimK0c1mWA%40mail.gmail.comMulti-threaded pg_basebackup discussion 2: https://www.postgresql.org/message-id/flat/io_method https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-IO-METHOD pgBackRest https://github.com/pgbackrest/pgbackrestAdd sequence synchronization for logical replication (commit) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=5509055d6956745532e65ab218e15b99d87d66ce Allow process priority to be set (pgBackRest feature added by David Steele) https://github.com/pgbackrest/pgbackrest/pull/2693 Hard limit on process-max (pgBackRest issue from 2019) https://github.com/pgbackrest/pgbackrest/issues/696 ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

Postgres has quietly become the world's favorite database...running startups, governments, and global clouds alike. Scott talks with Claire Giordano, long-time Postgres advocate and technologist, about the database's unlikely rise from academic roots to modern dominance. They explore its design philosophy, the open-source community that fuels it, and why Postgres keeps winning even in the age of AI and hyperscale data.https://www.postgresql.org/

Waymo's VP of Research, Drago Anguelov, joins Practical AI to explore how advances in autonomy, vision models, and large-scale testing are shaping the future of driverless technology. The conversation dives into the dual challenges of building an onboard driver and testing that driver (via large scale simulation). Drago also gives us an update on what Waymo is doing to achieve intelligent, real-time performance while ensuring proven safety and reliability.Featuring:Drago Anguelov – LinkedInChris Benson – Website, LinkedIn, Bluesky, GitHub, XDaniel Whitenack – Website, GitHub, XLinks:Waymo ResearchNew Insights for Scaling Laws in Autonomous DrivingAI in MotionSponsors: Outshift by Cisco - The open source collective building the Internet of Agents. Backed by Outshift by Cisco, AGNTCY gives developers the tools to build and deploy multi-agent software at scale. Identity, communication protocols, and modular workflows—all in one global collaboration layer. Start building at AGNTCY.org.Shopify – The commerce platform trusted by millions. From idea to checkout, Shopify gives you everything you need to launch and scale your business—no matter your level of experience. Build beautiful storefronts, market with built-in AI tools, and tap into the platform powering 10% of all U.S. eCommerce. Start your one-dollar trial at shopify.com/practicalaiFabi.ai - The all-in-one data analysis platform for modern teams. From ad hoc queries to advanced analytics, Fabi lets you explore data wherever it lives—spreadsheets, Postgres, Snowflake, Airtable and more. Built-in Python and AI assistance help you move fast, then publish interactive dashboards or automate insights delivered straight to Slack, email, spreadsheets or wherever you need to share it. Learn more and get started for free at fabi.aiUpcoming Events: Register for upcoming webinars here!

In this episode of Crazy Wisdom, host Stewart Alsop talks with Jessica Talisman, founder of Contextually and creator of the Ontology Pipeline, about the deep connections between knowledge management, library science, and the emerging world of AI systems. Together they explore how controlled vocabularies, ontologies, and metadata shape meaning for both humans and machines, why librarianship has lessons for modern tech, and how cultural context influences what we call “knowledge.” Jessica also discusses the rise of AI librarians, the problem of “AI slop,” and the need for collaborative, human-centered knowledge ecosystems. You can learn more about her work at Ontology Pipeline and find her writing and talks on LinkedIn.Check out this GPT we trained on the conversationTimestamps00:00 Stewart Alsop welcomes Jessica Talisman to discuss Contextually, ontologies, and how controlled vocabularies ground scalable systems.05:00 They compare philosophy's ontology with information science, linking meaning, categorization, and sense-making for humans and machines.10:00 Jessica explains why SQL and Postgres can't capture knowledge complexity and how neuro-symbolic systems add context and interoperability.15:00 The talk turns to library science's split from big data in the 1990s, metadata schemas, and the FAIR principles of findability and reuse.20:00 They discuss neutrality, bias in corporate vocabularies, and why “touching grass” matters for reconciling internal and external meanings.25:00 Conversation shifts to interpretability, cultural context, and how Western categorical thinking differs from China's contextual knowledge.30:00 Jessica introduces process knowledge, documentation habits, and the danger of outsourcing how-to understanding.35:00 They explore knowledge as habit, the tension between break-things culture and library design thinking, and early AI experiments.40:00 Libraries' strategic use of AI, metadata precision, and the emerging role of AI librarians take focus.45:00 Stewart connects data labeling, Surge AI, and the economics of good data with Jessica's call for better knowledge architectures.50:00 They unpack content lifecycle, provenance, and user context as the backbone of knowledge ecosystems.55:00 The talk closes on automation limits, human-in-the-loop design, and Jessica's vision for collaborative consulting through Contextually.Key InsightsOntology is about meaning, not just data structure. Jessica Talisman reframes ontology from a philosophical abstraction into a practical tool for knowledge management—defining how things relate and what they mean within systems. She explains that without clear categories and shared definitions, organizations can't scale or communicate effectively, either with people or with machines.Controlled vocabularies are the foundation of AI literacy. Jessica emphasizes that building a controlled vocabulary is the simplest and most powerful way to disambiguate meaning for AI. Machines, like people, need context to interpret language, and consistent terminology prevents the “hallucinations” that occur when systems lack semantic grounding.Library science predicted today's knowledge crisis. Stewart and Jessica trace how, in the 1990s, tech went down the path of “big data” while librarians quietly built systems of metadata, ontologies, and standards like schema.org. Today's AI challenges—interoperability, reliability, and information overload—mirror problems library science has been solving for decades.Knowledge is culturally shaped. Drawing from Patrick Lambe's work, Jessica notes that Western knowledge systems are category-driven, while Chinese systems emphasize context. This cultural distinction explains why global AI models often miss nuance or moral voice when trained on limited datasets.Process knowledge is disappearing. The West has outsourced its “how-to” knowledge—what Jessica calls process knowledge—to other countries. Without documentation habits, we risk losing the embodied know-how that underpins manufacturing, engineering, and even creative work.Automation cannot replace critical thinking. Jessica warns against treating AI as “room service.” Automation can support, but not substitute, human judgment. Her own experience with a contract error generated by an AI tool underscores the importance of review, reflection, and accountability in human–machine collaboration.Collaborative consulting builds knowledge resilience. Through her consultancy, Contextually, Jessica advocates for “teaching through doing”—helping teams build their own ontologies and vocabularies rather than outsourcing them. Sustainable knowledge systems, she argues, depend on shared understanding, not just good technology.

Dan and Chris unpack whether today's surge in AI deployment across enterprise workflows, manufacturing, healthcare, and scientific research signals a lasting transformation or an overhyped bubble. Drawing parallels to the dot-com era, they explore how technology integration is reshaping industries, affecting jobs, and even influencing human cognition, ultimately asking: is this a bubble, or just a fizzy new phase of innovation?Featuring:Chris Benson – Website, LinkedIn, Bluesky, GitHub, XDaniel Whitenack – Website, GitHub, XLinks: Powell says that, unlike the dotcom boom, AI spending isn't a bubble: ‘I won't go into particular names, but they actually have earnings'Sponsors:Outshift by Cisco - The open source collective building the Internet of Agents. Backed by Outshift by Cisco, AGNTCY gives developers the tools to build and deploy multi-agent software at scale. Identity, communication protocols, and modular workflows—all in one global collaboration layer. Start building at AGNTCY.org.Shopify – The commerce platform trusted by millions. From idea to checkout, Shopify gives you everything you need to launch and scale your business—no matter your level of experience. Build beautiful storefronts, market with built-in AI tools, and tap into the platform powering 10% of all U.S. eCommerce. Start your one-dollar trial at shopify.com/practicalaiFabi.ai - The all-in-one data analysis platform for modern teams. From ad hoc queries to advanced analytics, Fabi lets you explore data wherever it lives—spreadsheets, Postgres, Snowflake, Airtable and more. Built-in Python and AI assistance help you move fast, then publish interactive dashboards or automate insights delivered straight to Slack, email, spreadsheets or wherever you need to share it. Learn more and get started for free at fabi.aiUpcoming Events: Join us at the Midwest AI Summit on November 13 in Indianapolis to hear world-class speakers share how they've scaled AI solutions. Don't miss the AI Engineering Lounge, where you can sit down with experts for hands-on guidance. Reserve your spot today!Register for upcoming webinars here!

What do guitar busking, geospatial queries, and agentic coding have to do with Postgres? In Episode 33 of Talking Postgres, principal engineer Rob Emanuele at Microsoft shares his winding path from Venice Beach to building a new VS Code extension for PostgreSQL—that works with any Postgres, anywhere. We dig into GitHub Copilot, ask vs. agent mode, and how Rob now codes in English—and then spends even more time in code review to decide what's good, what's bad, and what's dangerous. Also: how PyCon changed his life; his work on the Microsoft Planetary Computer with spatio-temporal queries and PostGIS; and how music, improv, and failure shape his approach to developer experience. Links mentioned in this episode:Visual Studio Marketplace: VS Code extension for PostgreSQL with ~261K downloads to dateGitHub repo: VS Code extension for PostgreSQL (for issues/discussions)Docs: GitHub Copilot agent modePOSETTE 2025 Talk: Introducing Microsoft's VS Code Extension for PostgreSQL, by Matt McFarlandVS Code Live: Working with PostgreSQL databases with the Microsoft PostgreSQL VS Code extension, with Olivia Guzzardo & Rob EmanueleTalking Postgres Ep30: AI for data engineers with Simon WillisonPostgres Meetup for All: VS Code Tools for Postgres, happening on Thu Dec 11, 2025 Wikipedia: DogfoodingTalking Postgres Ep07: Why people care about PostGIS and Postgres with Paul Ramsey & Regina ObePOSETTE 2024 keynote: The Open Source Geospatial Community, PostGIS, & Postgres, by Regina ObeWebsite: Microsoft Planetary ComputerGitHub repo: PgSTACCal invite: LIVE recording of Ep34 of Talking Postgres to happen on Wed Dec 10, 2025

Nik and Michael discuss the concept of gapless sequences — when you might want one, why sequences in Postgres can have gaps, and an idea or two if you do want them.And one quick clarification: changing the CACHE option in CREATE SEQUENCE can lead to even more gaps, the docs mention it explicitly. Here are some links to things they mentioned:CREATE SEQUENCE https://www.postgresql.org/docs/current/sql-createsequence.htmlSequence Manipulation Functions https://www.postgresql.org/docs/current/functions-sequence.htmlOne, Two, Skip a Few (post by Pete Hamilton from Incident io) https://incident.io/blog/one-two-skip-a-fewPostgres sequences can commit out-of-order (blog post by Anthony Accomazzo / Sequin) https://blog.sequinstream.com/postgres-sequences-can-commit-out-of-orderLogical Replication of sequences (hackers thread) https://www.postgresql.org/message-id/flat/CAA4eK1LC%2BKJiAkSrpE_NwvNdidw9F2os7GERUeSxSKv71gXysQ%40mail.gmail.comSynchronization of sequences to subscriber (patch entry in commitfest) https://commitfest.postgresql.org/patch/5111/Get or Create (episode with Haki Benita) https://postgres.fm/episodes/get-or-createGerman tank problem https://en.wikipedia.org/wiki/German_tank_problem~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

En este episodio, me enfrento a un desafío de rendimiento real: el consumo de CPU de PostgreSQL se dispara, pero sin alta actividad de lectura/escritura.Viajaremos a través de un diagnóstico detallado utilizando herramientas nativas de Postgres como pg_stat_activity y pg_stat_statements para desenmascarar las causas ocultas:La Sobrecarga de Conexión: Descubriremos cómo un simple healthcheck de Docker (pg_isready) configurado incorrectamente puede paralizar tu servidor por el alto overhead de gestión de procesos.El Cuello de Botella de la Aplicación: Analizamos y corregimos un error de diseño de código en Rust/Axum donde se recompilan Expresiones Regulares (Regex) en cada petición, consumiendo innecesariamente ciclos de CPU.Una lección práctica esencial para cualquiera que gestione bases de datos, despliegues en Docker o desarrolle aplicaciones eficientes en Rust en entornos Linux. Aprende a identificar estos fallos y a optimizar tu código mediante la precompilación de Regex utilizando TryFrom y Arc.Más información y enlaces en las notas del episodio

For memberships: join this channel as a member here:https://www.youtube.com/channel/UC_mGuY4g0mggeUGM6V1osdA/joinSummaryIn this conversation, Philipp discusses the innovations behind CedarDB, a database system designed from scratch to optimize performance for modern hardware. He explains the foundational principles of compiling SQL to machine code, the importance of parallel processing, and the challenges of maintaining Postgres compatibility. The discussion also covers the system's approach to handling transactional and analytical workloads, data ingestion processes, query optimization strategies, and future developments including schema evolution and disaggregated storage.Takeaways:- CedarDB is built from the ground up to utilize modern hardware effectively.- The system compiles SQL directly to machine code for performance.- Parallel processing is a key feature, allowing efficient use of multiple cores.- CedarDB aims to be Postgres compatible while innovating on performance.- Transactional workloads are handled efficiently without sacrificing analytical capabilities.- Data ingestion is optimized for both row-oriented and columnar formats.- The system uses optimistic concurrency control to manage write conflicts.- Query optimization leverages statistics to improve join performance.- Future developments include schema evolution and disaggregated storage.- CedarDB is designed to be flexible and adaptable for various workloads.Chapters00:00 Introduction to CDRDB and Background of Philipp05:36 Compiling SQL to Machine Code for Performance11:25 General Purpose vs. Analytical Databases16:51 Transactional Workloads and Hybrid Storage Engine54:29 Understanding B-Tree and Columnar Storage01:02:18 Data Duplication and Memory Efficiency01:08:43 Indexing Strategies and B-Tree Optimization01:15:57 Handling Write Conflicts and Transaction Management01:24:10 Query Optimization and Join Strategies01:33:28 Future Developments in Schema Evolution and StorageImportant Links:CedarDB: https://cedardb.com/The Umbra research project: https://umbra-db.com/SQL Query Compilation: http://www.vldb.org/pvldb/vol4/p539-neumann.pdfOptimistic B-Trees: https://cedardb.com/blog/optimistic_btrees/Our B-Tree storage engine: https://cedardb.com/blog/colibri/For memberships: join this channel as a member here:https://www.youtube.com/channel/UC_mGuY4g0mggeUGM6V1osdA/joinDon't forget to like, share, and subscribe for more insights!=============================================================================Like building stuff? Try out CodeCrafters and build amazing real world systems like Redis, Kafka, Sqlite. Use the link below to signup and get 40% off on paid subscription.https://app.codecrafters.io/join?via=geeknarrator=============================================================================Database internals series: https://youtu.be/yV_Zp0Mi3xsPopular playlists:Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_dModern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsNStay Curios! Keep Learning!

In this fully connected episode, Daniel and Chris explore the emerging concept of tiny recursive networks introduced by Samsung AI, contrasting them with large transformer based models. They explore how these small models tackle reasoning tasks with fewer parameters, less data, and iterative refinement, matching the giants on specific problems. They also discuss the ethical challenges of emotional manipulation in chatbots.Featuring: Chris Benson – Website, LinkedIn, Bluesky, GitHub, XDaniel Whitenack – Website, GitHub, XLinks:Less is More: Recursive Reasoning with Tiny NetworksResearchers detail 6 ways chatbots seek to prolong ‘emotionally sensitive events'Sponsors:Outshift by Cisco - The open source collective building the Internet of Agents. Backed by Outshift by Cisco, AGNTCY gives developers the tools to build and deploy multi-agent software at scale. Identity, communication protocols, and modular workflows—all in one global collaboration layer. Start building at AGNTCY.org.Fabi.ai - The all-in-one data analysis platform for modern teams. From ad hoc queries to advanced analytics, Fabi lets you explore data wherever it lives—spreadsheets, Postgres, Snowflake, Airtable and more. Built-in Python and AI assistance help you move fast, then publish interactive dashboards or automate insights delivered straight to Slack, email, spreadsheets or wherever you need to share it. Learn more and get started for free at fabi.aiMiro – The innovation workspace for the age of AI. Built for modern teams, Miro helps you turn unstructured ideas into structured outcomes—fast. Diagramming, product design, and AI-powered collaboration, all in one shared space. Start building at miro.comUpcoming Events: Join us at the Midwest AI Summit on November 13 in Indianapolis to hear world-class speakers share how they've scaled AI solutions. Don't miss the AI Engineering Lounge, where you can sit down with experts for hands-on guidance. Reserve your spot today!Register for upcoming webinars here!

In this episode, Aaron talks with Joran Greef, CEO and creator of TigerBeetle, the world's first financial transactions database. Joran takes us on a deep dive of on how TigerBeetle brings double-entry accounting principles directly into the database layer to achieve extreme correctness, performance, and fault tolerance at scale.Follow Joran and TigerBeetle:Twitter/X: https://twitter.com/jorandirkgreefWebsite: https://tigerbeetle.comGitHub: https://github.com/tigerbeetle/tigerbeetleTiger Style: https://github.com/tigerbeetle/tigerbeetle/blob/main/docs/TIGER_STYLE.mdYouTube: https://www.youtube.com/@UC3TlyQ3h6lC_jSWust2leGg Follow Aaron:Twitter/X:  https://twitter.com/aarondfrancis Database School: https://databaseschool.comDatabase School YouTube Channel: https://www.youtube.com/@UCT3XN4RtcFhmrWl8tf_o49g  (Subscribe today)LinkedIn: https://www.linkedin.com/in/aarondfrancisWebsite: https://aaronfrancis.com - find articles, podcasts, courses, and more.Chapters:00:00 - Introduction and crossover between accounting and databases01:50 - Meet Joran Greef and the origins of TigerBeetle02:55 - What makes TigerBeetle different from general purpose databases04:38 - The founding story and the 5,000-year history of transactions07:42 - How modern commerce became highly transactional10:06 - Recognizing the limits of general purpose databases13:18 - From distributed systems to payment infrastructure17:01 - Discovering bottlenecks in traditional database performance19:58 - Why traditional databases can't scale for microtransactions23:05 - Introducing double-entry accounting concepts25:20 - How double-entry accounting mirrors database design31:35 - Modeling ledgers and event sourcing in Tiger Beetle35:02 - Why TigerBeetle outperforms Postgres and MySQL40:05 - Batching transactions for massive throughput47:09 - Client-side batching and zero-copy efficiency50:04 - Handling contention and concurrency internally56:03 - Ensuring correctness and atomicity in transactions57:17 - Designing for mission-critical systems and reliability1:00:50 - Building safety through deterministic simulation testing1:04:55 - Detecting and recovering from storage faults1:10:00 - How TigerBeetle prevents data corruption1:17:01 - Distributed replication and self-healing data1:20:08 - Who's using TigerBeetle and how it's structured as a company1:24:01 - How to learn more and get involved with TigerBeetle1:26:15 - Closing thoughts and where to find Joran online

This show has been flagged as Clean by the host. Digital Ocean maintains its own version of the Ubuntu core packages which are hosted in it's own repositories. To upgrade from one LTS to the next the do-release-upgrade program must know to use third party repositories during the upgrade process. RELEASE_UPGRADER_ALLOW_THIRD_PARTY=1 do-release-upgrade Moving data from a previous version of Postgres to the latest. In this case, the obsolete Postgres v12 to the default Postgres v14 on Ubuntu 22.04 LTS. pg_dropcluster --stop 14 main pg_upgradecluster -v 14 12 main Fixing NextCloud after the upgrade. The version of PHP upgraded from v7.4 to v8.1. The old versions of the Apache2 PHP modules must be disabled and the new versions enabled. a2dismod php7.4 a2enmod php8.1 apt install php8.1-pgsql apt install php8.1-gd References: How To Upgrade to Ubuntu 22.04 Jammy Jellyfish "Invalid package information" error when upgrading to Ubuntu 20.04 Provide feedback on this episode.

Nik and Michael discuss lightweight locks in Postgres — how they differ to (heavier) locks, some occasions they can be troublesome, and some resources for working out what to do if you hit issues. Here are some links to things they mentioned:Wait Events of Type LWLock https://www.postgresql.org/docs/current/monitoring-stats.html#WAIT-EVENT-LWLOCK-TABLEOur episode on (heavier) locks https://postgres.fm/episodes/locksNik's new marathon posts https://postgres.ai/blog/tags/postgres-marathonPostgres LISTEN/NOTIFY does not scale (blog post by Recall ai) https://www.recall.ai/blog/postgres-listen-notify-does-not-scaleExplicit Locking https://www.postgresql.org/docs/current/explicit-locking.htmlpg_stat_activity https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ACTIVITY-VIEWTuning with wait events for RDS for PostgreSQL https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL.Tuning.htmlMultiXact member exhaustion incidents (blog post by Cosmo Wolfe / Metronome) https://metronome.com/blog/root-cause-analysis-postgresql-multixact-member-exhaustion-incidents-may-2025pg_index_pilot https://gitlab.com/postgres-ai/pg_index_pilotMyths and Truths about Synchronous Replication in PostgreSQL (talk by Alexander Kukushkin) https://www.youtube.com/watch?v=PFn9qRGzTMcPostgres Indexes, Partitioning and LWLock:LockManager Scalability (blog post by Jeremy Schneider) https://ardentperf.com /2024/03/03/postgres-indexes-partitioning-and-lwlocklockmanager-scalability~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

As AI systems move from simple chatbots to complex agentic workflows, new security risks emerge. In this episode, Donato Capitella unpacks how increasingly complicated architectures are making agents fragile and vulnerable. These agents can be exploited through prompt injection, data exfiltration, and tool misuse. Donato shares stories from real-world penetration tests, the design patterns for building LLM agents and explains how his open-source toolkit Spikee (Simple Prompt Injection Kit for Evaluation and Exploitation) is helping red teams probe AI systems.Featuring:Donato Capitella – LinkedIn, XChris Benson – Website, LinkedIn, Bluesky, GitHub, XDaniel Whitenack – Website, GitHub, XLinks:ReversecSponsors:Outshift by Cisco - The open source collective building the Internet of Agents. Backed by Outshift by Cisco, AGNTCY gives developers the tools to build and deploy multi-agent software at scale. Identity, communication protocols, and modular workflows—all in one global collaboration layer. Start building at AGNTCY.org.Shopify – The commerce platform trusted by millions. From idea to checkout, Shopify gives you everything you need to launch and scale your business—no matter your level of experience. Build beautiful storefronts, market with built-in AI tools, and tap into the platform powering 10% of all U.S. eCommerce. Start your one-dollar trial at shopify.com/practicalaiFabi.ai - The all-in-one data analysis platform for modern teams. From ad hoc queries to advanced analytics, Fabi lets you explore data wherever it lives—spreadsheets, Postgres, Snowflake, Airtable and more. Built-in Python and AI assistance help you move fast, then publish interactive dashboards or automate insights delivered straight to Slack, email, spreadsheets or wherever you need to share it. Learn more and get started for free at fabi.aiUpcoming Events: Join us at the Midwest AI Summit on November 13 in Indianapolis to hear world-class speakers share how they've scaled AI solutions. Don't miss the AI Engineering Lounge, where you can sit down with experts for hands-on guidance. Reserve your spot today!Register for upcoming webinars here!

JD Fiscus (nerding.io) shares how a late-night hack connecting MCP to n8n exploded to ~1M downloads, then demos practical MCP workflows: indexing YouTube channels for Q&A, and auto-building n8n flows from natural language. We dig into the Agentic Commerce Protocol, real security pitfalls (like destructive commands), and how to turn MCPs into products with OAuth and Stripe for authentication and metered billing. He closes with how he teaches this hands-on at the Vibe Coding Retreat.Timestamps1:00 Why build it: “MCP shouldn't be Claude-only”—bridging MCP into n8n early (Dec/Jan)2:09 Shipping under the pseudonym nerding.io; surprise seeing creators use it2:25 n8n later ships its own MCP server/client; they nod to nerding.io & Simon3:59 “N8n is useful, but so much more useful with MCP”5:12 What MCP means for software: every smart company is exposing an MCP; new login/usage patterns6:27 Agentic Commerce Protocol (ACP): Stripe + OpenAI; agents checkout across the web8:02 Marketing to agents not humans? SEO shifts as agents comparison-shop9:10 Early “agent mode” attempts vs protocol-based purchases (less hacky)10:58 Likely adopters: platforms (Shopify) & big retailers; echoes of early MCP evolution14:11 Security realities: token passing evolved to OAuth; hallucination + destructive actions risk16:04 Personal mishap: agent ran supabase reset on a dev DB—imagine prod! Guardrails matter17:03 Designing MCP servers: don't just “wrap your API”; use resources/prompts for agentic UX19:04 Demo 1—Influencer MCP: index a YouTube channel, embed transcripts, ask questions in Claude20:54 Storage: embeddings into Postgres; per-channel tables24:46 Keeping it fresh: daily cron to ingest new videos25:18 Demo 2—Build n8n workflows from chat using N8N MCP (by Ramullet); live docs + API27:00 “Create a webhook → send leads to Sheets” built conversationally, with allow/deny prompts31:02 Zapier, Gumloop: agents that build automations via natural-language steps34:00 Next frontier: custom connectors (Claude/Cursor/OpenAI), OAuth auth flows for MCPs39:03 Turning MCPs into products: login with Twitter → Stripe subscription → metered billing41:12 Paid tool call demo: “paid echo” → Stripe usage event logged per user43:41 How to learn this fast: vibecodingretreat.com (small cohorts, hands-on builds)Tools & Technologies Mentioned (quick guide)MCP (Model Context Protocol) — Standard for connecting models to tools/data; supports tools, resources, prompts.n8n — Open-source automation platform; JD wrote an MCP node that went viral; also has native MCP server/client now.Claude / Cursor / OpenAI (custom connectors) — LLM IDEs/chats that can load MCPs; custom connectors enable OAuth + productized access.Agentic Commerce Protocol (ACP) — Early protocol (Stripe + OpenAI) for agent-initiated purchases with confirmations.Web MCP (W3C-oriented idea) — Emerging patterns for agent↔︎website interactions beyond human UI flows.OAuth — Secure, user-consented authentication for MCPs (vs passing raw tokens).Stripe (subscriptions + metered billing) — Attach billing/usage limits to MCP calls; track per-user consumption.YouTube API + Transcripts — Source data for the “Influencer MCP” indexing pipeline.Embeddings + Postgres — Store vectorized transcript chunks in Postgres for retrieval (JD self-hosts).Cron — Schedules daily ingestion of new content.Google Sheets — Target destination in demo for simple lead funnels.Zapier / Gumloop — Natural-language automation builders; early NLA/agent patterns.Git / CLI commands — Cautionary tale: agents running destructive commands (e.g., resets).Do Browser / Comet Browser — Agentic browsing tools referenced for web actions.Fellow.ai — AI meeting assistant with security-first design; generates precise summaries/action items.Subscribe at⁠ thisnewway.com⁠ to get the step-by-step playbooks, tools, and workflows.

What do chess clocks, jazz, and Postgres replication have in common? In Episode 32 of Talking Postgres, solution architect Boriss Mejías shares how the idea of “interconnectedness”—inspired by Douglas Adams—can help you untangle complex Postgres questions. We explore OpenAI's approach to scaling Postgres, how Postgres active-active mirrors Sparta's dual kingship, and how a holistic approach can reveal the behavior of synchronous replication. Also: Beethoven's 17 drafts, and why chasing perfection can hold you back. Listen to learn more about Boriss, Postgres, and the fundamental interconnectedness of all things.Links mentioned in this episode:Podcast Ep32 of Talking Postgres: What went wrong (& what went right) with AIO with Andres FreundPodcast Ep03 of Talking Postgres: Why give talks at Postgres conferences with Álvaro Herrera & Boriss Mejías:  Wikipedia: Dirk Gently's Holistic Detective Agency, by Douglas AdamsTalk at PGConf NYC 2025: Scaling Postgres to the Next Level at OpenAI, by Bohan ZhangVideo of PGConf.dev 2025 talk: Scaling Postgres to the Next Level at OpenAI, by Bohan ZhangTalk at PGConf NYC 2025: Improved Freezing in Postgres Vacuum: From Idea to Commit, by Melanie PlagemanTalk at PGConf NYC 2025: Database Modeling to Study the New York Jazz Scene, by Boriss MejíasJazz Club in NYC: Patrick's Place in HarlemVideo of PGConf EU 2024 talk: Sparta's Dual-Kingship and PostgreSQL Active-Active, by Boriss Mejías Video of POSETTE 2025 talk: Postgres Storytelling: Cunning Schema Design with Creative Data Modeling, by Boriss Mejías & Sarah Conway Talk at FOSDEM PGDay 2024: High Availability Configurations Are Very Common for PostgreSQL, But How Do You Investigate Performance Problems When the Standby Can't Keep Up? by Boriss Mejías and Derk van VeenConference: PGDay Lowlands 2025, the second year of this “second-best Postgres conference in Europe” Conference Schedule: upcoming PGConf EU 2025 in LatviaWikipedia: Chess clockBook: Daily Rituals, by Mason CurreyArticle: It Takes Two to Think, by Itai Yanai & Martin J. LercherPoem: The Rime of the Ancient Mariner, by Samuel ColeridgeWikipedia: City of Bruges Belgium, a good place for beer and cheeseCal invite: LIVE recording of Ep33 of Talking Postgres to happen on Wed Nov 5, 2025

Daniel sits down with Chelsea Linder, VP of Innovation and Entrepreneurship at TechPoint, to explore the what AI innovation and impact look like on the ground.  They discuss Chelsea's journey from the VC world into economic development/ innovation, the growth of an AI innovation network in Indiana (funded by the SBA), lessons learned from fostering AI communities, and how businesses are actually adapting to AI. Chelsea also shares insights from Techpoints AI workforce impact study, which explored AI related job creation and levels of AI adoption among other things.Featuring:Chelsea Linder – LinkedIn Daniel Whitenack – Website, GitHub, XLinks: TechpointSponsors:Shopify – The commerce platform trusted by millions. From idea to checkout, Shopify gives you everything you need to launch and scale your business—no matter your level of experience. Build beautiful storefronts, market with built-in AI tools, and tap into the platform powering 10% of all U.S. eCommerce. Start your one-dollar trial at shopify.com/practicalaiFabi.ai - The all-in-one data analysis platform for modern teams. From ad hoc queries to advanced analytics, Fabi lets you explore data wherever it lives—spreadsheets, Postgres, Snowflake, Airtable and more. Built-in Python and AI assistance help you move fast, then publish interactive dashboards or automate insights delivered straight to Slack, email, spreadsheets or wherever you need to share it.Learn more and get started for free at fabi.aiUpcoming Events: Join us at the Midwest AI Summit on November 13 in Indianapolis to hear world-class speakers share how they've scaled AI solutions. Don't miss the AI Engineering Lounge, where you can sit down with experts for hands-on guidance. Reserve your spot today!Register for upcoming webinars here!

Postgres 18 has been released with many exciting features such as UUIDv7, Over explain module, composite index skip scans, and the most anticipated asynchronous IO with worker and io_uring mode which I uncover in this show. Hope you enjoy it0:00 Intro1:30 Synchronous vs Asynchronous calls3:00 Synchronous IO6:30 Asynchronous IO10:00 Postgres 17 synchronous io 17:20 The challenge of Async IO in Postgres 1820:00 io_method worker23:00 io_method io_uring29:30 io_method sync 31:08 Async IO isn't done! 31:30 Support for backend writers32:36 Improve worker io_method33:00 direct io support 37:00 Summary

Nik and Michael discuss user management in Postgres — how roles work, making administration easier, setting passwords, and avoiding them being logged. Here are some links to things they mentioned:Roles https://www.postgresql.org/docs/current/user-manag.html Privileges https://www.postgresql.org/docs/current/ddl-priv.htmlALTER DEFAULT PRIVILEGES https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.htmlGRANT https://www.postgresql.org/docs/current/sql-grant.htmlREASSIGN OWNED https://www.postgresql.org/docs/current/sql-reassign-owned.htmlALTER ROLE (including SET) https://www.postgresql.org/docs/current/sql-alterrole.html CREATE ROLE https://www.postgresql.org/docs/current/sql-createrole.htmlHave I Been Pwned https://haveibeenpwned.comPwned Passwords API https://haveibeenpwned.com/API/v3#PwnedPasswordsCrunchy Data PostgreSQL Security Technical Implementation Guide (STIG) https://www.crunchydata.com/blog/announcing-the-crunchy-data-postgresql-stigOur episode on auditing https://postgres.fm/episodes/auditing~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

F-Droid is going away if Google continues down the path of requiring that developers register their apps through Google. Jellyfin has a big update, and Steve joins the program from Texas and shares about what he's doing there. -- During The Show -- 00:52 Intro Steve remote from Texas Talking to a someone in the same space Advantage of Face to Face 08:15 Operese Windows 11 requires certain hardware Microsoft will play games with Windows 10 updates Windows to Linux migration tool Use case Codeberg (https://codeberg.org/Operese/operese) YouTube (https://www.youtube.com/watch?v=4YUkD5oslmc) Nixbook (https://github.com/mkellyxp/nixbook) vs EndlessOS Immutable Distros Alloy (https://grafana.com/docs/alloy/latest/) Tailscale 21:50 News Wire GNU Coreutils 9.8 - gnu.org (https://www.gnu.org/software/coreutils/manual/coreutils.html) Postgres 18 - postgresql.org (https://www.postgresql.org/about/news/postgresql-18-released-3142) GROOT Robot Model - yahoo.com (https://finance.yahoo.com/news/nvidia-launches-open-source-physics-183426533.html) OBS Studio 32.0 - github.com (https://github.com/obsproject/obs-studio/releases) RPM 6.0 - rpm.org (https://rpm.org/releases/6.0.0) Linux 6.17 - phoronix.com (https://www.phoronix.com/news/Linux-6.17-Released) Kaosx 2025.09 - kaosx.us (https://kaosx.us/news/2025/kaos09) Kali Linux 2025.3 - kali.org (https://www.kali.org/blog/kali-linux-2025-3-release) NeptuneOS 9.0 - neptuneos.com (https://neptuneos.com/en/news-reader/neptuneos-9-0-maja-released.html) MemVerge AI Memory Layer - blocksandfiles.com (https://blocksandfiles.com/2025/09/24/memverges-ambitious-long-context-ai-memmachine-memory) Song-Prep - huggingface.co (https://huggingface.co/tencent/SongPrep-7B) 1T Parameter Model - huggingface.co (https://huggingface.co/inclusionAI/Ring-1T-preview) CISA Sudo Vulnerability - thehackernews.com (https://thehackernews.com/2025/09/cisa-sounds-alarm-on-critical-sudo-flaw.html) 23:05 F-Droid and Developer Registration F-Droid's stance Principles and Trust Model Older phones Google decides what can run on your phone Forcing phone use Alternative Options People clinging to proprietary solutions Historic cycle of open-closed-open F-Droid Post (https://f-droid.org/en/2025/09/29/google-developer-registration-decree.html) The Register (https://www.theregister.com/2025/09/29/googles_dev_registration_plan_will/?td=rt-3a) 43:49 Jellyfin EFCore Migration RCs are up PLEASE TEST! Database migration completed DO NOT INTERRUPT on first boot Some plugins will need time to upgrade 32bit ARM deprecated Kodi as a front end to Jellyfin Pinchflat (https://github.com/kieraneglin/pinchflat) Jellyfin Hedgedoc (https://notes.jellyfin.org/v10.11.0_features#) -- The Extra Credit Section -- For links to the articles and material referenced in this week's episode check out this week's page from our podcast dashboard! This Episode's Podcast Dashboard (http://podcast.asknoahshow.com/461) Phone Systems for Ask Noah provided by Voxtelesys (http://www.voxtelesys.com/asknoah) Join us in our dedicated chatroom #GeekLab:linuxdelta.com on Matrix (https://element.linuxdelta.com/#/room/#geeklab:linuxdelta.com) -- Stay In Touch -- Find all the resources for this show on the Ask Noah Dashboard Ask Noah Dashboard (http://www.asknoahshow.com) Need more help than a radio show can offer? Altispeed provides commercial IT services and they're excited to offer you a great deal for listening to the Ask Noah Show. Call today and ask about the discount for listeners of the Ask Noah Show! Altispeed Technologies (http://www.altispeed.com/) Contact Noah live [at] asknoahshow.com -- Twitter -- Noah - Kernellinux (https://twitter.com/kernellinux) Ask Noah Show (https://twitter.com/asknoahshow) Altispeed Technologies (https://twitter.com/altispeed)

Welcome to First Block, a Notion series where founders from the world's leading companies tell us what it was like to navigate the many firsts of their startup journey—and what they learned from that experience.In this episode, we spoke with Ant Wilson, Co-Founder and CTO of Supabase. Supabase is the Postgres development platform that has become one of the world's fastest growing open source communities.Ant shares his journey about previous founder experiences, the power of solving your own problem, and why building authentic relationships with your community matters.Chapters:00:00 Intro02:56 Supabase Explained07:04 The Positioning Shift09:25 Memes & Marketing13:08 Scaling the Community15:09 Winning Enterprises17:09 Remote-First Culture22:49 AI in Action26:10 Advice BlockFor video, transcripts, and custom Notion Mercor templates, please visit: https://ntn.so/aow225To learn more about how Notion is supporting startups, please visit: ⁠https://ntn.so/cwep6x

Nik and Michael discuss the newly released Postgres 18 — the bigger things it includes, some of their personal highlights, and some thoughts towards the future. Here are some links to things they mentioned:Postgres 18 announcement https://www.postgresql.org/about/news/postgresql-18-released-3142Postgres 18 release notes https://www.postgresql.org/docs/18/release-18.htmlSkip scan episode with Peter Geoghegan https://postgres.fm/episodes/skip-scanEasier Postgres fine-tuning with online_advisor https://neon.com/blog/easier-postgres-fine-tuning-with-online_advisorpganalyze Index Advisor https://pganalyze.com/index-advisorBUFFERS by default https://postgres.fm/episodes/buffers-by-defaultBuffers II (the sequel) https://postgres.fm/episodes/buffers-ii-the-sequelReturn of the BUFFERS https://postgres.fm/episodes/return-of-the-buffersUUID https://postgres.fm/episodes/uuidPartitioning by ULID https://postgres.fm/episodes/partitioning-by-uliduuidv7 and uuid_extract_timestamp functions https://www.postgresql.org/docs/current/functions-uuid.htmlAdd --no-policies option to pg_dump, pg_dumpall, and pg_restore https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=cd3c45125Add ONLY support for VACUUM and ANALYZE https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=62ddf7ee9Make "vacuumdb --analyze-only" process partitioned tables (committed recently for Postgres 19) https://commitfest.postgresql.org/patch/5871/NOT VALID constraints https://postgres.fm/episodes/not-valid-constraintsThe year of the Lock Manager's Revenge (post by Jeremy Schneider) https://ardentperf.com/2024/03/03/postgres-indexes-partitioning-and-lwlocklockmanager-scalabilityIncrease the number of fast-path lock slots https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c4d5cb71d"enable" parameters will work differently in Postgres 18 https://www.pgmustard.com/blog/enable-parameters-work-differently-in-postgres-18logerrors https://github.com/munakoiso/logerrors~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

Nik and Michael are joined by Harry Brundage from Gadget to talk about their recent zero-downtime major version upgrade, how they use Postgres more generally, their dream database, and some challenges of providing Postgres as an abstracted service at scale. Here are some links to things they mentioned:Harry Brundage https://postgres.fm/people/harry-brundageGadget https://gadget.devZero downtime Postgres upgrades using logical replication (blog post) https://gadget.dev/blog/zero-downtime-postgres-upgrades-using-logical-replicationHOT updates https://www.postgresql.org/docs/current/storage-hot.htmlPgDog https://pgdog.devMultigres https://multigres.comNeki https://www.neki.devRunning 10 Million PostgreSQL Indexes In Production (Heap blog post) https://www.heap.io/blog/running-10-million-postgresql-indexes-in-productionpgwatch2 (Postgres.ai Edition) https://gitlab.com/postgres-ai/pgwatch2Advanced query insights on AlloyDB https://cloud.google.com/alloydb/docs/advanced-query-insights-overviewOrioleDB https://www.orioledb.comNot discussed but relevant: Gadget have also now published a blog post about their sharding! https://gadget.dev/blog/sharding-our-core-postgres-database-without-any-downtime~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

Six years, a prototype, and a brief multi-layered descent into “wronger and wronger” design—what does it take to land a major architectural change in Postgres? In Episode 31 of Talking Postgres, Andres Freund—major contributor, Postgres committer, and lead of the Asynchronous I/O project—shares the wins, the missteps, and why he thinks AIO definitely took too long. We dig into io_uring in Linux, direct I/O, streaming reads, technical leadership, and exactly when is the right time to stop working on a prototype. If you've ever wondered how big architectural changes happen, or why they sometimes take years, this episode is for you. Links mentioned in this episode:Talking Postgres podcast: How I got started as a developer (& in Postgres) with Andres Freund & Heikki LinnakangasRelease Notes: PostgreSQL 18 release notes News: PostgreSQL RC 1 Released on Sep 04 2025Wikipedia page: io_uringPostgreSQL: Join the PostgreSQL Hacking DiscordVideo of talk: What went wrong with AIO by Andres Freund at PGConfdev 2025Commit: Add core asynchronous I/O infrastructure to PostgreSQLWiki page: AIO project in PostgreSQL with state, sub-projects, and work still to be doneUpcoming Talk: AIO in PG 18 and Beyond at PGConf NYC on 30 Sep 2025Upcoming Talk: AIO in PG 18 and Beyond at PGConf EU on 23 Oct 2025Wikipedia page: XZ Utils backdoor discovery by Andres FreundCal invite: LIVE recording of Ep32 of Talking Postgres to happen on Wed Oct 8, 2025

Modernizing Search Infrastructure: How Instacart Transitioned from Elasticsearch to PostgreSQL for Enhanced Performance and Simplicity. In this episode of The Data Engineering Show, host Benjamin Wagner speaks with Ankit Mittal, former senior engineer at Instacart, about the company's innovative approach to modernizing their search infrastructure by transitioning from Elasticsearch to PostgreSQL for single-retailer search functionality.

Ian and Aaron talk about adventures with TypeScript, huge updates re: Outro & Database School, and revisit exactly what happened with Once.com.Sponsored by: Bento, Bifrost for NativePHP, and HoneybadgerInterested in sponsoring Mostly Technical?  Head to https://mostlytechnical.com/sponsor to learn more.(00:00) - Follow Up (04:44) - Adventures With TypeScript (12:56) - Introduction to Postgres (15:11) - Getaway (18:31) - Update on Outro (31:08) - Precipice of a Mistake (38:51) - Railsworld Recap (50:17) - RIP Once.com (01:05:02) - This One's For The Girls Links:Jason Beggs on TwitterReka UIFocus LabRails WorldBourne FranchiseCampfireFizzy WalkthroughThis One's for the Girls

This is a recap of the top 10 posts on Hacker News on September 12, 2025. This podcast was generated by wondercraft.ai (00:30): EU court rules nuclear energy is clean energyOriginal post: https://news.ycombinator.com/item?id=45224967&utm_source=wondercraft_ai(01:54): The treasury is expanding the Patriot Act to attack Bitcoin self custodyOriginal post: https://news.ycombinator.com/item?id=45221274&utm_source=wondercraft_ai(03:18): Qwen3-NextOriginal post: https://news.ycombinator.com/item?id=45219228&utm_source=wondercraft_ai(04:42): Many hard LeetCode problems are easy constraint problemsOriginal post: https://news.ycombinator.com/item?id=45222695&utm_source=wondercraft_ai(06:06): Corporations are trying to hide job openings from US citizensOriginal post: https://news.ycombinator.com/item?id=45223719&utm_source=wondercraft_ai(07:30): UTF-8 is a brilliant designOriginal post: https://news.ycombinator.com/item?id=45225098&utm_source=wondercraft_ai(08:54): Float ExposedOriginal post: https://news.ycombinator.com/item?id=45217415&utm_source=wondercraft_ai(10:18): Chat Control faces blocking minority in the EUOriginal post: https://news.ycombinator.com/item?id=45221580&utm_source=wondercraft_ai(11:42): QGIS is a free, open-source, cross platform geographical information systemOriginal post: https://news.ycombinator.com/item?id=45224156&utm_source=wondercraft_ai(13:06): Debian 13, Postgres, and the US time zonesOriginal post: https://news.ycombinator.com/item?id=45218111&utm_source=wondercraft_aiThis is a third-party project, independent from HN and YC. Text and audio generated using AI, by wondercraft.ai. Create your own studio quality podcast with text as the only input in seconds at app.wondercraft.ai. Issues or feedback? We'd love to hear from you: team@wondercraft.ai

Nik and Michael are joined by Simon Eskildsen from turbopuffer — among other things, they discuss ANN index types, tradeoffs that can make sense for search workloads, and when it can make sense to move search out of Postgres. Here are some links to things they mentioned:Simon Eskildsen https://postgres.fm/people/simon-eskildsenturbopuffer https://turbopuffer.comUse ULID Idempotency Keys (tip 6 in this blog post from Shopify) https://shopify.engineering/building-resilient-payment-systemsPostgreSQL 18 Release Candidate 1 https://www.postgresql.org/about/news/postgresql-18-rc-1-released-3130Understanding DiskANN (blog post by Junaid Ahmed) https://www.tigerdata.com/blog/understanding-diskannSPFresh: Incremental In-Place Update for Billion-Scale Vector Search (paper) https://arxiv.org/abs/2410.14452Amazon S3 adds new functionality for conditional writes https://aws.amazon.com/about-aws/whats-new/2024/11/amazon-s3-functionality-conditional-writesAmazon S3 Vectors https://aws.amazon.com/s3/features/vectors~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

Nik and Michael discuss when not to use Postgres — specifically use cases where it still makes sense to store data in another system. Here are some links to things they mentioned:Just use Postgres (blog post by Ethan McCue) https://mccue.dev/pages/8-16-24-just-use-postgresJust Use Postgres for Everything (blog post by Stephan Schmidt) https://www.amazingcto.com/postgres-for-everythingReal-time analytics episode https://postgres.fm/episodes/real-time-analyticsCrunchy Data Joins Snowflake https://www.crunchydata.com/blog/crunchy-data-joins-snowflakeTwo sizes fit most: PostgreSQL and Clickhouse (blog post by Sid Sijbrandij) https://about.gitlab.com/blog/two-sizes-fit-most-postgresql-and-clickhousepg_duckdb episode https://postgres.fm/episodes/pg_duckdbCloudberry https://github.com/apache/cloudberryTime-series considerations episode https://postgres.fm/episodes/time-series-considerationsQueues in Postgres episode https://postgres.fm/episodes/queues-in-postgresLarge Objects https://www.postgresql.org/docs/current/largeobjects.html PGlite https://pglite.devParadeDB https://www.paradedb.comZomboDB https://github.com/zombodb/zombodbturbopuffer https://turbopuffer.comHNSW vs. DiskANN (blog post by Haziqa Sajid) https://www.tigerdata.com/learn/hnsw-vs-diskannSPANN: Highly-efficient Billion-scale Approximate Nearest Neighbor Search (paper) https://www.microsoft.com/en-us/research/wp-content/uploads/2021/11/SPANN_finalversion1.pdfAmazon S3 Vectors https://aws.amazon.com/s3/features/vectorsIterative Index Scans added to pgvector in 0.8.0 https://github.com/pgvector/pgvector/issues/678S3 FDW from Supabase https://github.com/supabase/wrappers/tree/main/wrappers/src/fdw/s3_fdw~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

Nik and Michael discuss disks in relation to Postgres — why they matter, how saturation can happen, some modern nuances, and how to prepare to avoid issues. Here are some links to things they mentioned:Nik's tweet demonstrating a NOTIFY hot spot https://x.com/samokhvalov/status/1959468091035009245Postgres LISTEN/NOTIFY does not scale (blog post by Recall ai) https://www.recall.ai/blog/postgres-listen-notify-does-not-scaletrack_io_timing https://www.postgresql.org/docs/current/runtime-config-statistics.html#GUC-TRACK-IO-TIMINGpg_test_timing https://www.postgresql.org/docs/current/pgtesttiming.html PlanetScale for Postgres https://planetscale.com/blog/planetscale-for-postgresOut of disk episode https://postgres.fm/episodes/out-of-disk100TB episode https://postgres.fm/episodes/to-100tb-and-beyond Latency Numbers Every Programmer Should Know https://gist.github.com/jboner/2841832Fio https://github.com/axboe/fio~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

Nik and Michael discuss multi-column indexes in Postgres — what they are, how to think about them, and some guidance around using them effectively. Here are some links to things they mentioned:Multicolumn Indexes (docs) https://www.postgresql.org/docs/current/indexes-multicolumn.htmlOur episode on Index-only scans https://postgres.fm/episodes/index-only-scansCombining Multiple Indexes (docs) https://www.postgresql.org/docs/current/indexes-bitmap-scans.htmlEnable BUFFERS with EXPLAIN ANALYZE by default https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c2a4078ebad71999dd451ae7d4358be3c9290b07“PostgreSQL includes an implementation of the standard btree […] The only limitation is that an index entry cannot exceed approximately one-third of a page” https://www.postgresql.org/docs/current/btree.htmlOur episode on HOT updates https://postgres.fm/episodes/hot-updatesOur episode on LIMIT vs Performance https://postgres.fm/episodes/limit-vs-performance~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

How would you build a Heroku-like platform from scratch? This week we're diving deep into the world of cloud platforms and infrastructure with Anurag Goel, founder and CEO of Render.Starting from the seemingly simple task of hosting a web service, we quickly discover why building a production-ready platform is far more complex than it appears. Why is hosting a Postgres database so challenging? How do you handle millions of users asking for thousands of different features? And what's the secret to building infrastructure that developers actually want to use?We explore the technical challenges of building enterprise-grade services—from implementing reliable backups and high availability to managing private networking and service discovery. Anurag shares insights on choosing between infrastructure-as-code versus configuration, why they built on Go, and how they handle 100 billion requests per month.Plus, we discuss the impact of AI on platform adoption: Are LLMs already influencing which platforms developers choose? Will hosting platforms need to actively support agentic workflows? And what does the future hold for automated debugging?Whether you're curious about building your own platform, want to understand what really happens behind your cloud provider's dashboard, or just enjoy hearing war stories from the infrastructure trenches, this episode has something for you.–Support Developer Voices on Patreon: https://patreon.com/DeveloperVoicesSupport Developer Voices on YouTube: https://www.youtube.com/@DeveloperVoices/joinRender: https://render.com/Render's MCP Server (Early Access): https://render.com/docs/mcp-serverPulumi: https://www.pulumi.com/Victoria Metrics: https://victoriametrics.comLoki: https://vector.dev/docs/reference/configuration/sinks/loki/Vector: https://vector.dev/Kris on Bluesky: https://bsky.app/profile/krisajenkins.bsky.socialKris on Mastodon: http://mastodon.social/@krisajenkinsKris on LinkedIn: https://www.linkedin.com/in/krisjenkins/

Alex & Chris get into a fairly recent technological change at CodePen where we ditched our Elasticsearch implementation for just using our own Postgres database for search. Sometimes choices like this are more about team expertise, dev environment practicalities, and complexity tradeoffs. We found this change to be much better for us, which matters! For the most part search is better and faster. Postgres is not nearly as fancy and capable as Elasticsearch, but we werent taking advantage of what Elasticsearch had to offer anyway. For the power users out there: it's true that we've lost the ability to do in-code search for now. But it's temporary and will be coming back in time. Time Jumps

Nikolay and Michael discuss self-driving Postgres — what it could mean, using self-driving cars as a reference, and ideas for things to build and optimize for in this area. Here are some links to things they mentioned:Nikolay's blog post on Self-driving Postgres https://postgres.ai/blog/20250725-self-driving-postgresSAE J3016 levels of driving automation https://www.sae.org/news/2019/01/sae-updates-j3016-automated-driving-graphicOracle Autonomous Database https://www.oracle.com/uk/autonomous-database/Self-Driving Database Management Systems (2017 paper) https://db.cs.cmu.edu/papers/2017/p42-pavlo-cidr17.pdfPGTune https://pgtune.leopard.in.ua/pg_index_pilot https://gitlab.com/postgres-ai/pg_index_pilot/[Vibe] Hacking Postgres with Andrey, Kirk, Nik – index bloat, btree page merge https://www.youtube.com/watch?v=D1PEdDcvZTw~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

In this episode, Chris and Andrew discuss the recent release of Rails 8 and the improvements in upgrading processes compared to previous versions. They dive into specific technical challenges, such as handling open redirects and integrating configuration options, and chat about Chris's recent experience with Tailwind's new Elements library, Bundler updates, and JSON gem changes.  They also touch on Heroku's evolving infrastructure and the potential benefits of using PlanetScale's new Postgres offerings. The episode concludes with a discussion about life without internet and Andrew's countdown to his upcoming sabbatical.  Hit download now! LinksJudoscale- Remote Ruby listener giftRails World 2025Tailwind Plus- ElementsInvoker Commands APIByroot's Blog post-What's wrong with JSON gem API?PlanetScaleHetznerHoneybadgerHoneybadger is an application health monitoring tool built by developers for developers.JudoscaleMake your deployments bulletproof with autoscaling that just works.Disclaimer: This post contains affiliate links. If you make a purchase, I may receive a commission at no extra cost to you. Chris Oliver X/Twitter Andrew Mason X/Twitter Jason Charnes X/Twitter

Why do Postgres developers, contributors, and users do what they do? In each episode of Talking Postgres, Claire Giordano talks to people from across the Postgres ecosystem—how they got started, what they've learned, and what they're still figuring out. This 3-minute trailer offers a fast-paced glimpse into the fun, surprising, and deeply human stories behind Postgres, including failures, wins, obstacles—and all the messy parts in between. New episodes monthly. Always on Fridays. Subscribe wherever you get your podcasts.Episodes from Talking Postgres with guests featured in the trailer (in order of appearance): Episode 01: Working in public on open source with Simon Willison and Marco SlotEpisode 18: How I got started as a developer (& in Postgres) with David RowleyEpisode 20: How I got started as a developer (& in Postgres) with Tom LaneEpisode 07: Why people care about PostGIS and Postgres with Paul Ramsey & Regina ObeEpisode 29: How I got started leading database teams with Shireesh ThotaEpisode 25: Why Python developers just use Postgres with Dawn WagesEpisode 19: Becoming a Postgres committer with Melanie PlagemanEpisode 24: Why mentor Postgres developers with Robert HaasEpisode 04: How I got started as a dev (& in Postgres) w/Melanie Plageman & Thomas Munro

Qian Li of DBOS, a durable execution platform born from research by the creators of Postgres and Spark, speaks with host Kanchan Shringi about building durable, observable, and scalable software systems, and why that matters for modern applications. They discuss database-backed program state, workflow orchestration, real-world AI use cases, and comparisons with other workflow technologies. Li explains how DBOS persists not just application data but also program execution state in Postgres to enable automatic recovery and exactly-once execution. She outlines how DBOS uses workflow and step annotations to build deterministic, fault-tolerant flows for everything from e-commerce checkouts to LLM-powered agents. Observability features, including SQL-accessible state tables and a time-travel debugger, allow developers and business users to understand and troubleshoot system behavior. Finally, she compares DBOS with tools like Temporal and AWS Step Functions. Brought to you by IEEE Computer Society and IEEE Software magazine.

Nikolay and Michael discuss case-insensitive data — when we want to treat columns as case-insensitive, and the pros and cons of using citext, functions like lower(), or a custom collation. Here are some links to things they mentioned:citext https://www.postgresql.org/docs/current/citext.htmlOur episode on over-indexing https://postgres.fm/episodes/over-indexingNondeterministic collations https://www.postgresql.org/docs/current/collation.html#COLLATION-NONDETERMINISTICHow to migrate from Django's PostgreSQL CI Fields to use a case-insensitive collation (blog post by Adam Johnson) https://adamj.eu/tech/2023/02/23/migrate-django-postgresql-ci-fields-case-insensitive-collationThe collation versioning problem with ICU 73 (blog post by Daniel Vérité) https://postgresql.verite.pro/blog/2023/10/20/icu-73-versioning.htmlamcheck https://www.postgresql.org/docs/current/amcheck.html~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

It's always a good day if you see a pelican. In Episode 30 of Talking Postgres with Claire Giordano, open source developer Simon Willison—creator of Datasette and co-creator of Django—joins to explore how AI is useful for data engineers today. We move past the hype and boosterism to dig into example after example: structured data extraction, alt text and accessibility, safety and security (aka the fiddly bits), and why Postgres's fine-grained permissions are such a good fit for AI-powered workflows. Also: Pulitzer-worthy data tooling, the science fiction of the 10X engineer, agents, MCP, RAG, the multitude of models, and why Simon spends so many waking hours on the jagged frontier of AI.Links mentioned in this episode:Blog: Simon Willison's WeblogBlog: Simon's Willison's TIL - Things I've LearnedPodcast episode: Working in public on open source with Simon Willison and Marco SlotProject page: Django Web FrameworkProject page: Datasette, for finding stories in data GitHub repo: llm CLI tool and Python libraryDemo: Language models on the command-line w/ Simon WillisonBlog post: OpenAI's new open weight (Apache 2) models are really good, by Simon Willison Podcast episode: Accessibility and Gen AI podcast with guest Simon WillisonBlog post: New dashboard: alt text for all my images, by Simon Willison Keynote talk: Big Opportunities in Small Data, by Simon Willison at Citus Con: An Event for Postgres 2023 Blog post: How OpenElections Uses LLMs, by Derek Willis Blog posts tagged with pelican-riding-a-bicycle on Simon Willison's Weblog Blog post: No, AI is not Making Engineers 10x as Productive, via Colton Voege, featured on Simon's weblogGitHub repo: pgvector extension to PostgresCal invite: LIVE recording of Ep31 of Talking Postgres to happen on Wed Sep 17, 2025

Nikolay talks to Michael about Postgres AI's new monitoring tool — what it is, how its different to other tools, and some of the thinking behind it. Here are some links to things they mentioned:postgres_ai monitoring https://gitlab.com/postgres-ai/postgres_aiDB Lab 4.0 announcement https://github.com/postgres-ai/database-lab-engine/releases/tag/v4.0.0pganalyze https://pganalyze.compostgres-checkup https://gitlab.com/postgres-ai/postgres-checkupPercona Monitoring and Management (PMM) https://github.com/percona/pmmpgwatch https://github.com/cybertec-postgresql/pgwatchpgwatch Postgres AI Edition https://gitlab.com/postgres-ai/pgwatch2libpg_query https://github.com/pganalyze/libpg_queryThe Four Golden Signals https://sre.google/sre-book/monitoring-distributed-systems/#xref_monitoring_golden-signalslogerrors https://github.com/munakoiso/logerrors~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

Sugu Sougoumarane, creator of Vitess, comes off sabbatical to bring Vitess to Postgres. We discuss what motivated Sugu to come off sabbatical, why now is the time, the technical challenges of doing so, the implementation details of Multigres (Vitess for Postgres). We also discuss the state of Postgres at scale.

News includes Phoenix 1.8.0-rc.4 and LiveView 1.1.0-rc.3 with igniter upgrader support, new libraries including deps_changelog and the Hog process debugging tool by Alex Koutmos, Fly.io's announcement of managed Postgres, an incredible conference talk about Waterpark - a healthcare system built on the BEAM that achieved 100% uptime for 5 years and running, tips on using Elixir compiler directives for function inlining, the full ElixirConf US 2025 schedule with keynotes from José Valim and Chris McCord, CodeBeam Europe speaker announcements, and more! Show Notes online - http://podcast.thinkingelixir.com/262 (http://podcast.thinkingelixir.com/262) Elixir Community News https://paraxial.io/ (https://paraxial.io/utm_source=thinkingelixir&utm_campaign=thinkingelixir-july2025) – Paraxial.io is sponsoring today's show! Sign up for a free trial of Paraxial.io today and mention Thinking Elixir when you schedule a demo for a special offer. https://bsky.app/profile/steffend.me/post/3ltz36vf4ts2u (https://bsky.app/profile/steffend.me/post/3ltz36vf4ts2u?utm_source=thinkingelixir&utm_medium=shownotes) – Phoenix 1.8.0-rc.4 and LiveView 1.1.0-rc.3 released with igniter upgrader for LiveView 1.0 users https://tomkonidas.com/repo-transact/ (https://tomkonidas.com/repo-transact/?utm_source=thinkingelixir&utm_medium=shownotes) – New Ecto 3.13 Repo.transact/2 used in generators Added security.md guide for security best practices and fetch() support for LongPoll in Service Workers https://github.com/serpent213/deps_changelog (https://github.com/serpent213/deps_changelog?utm_source=thinkingelixir&utm_medium=shownotes) – New library called deps_changelog that finds additions to dependency CHANGELOG files upon update https://x.com/akoutmos/status/1935463503164309611 (https://x.com/akoutmos/status/1935463503164309611?utm_source=thinkingelixir&utm_medium=shownotes) – Alex Koutmos announces new Elixir process debugging library called "Hog" https://github.com/akoutmos/hog (https://github.com/akoutmos/hog?utm_source=thinkingelixir&utm_medium=shownotes) – Hog library used to pinpoint and deal with memory hungry processes, helps track down OOM issues https://bsky.app/profile/fly.io/post/3ltlmmz4hq72n (https://bsky.app/profile/fly.io/post/3ltlmmz4hq72n?utm_source=thinkingelixir&utm_medium=shownotes) – Fly.io announces managed Postgres with automatic backups, failover, and monitoring https://www.youtube.com/watch?v=hdBm4K-vvt0 (https://www.youtube.com/watch?v=hdBm4K-vvt0?utm_source=thinkingelixir&utm_medium=shownotes) – Waterpark conference talk - Transforming Healthcare with Distributed Actors achieving 100% uptime for 5 years https://x.com/sasajuric/status/1943601894141640808 (https://x.com/sasajuric/status/1943601894141640808?utm_source=thinkingelixir&utm_medium=shownotes) – Saša Jurić shares about the Waterpark talk https://curiosum.com/blog/interacting-with-google-sheets-in-elixir (https://curiosum.com/blog/interacting-with-google-sheets-in-elixir?utm_source=thinkingelixir&utm_medium=shownotes) – In-depth article about using Elixir and Phoenix to pull data from Google Spreadsheet https://x.com/jskalc/status/1945092835067211929 (https://x.com/jskalc/status/1945092835067211929?utm_source=thinkingelixir&utm_medium=shownotes) – Fun tip about Elixir compiler directive to inline functions for performance https://bsky.app/profile/elixirconf.bsky.social/post/3ltjyeeamwi2s (https://bsky.app/profile/elixirconf.bsky.social/post/3ltjyeeamwi2s?utm_source=thinkingelixir&utm_medium=shownotes) – ElixirConf US 2025 full schedule published https://elixirconf.com/#keynotes (https://elixirconf.com/#keynotes?utm_source=thinkingelixir&utm_medium=shownotes) – ElixirConf keynotes featuring José Valim, Chris McCord, and others https://ti.to/elixirconf/2025/discount/ThinkingElixir (https://ti.to/elixirconf/2025/discount/ThinkingElixir?utm_source=thinkingelixir&utm_medium=shownotes) – Get ElixirConf 2025 tickets with "ThinkingElixir" discount code for 10% off https://codebeameurope.com (https://codebeameurope.com?utm_source=thinkingelixir&utm_medium=shownotes) – CodeBeam Europe speaker list is up for November 5-6 in Berlin and Online Do you have some Elixir news to share? Tell us at @ThinkingElixir (https://twitter.com/ThinkingElixir) or email at show@thinkingelixir.com (mailto:show@thinkingelixir.com) Find us online - Message the show - Bluesky (https://bsky.app/profile/thinkingelixir.com) - Message the show - X (https://x.com/ThinkingElixir) - Message the show on Fediverse - @ThinkingElixir@genserver.social (https://genserver.social/ThinkingElixir) - Email the show - show@thinkingelixir.com (mailto:show@thinkingelixir.com) - Mark Ericksen on X - @brainlid (https://x.com/brainlid) - Mark Ericksen on Bluesky - @brainlid.bsky.social (https://bsky.app/profile/brainlid.bsky.social) - Mark Ericksen on Fediverse - @brainlid@genserver.social (https://genserver.social/brainlid) - David Bernheisel on Bluesky - @david.bernheisel.com (https://bsky.app/profile/david.bernheisel.com) - David Bernheisel on Fediverse - @dbern@genserver.social (https://genserver.social/dbern)

Reliable software shouldn't be an accident, but for most developers it is. Jeremy Edberg, CEO of DBOS and the guy who scaled Reddit and Netflix, joins Corey Quinn to talk about his wild idea of saving your entire app into a database so it can never really break. They chat about Jeremy's "build for three" rule, a plan for scale without going crazy, why he set Reddit's servers to Arizona time to dodge daylight saving time, and how DBOS makes your app as tough as your data. Plus, Jeremy shares his brutally honest take on distributed systems cargo cult, autonomous AI testing, and why making it easy for customers to leave actually keeps them around.Public Bio: Jeremy is an angel investor and advisor for various incubators and startups, and the CEO of DBOS. He was the founding Reliability Engineer for Netflix and before that he ran ops for reddit as its first engineering hire. Jeremy also tech-edited the highly acclaimed AWS for Dummies, and he is one of the six original AWS Heroes. He is a noted speaker in serverless computing, distributed computing, availability, rapid scaling, and cloud computing, and holds a Cognitive Science degree from UC Berkeley.Show Highlights(02:08) - What DBOS actually does(04:08) - "Everything as a database" philosophy and why it works(08:26) - "95% of people will never outgrow one Postgres machine"(10:13) - Jeremy's Arizona time zone hack at Reddit (and whether it still exists)(11:22) - "Build for three" philosophy without over-engineering(17:16) - Extracting data from mainframes older than the founders(19:00) - Autonomous testing with AI trained on your app's history(20:07) - The hardest part of dev tools(22:00) - Corey's brutal pricing page audit methodology(27:15) - Why making it easy to leave keeps customers around(34:11) - Learn more about DBOSLinksDBOS website: https://dbos.devDBOS documentation: https://docs.dbos.devDBOS GitHub: https://github.com/dbos-incDBOS Discord community: https://discord.gg/fMqo9kDJeremy Edberg on Twitter: https://x.com/jedberg?lang=enAWS Heroes program: https://aws.amazon.com/developer/community/heroes/

Justin Searls describes the "full-breadth developer" and why they'll win because AI, Cloudflare comes up with a way publishers can charge crawlers for access, Hugo Bowne-Anderson explains why building AI agents fails so often, the Job Worth Calculator tells you if your job is worth the grind, and Sam Lambert announces PlanetScale for Postgres.