278: WAL-ing Through Database Changes

News includes the Curiosum Elixir survey closing soon, ReqLLM reaching 1.0 with standardized LLM API support across multiple providers, Isaac Yonemoto's Codicil library bringing semantic code understanding to AI assistants through MCP, José Valim teasing Tidewave Web expansion to support Django, Rails, Next.js and other popular frameworks, phoenixtestplaywright adding browser pooling for improved performance, Peter Ullrich's deep dive into using Postgres WAL for database change notifications at scale, and more! Show Notes online - http://podcast.thinkingelixir.com/278 (http://podcast.thinkingelixir.com/278) Elixir Community News https://paraxial.io/ (https://paraxial.io/?utm_source=thinkingelixir&utm_campaign=thinkingelixir-oct2025) – 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://elixir-survey.typeform.com/2025-edition (https://elixir-survey.typeform.com/2025-edition?utm_source=thinkingelixir&utm_medium=shownotes) – Curiosum Elixir survey open until November 14th, 2025 (about 2 days remaining when episode releases) https://elixir-hub.com/surveys (https://elixir-hub.com/surveys?utm_source=thinkingelixir&utm_medium=shownotes) – Where survey results will be published after the survey closes https://nitter.net/mikehostetler/status/1985134169899360709 (https://nitter.net/mikehostetler/status/1985134169899360709?utm_source=thinkingelixir&utm_medium=shownotes) – Announcement tweet about ReqLLM 1.0 release https://agentjido.xyz/blog/announcing-reqllm-10 (https://agentjido.xyz/blog/announcing-req_llm-1_0?utm_source=thinkingelixir&utm_medium=shownotes) – Blog post announcing ReqLLM 1.0, a Req-based package to standardize LLM API calls and responses across providers https://github.com/agentjido/req_llm (https://github.com/agentjido/req_llm?utm_source=thinkingelixir&utm_medium=shownotes) – ReqLLM GitHub repository - went through 8 RCs to reach 1.0, includes Google Vertex AI, AWS Bedrock support, and more https://nitter.net/DNAutics/status/1983278808271663452 (https://nitter.net/DNAutics/status/1983278808271663452?utm_source=thinkingelixir&utm_medium=shownotes) – Isaac Yonemoto's tweet about using an LLM to build an MCP to analyze and service Elixir codebases https://github.com/E-xyza/codicil/ (https://github.com/E-xyza/codicil/?utm_source=thinkingelixir&utm_medium=shownotes) – Codicil - Elixir library providing AI coding assistants with deep semantic understanding of your codebase through the Model Context Protocol Isaac will be speaking about Codicil at ExMex conference (which will have concluded by episode release) https://nitter.net/josevalim/status/1985408862690685315 (https://nitter.net/josevalim/status/1985408862690685315?utm_source=thinkingelixir&utm_medium=shownotes) – José Valim teases upcoming Tidewave Web expansion to support multiple frameworks including Django, FastAPI, Flask, Next.js, Phoenix, Rails, and React + Vite https://github.com/ftes/phoenixtestplaywright (https://github.com/ftes/phoenix_test_playwright?utm_source=thinkingelixir&utm_medium=shownotes) – phoenixtestplaywright library - executes PhoenixTest cases in actual browsers via Playwright https://github.com/ftes/phoenixtestplaywright/blob/main/CHANGELOG.md (https://github.com/ftes/phoenix_test_playwright/blob/main/CHANGELOG.md?utm_source=thinkingelixir&utm_medium=shownotes) – Changelog for versions 0.9.0 and 0.9.1 with expanded click support, drag and drop, and browser pooling for reduced memory and higher speed https://github.com/ftes/phoenixtestplaywright/pull/86 (https://github.com/ftes/phoenix_test_playwright/pull/86?utm_source=thinkingelixir&utm_medium=shownotes) – Pull request implementing browser pooling feature https://hexdocs.pm/phoenix_test (https://hexdocs.pm/phoenix_test?utm_source=thinkingelixir&utm_medium=shownotes) – PhoenixTest documentation https://bsky.app/profile/peterullrich.com/post/3m4qms5kp322y (https://bsky.app/profile/peterullrich.com/post/3m4qms5kp322y?utm_source=thinkingelixir&utm_medium=shownotes) – Peter Ullrich's Bluesky post about listening to database changes through Postgres WAL https://peterullrich.com/listen-to-database-changes-through-the-postgres-wal (https://peterullrich.com/listen-to-database-changes-through-the-postgres-wal?utm_source=thinkingelixir&utm_medium=shownotes) – In-depth blog post about using Postgres Write Ahead Log (WAL) for database change notifications at scale, avoiding pg_notify performance issues https://github.com/superfly/flyrpcelixir (https://github.com/superfly/fly_rpc_elixir?utm_source=thinkingelixir&utm_medium=shownotes) – fly_rpc Elixir library that uses WAL monitoring to track Postgres replication for distributed RPC calls across regions 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)