127: Ecto gets Lively in Livebook

We talked with Spawnfest competitors Filipe Cabaço & Joel Carlbark about their entry “Lively”. Lively was all about doing cool things with Ecto in Livebook. The project, later renamed to KinoEcto does 4 cool things around Ecto in Livebook. It builds Entity Relationship diagrams from the Ecto Schemas in your Elixir project. It can visualize the dense Postgres explain output and highlight a problem like when a full table scan is performed. It includes a ChangesetValidator SmartCell, and a QueryBuilder that uses NimbleParsec to parse a raw SQL query and do the initial work of turning that into an Ecto query. We talk about what the 48-hour competition was like, what they accomplished and what they plan to do next!

Show Notes online - http://podcast.thinkingelixir.com/127

Elixir Community News

• https://github.com/AdRoll/rebar3_hank – rebar3_hank detects dead code in Erlang projects and reports it.
• https://twitter.com/fiquscoop/status/1592539028578250757
• https://unused.codes/
• https://github.com/hauleth/mix_unused
• https://hexdocs.pm/ex_doc/cheatsheet.html – ExDoc v0.29.1 is out with initial support for media prints for cheatsheets
• https://twitter.com/josevalim/status/1594649732768489475
• https://github.com/pawurb/ecto_psql_extras/pull/31 – Add ability to gets all active connections to the database which can be displayed on the Phoenix LiveDashboard for Ecto.
• https://paraxial.io/blog/securing-elixir – Learned 2 additional CI checks to run on Elixir projects
• https://fly.io/phoenix-files/github-actions-for-elixir-ci/ – Mark's CI/CD guide was updated to include the new checks
• https://github.com/mirego/mix_audit
• https://hexdocs.pm/hex/Mix.Tasks.Hex.Audit.html –

  mix hex.audit

• https://twitter.com/nathanwillson/status/1594565494941458432 – Nathan Willson noticed that Chris recently updated the components in LiveBeats to use the new Phoenix 1.7 abilities
• https://github.com/fly-apps/live_beats/blob/master/lib/live_beats_web/components/core_components.ex – LiveBeats project with new core_components.ex file
• https://twitter.com/agundy_/status/1594558443125350400 – Aaron Gunderson created a really cool basic fly.io Phoenix Function as a Service with auto shutdown sample project.
• https://github.com/agundy/fly-faast
• https://adventofcode.com/2022 – Advent of Code 2022 starts on Dec 1st.
• https://www.elixirconf.eu/ – ElixirConf EU 2023 - in Lisbon Portugal. Hybrid conference 20-21 April 2023 - In person and virtual
• https://fosdem.org/2023/ – FOSDEM 2023 - Sunday, 5 February 2023 in Brussels, Belgium
• https://beam-fosdem.dev/ – BEAM specific gathering and devroom information
• https://elixirstatus.com/p/mJpKy-erlang-elixir-and-friends-devroom--fosdem-2023-call-for-talks
• http://elixirstream.dev – David moved the Elixir diffing project and other tools from utils.zest.dev to ElixirStream.dev
• https://twitter.com/bernheisel/status/1594549004687364098
• Starting in 2023, we may not include an interview with every episode. Still bringing you the news!

Do you have some Elixir news to share? Tell us at @ThinkingElixir or email at show@thinkingelixir.com

Discussion Resources

• https://spawnfest.org/
• https://github.com/spawnfest/lively – Spawnfest submission repo
• https://github.com/vorce/kino_ecto – Project continuing after competition
• https://forvillelser.vorce.se/posts/2022-11-11-spawnfest-kino-ecto-fka-lively.html – Blog post about Lively project
• https://twitter.com/filipecabaco/status/1581786455688777728 – Tweet about the project
• https://remote.com/
• https://supabase.com/
• https://www.talkdesk.com/
• https://github.com/dashbitco/nimble_parsec
• https://github.com/cocoa-xu/evision
• https://twitter.com/_uwu_cocoa
• https://github.com/sorentwo/oban
• https://twitter.com/thramosal – Teammate - Thiago Ramos
• https://twitter.com/vittoria_bitton – Teammate - Vittoria Bitton

Guest Information

• https://twitter.com/filipecabaco – Filipe Cabaço on Twitter
• https://github.com/filipecabaco/ – Filipe Cabaço on Github
• https://filipecabaco.com – Blog
• https://twitter.com/octavorce – Joel Carlbark on Twitter
• https://github.com/vorce/ – Joel Carlbark on Github
• https://forvillelser.vorce.se/ – Blog

Find us online

• Message the show - @ThinkingElixir
• Email the show - show@thinkingelixir.com
• Mark Ericksen - @brainlid
• David Bernheisel - @bernheisel
• Cade Ward - @cadebward

Sponsored By:

• Fly.io: Fly.io is a great place to deploy your next Phoenix application! Check them out!