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

          31 ratings

          More shows like Thinking Elixir Podcast

          View all
          The Changelog: Software Development, Open Source by Changelog Media

          The Changelog: Software Development, Open Source

          285 Listeners

          Startups For the Rest of Us by Rob Walling

          Startups For the Rest of Us

          694 Listeners

          Software Engineering Daily by Software Engineering Daily

          Software Engineering Daily

          629 Listeners

          Go Time: Golang, Software Engineering by Changelog Media

          Go Time: Golang, Software Engineering

          128 Listeners

          JS Party: JavaScript, CSS, Web Development by Changelog Media

          JS Party: JavaScript, CSS, Web Development

          92 Listeners

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

          Syntax - Tasty Web Development Treats

          986 Listeners

          REWORK by 37signals

          REWORK

          212 Listeners

          CoRecursive: Coding Stories by Adam Gordon Bell - Software Developer

          CoRecursive: Coding Stories

          185 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

          63 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

          Elixir Friends by German Velasco

          Elixir Friends

          0 Listeners