127: Ecto gets Lively in Livebook
Thinking Elixir Podcast
Using Heuristics to Identify Patterns
It tells you what the database is planning to do with the query. Typically, you'd use it to debug or troubleshoot like performance bottlenecks in your queries. Visualizing that is extremely helpful, I think. And also you can add some heuristics to it. Like, oh, this is probably a pattern where you might want to look into for whatever reason.
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:
The AI-powered Podcast Player
