Listen "278: WAL-ing Through Database Changes"
Episode Synopsis
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 [email protected] (mailto:[email protected])
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 - @[email protected] (https://genserver.social/ThinkingElixir)
- Email the show - [email protected] (mailto:[email protected])
- 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 - @[email protected] (https://genserver.social/brainlid)
- David Bernheisel on Bluesky - @david.bernheisel.com (https://bsky.app/profile/david.bernheisel.com)
- David Bernheisel on Fediverse - @[email protected] (https://genserver.social/dbern)
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 [email protected] (mailto:[email protected])
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 - @[email protected] (https://genserver.social/ThinkingElixir)
- Email the show - [email protected] (mailto:[email protected])
- 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 - @[email protected] (https://genserver.social/brainlid)
- David Bernheisel on Bluesky - @david.bernheisel.com (https://bsky.app/profile/david.bernheisel.com)
- David Bernheisel on Fediverse - @[email protected] (https://genserver.social/dbern)
More episodes of the podcast Thinking Elixir Podcast
283: Erlang Turns 27 and React at Risk
16/12/2025
282: Type Systems and View Transitions
09/12/2025
281: Planning for the Unexpected
02/12/2025
280: Dark Matter Developers
25/11/2025
279: Hot Code Upgrades and Hotter AI Takes
18/11/2025
277: Searching Across the Hexiverse
04/11/2025
276: Elixir v1.19 Types and Speed
28/10/2025
275: From Slop to Success?
21/10/2025
274: Protocols, Permissions, and Performance
14/10/2025
273: Does the Language Really Matter?
07/10/2025
ZARZA We are Zarza, the prestigious firm behind major projects in information technology.