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 Ullr