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 (http://podcast.thinkingelixir.com/127)
Elixir Community News
- https://github.com/AdRoll/rebar3_hank (https://github.com/AdRoll/rebar3_hank) – rebar3hank detects dead code in Erlang projects and reports it.
- https://twitter.com/fiquscoop/status/1592539028578250757 (https://twitter.com/fiquscoop/status/1592539028578250757)
- https://unused.codes/ (https://unused.codes/)
- https://github.com/hauleth/mix_unused (https://github.com/hauleth/mix_unused)
- https://hexdocs.pm/ex_doc/cheatsheet.html (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://twitter.com/josevalim/status/1594649732768489475)
- https://github.com/pawurb/ectopsqlextras/pull/31 (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 (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/ (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://github.com/mirego/mix_audit)
- https://hexdocs.pm/hex/Mix.Tasks.Hex.Audit.html (https://hexdocs.pm/hex/Mix.Tasks.Hex.Audit.html) – mix hex.audit
- https://twitter.com/nathanwillson/status/1594565494941458432 (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/livebeats/blob/master/lib/livebeatsweb/components/corecomponents.ex (https://github.com/fly-apps/live_beats/blob/master/lib/live_beats_web/components/core_components.ex) – LiveBeats project with new corecomponents.ex file
- https://twitter.com/agundy_/status/1594558443125350400 (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://github.com/agundy/fly-faast)
- https://adventofcode.com/2022 (https://adventofcode.com/2022) – Advent of Code 2022 starts on Dec 1st.
- https://www.elixirconf.eu/ (https://www.elixirconf.eu/) – ElixirConf EU 2023 - in Lisbon Portugal. Hybrid conference 20-21 April 2023 - In person and virtual
- https://fosdem.org/2023/ (https://fosdem.org/2023/) – FOSDEM 2023 - Sunday, 5 February 2023 in Brussels, Belgium
- https://beam-fosdem.dev/ (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 (https://elixirstatus.com/p/mJpKy-erlang-elixir-and-friends-devroom--fosdem-2023-call-for-talks)
- http://elixirstream.dev (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 (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 (https://twitter.com/ThinkingElixir) or email at [email protected] (mailto:[email protected])
Discussion Resources
- https://spawnfest.org/ (https://spawnfest.org/)
- https://github.com/spawnfest/lively (https://github.com/spawnfest/lively) – Spawnfest submission repo
- https://github.com/vorce/kino_ecto (https://github.com/vorce/kino_ecto) – Project continuing after competition
- https://forvillelser.vorce.se/posts/2022-11-11-spawnfest-kino-ecto-fka-lively.html (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 (https://twitter.com/filipecabaco/status/1581786455688777728) – Tweet about the project
- https://remote.com/ (https://remote.com/)
- https://supabase.com/ (https://supabase.com/)
- https://www.talkdesk.com/ (https://www.talkdesk.com/)
- https://github.com/dashbitco/nimble_parsec (https://github.com/dashbitco/nimble_parsec)
- https://github.com/cocoa-xu/evision (https://github.com/cocoa-xu/evision)
- https://twitter.com/uwucocoa (https://twitter.com/_uwu_cocoa)
- https://github.com/sorentwo/oban (https://github.com/sorentwo/oban)
- https://twitter.com/thramosal (https://twitter.com/thramosal) – Teammate - Thiago Ramos
- https://twitter.com/vittoria_bitton (https://twitter.com/vittoria_bitton) – Teammate - Vittoria Bitton
Guest Information
- https://twitter.com/filipecabaco (https://twitter.com/filipecabaco) – Filipe Cabaço on Twitter
- https://github.com/filipecabaco/ (https://github.com/filipecabaco/) – Filipe Cabaço on Github
- https://filipecabaco.com (https://filipecabaco.com) – Blog
- https://twitter.com/octavorce (https://twitter.com/octavorce) – Joel Carlbark on Twitter
- https://github.com/vorce/ (https://github.com/vorce/) – Joel Carlbark on Github
- https://forvillelser.vorce.se/ (https://forvillelser.vorce.se/) – Blog
Find us online
- Message the show - @ThinkingElixir (https://twitter.com/ThinkingElixir)
- Email the show - [email protected] (mailto:[email protected])
- Mark Ericksen - @brainlid (https://twitter.com/brainlid)
- David Bernheisel - @bernheisel (https://twitter.com/bernheisel)
- Cade Ward - @cadebward (https://twitter.com/cadebward)

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 [email protected]

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 - [email protected]
Mark Ericksen - @brainlid
David Bernheisel - @bernheisel
Cade Ward - @cadebward

Sponsored By: