Thinking Elixir Podcast

127: Ecto gets Lively in Livebook

Listen Later

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:

          • Fly.io: Fly.io is a great place to deploy your next Phoenix application! Check them out!
          ...more
          View all episodesView all episodes
          Download on the App Store
          Thinking Elixir PodcastBy ThinkingElixir.com
          • 4.9
          • 4.9
          • 4.9
          • 4.9
          • 4.9

          4.9

          32 ratings

          More shows like Thinking Elixir Podcast

          View all
          Hanselminutes with Scott Hanselman by Scott Hanselman

          Hanselminutes with Scott Hanselman

          377 Listeners

          Software Engineering Radio - the podcast for professional software developers by se-radio@computer.org

          Software Engineering Radio - the podcast for professional software developers

          272 Listeners

          The Changelog: Software Development, Open Source by Changelog Media

          The Changelog: Software Development, Open Source

          283 Listeners

          Talk Python To Me by Michael Kennedy

          Talk Python To Me

          592 Listeners

          Software Engineering Daily by Software Engineering Daily

          Software Engineering Daily

          624 Listeners

          Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

          Syntax - Tasty Web Development Treats

          982 Listeners

          REWORK by 37signals

          REWORK

          211 Listeners

          CoRecursive: Coding Stories by Adam Gordon Bell - Software Developer

          CoRecursive: Coding Stories

          189 Listeners

          Elixir Mix by Charles M Wood

          Elixir Mix

          13 Listeners

          Elixir Wizards by SmartLogic LLC

          Elixir Wizards

          22 Listeners

          The Stack Overflow Podcast by The Stack Overflow Podcast

          The Stack Overflow Podcast

          64 Listeners

          Beam Radio by Lars Wikman

          Beam Radio

          11 Listeners

          Oxide and Friends by Oxide Computer Company

          Oxide and Friends

          47 Listeners

          Elixir Mentor by Jacob Luetzow

          Elixir Mentor

          2 Listeners

          The Pragmatic Engineer by Gergely Orosz

          The Pragmatic Engineer

          52 Listeners