216: Ecto Soft Deletions Masterclass
Thinking Elixir Podcast
Implementing Soft Deletes in PostgreSQL
This chapter explores the technique of soft deletes in PostgreSQL, explaining how to modify delete operations to preserve data integrity. It discusses the complexities and best practices associated with implementing soft deletes, including handling cascading deletes and using Ecto for flexible querying.
00:00
Transcript
Play full episode
Transcript
Episode notes
News includes a new video from José Valim demonstrating Livebook deployments, Chris McCord's "Pawsitively" project integrating content moderation with Livebook, the release of Zigler 0.13.1, a new AI-centric library called Honeycomb by Sean Moriarity and Andrés Alejos, an Elixir job listing at Apple, and more!
Show Notes online - http://podcast.thinkingelixir.com/216
Elixir Community News
- https://www.youtube.com/watch?v=lwLx5beXxsg – How to deploy a Livebook app with Livebook Teams.
- https://livebook.dev/teams/ – Link to Livebook Teams homepage.
- https://docs.google.com/forms/d/e/1FAIpQLScDfvUqT4f_s95dqNGyoXwVMD_Vl059jT6r5MPgXB99XVMCuw/viewform – Request to join the free Livebook Teams beta.
- https://x.com/chris_mccord/status/1821586189364994202 – Chris McCord shared a demo project called "Pawsitively" which implements a content moderation system.
- https://gist.github.com/chrismccord/4824237157902ed1c47f825b1f1d9d27 – Gist of the demo which uses Livebook and Mistral LLM for content moderation.
- https://pawsitively.fly.dev/ – Play with the "Pawsitively" demo online.
- The demo defines everything in a Livebook file and covers “Manual Docker Deployment”.
- https://x.com/dnautics/status/1822878889275719795 – Announcement of Zigler 0.13.1.
- https://github.com/E-xyza/zigler – GitHub page for Zigler.
- https://hexdocs.pm/zigler/0.13.1/Zig.html – Zigler 0.13.1 documentation.
- https://ziglang.org/ – Official site for the Zig programming language.
- https://podcast.thinkingelixir.com/83 – Podcast episode discussing Zig and Zigler in depth.
- https://x.com/germsvel/status/1823304992876618032 – German Velasco shows how to use
Macro.to_string/1to convert AST to clearer Elixir code. - https://github.com/elixir-error-tracker/error-tracker/releases/tag/v0.2.0 – Release details for ErrorTracker 0.2.0.
- https://evilmartians.com/chronicles/soft-deletion-with-postgresql-but-with-logic-on-the-database – Blog post about hard and soft deletion with PostgreSQL.
- https://x.com/josevalim/status/1821143821649948822 – José Valim shares a tip on soft deletion with PostgreSQL.
- https://dashbit.co/blog/soft-deletes-with-ecto – Article on implementing soft deletes with Ecto.
- https://github.com/seanmor5/honeycomb – New AI-centric library Honeycomb for fast LLM inference with Elixir and Bumblebee.
- https://x.com/sean_moriarity/status/1820887135291085244 – Sean Moriarity's announcement of Honeycomb library.
- https://x.com/wojtekmach/status/1823339271731683743 – Wojtek Mach explains more about Hex.pm's "Bob" and its future directions.
- https://github.com/erlef/build-and-packaging-wg/issues/80 – Proposal on managing Erlang builds.
- https://x.com/wojtekmach/status/1823374248569626638 – Further updates on Bob and Erlang builds.
- https://jobs.apple.com/en-us/details/200562288/senior-software-engineer-elixir-environmental-systems – The Elixir developer position at Apple.
- https://2024.elixirconf.com/schedule/#schedules – ElixirConf 2024 schedules are posted.
- https://x.com/i/lists/1819858270737268846 – Twitter list of ElixirConf speakers.
- https://2024.elixirconf.com/ – ElixirConf 2024 official website.
- ElixirConf weekly hangouts with speakers at 11am CDT on Twitter. Talks span from August 28-30.
Do you have some Elixir news to share? Tell us at @ThinkingElixir or email at show@thinkingelixir.com
Find us online
- Message the show - @ThinkingElixir
- Message the show on Fediverse - @ThinkingElixir@genserver.social
- Email the show - show@thinkingelixir.com
- Mark Ericksen - @brainlid
- Mark Ericksen on Fediverse - @brainlid@genserver.social
- David Bernheisel - @bernheisel
- David Bernheisel on Fediverse - @dbern@genserver.social
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
