
127: Ecto gets Lively in Livebook
Thinking Elixir Podcast
Elixir Phoenix - New Features in GitHub Actions
Michael Lewis: ectosql extras got a new feature. He says paraxial has added the option now to see in Phoenix live dashboard all of your active Postgres connections. There's links to how to optimize and just all sorts of good stuff there, he says. Lewis also posted a CI CD guide for elixir projects using GitHub actions.
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: