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

127: Ecto gets Lively in Livebook

Thinking Elixir Podcast

127: Ecto gets Lively in Livebook