PostgreSQL Queries with Michael Fich - EMx 190

<div class="trix-content"> <div>Michael Fich joins the show today to share how he implemented the PostgreSQL schema to enhance the Elixir workflows at his organization, the Score, based in Toronto Canada.  Sascha and Allen also provide additional insights and deep dive into their experience with PostgreSQL models.<br><br> </div><h1>In this episode…</h1><div><br></div><ul> <li>Moving from Ruby to Elixir </li> <li>theScore bet app and queries</li> <li>Utilizing the Ecto schema</li> <li>Key performance indicators and indexes</li> <li>Increasing the scale at the Score</li> <li>Pub/sub and Postgres<br><br> </li> </ul><h1>Sponsors</h1><ul> <li><a href="https://topenddevs.com/">Top End Devs</a></li> <li><a href="https://topenddevs.com/coaching">Coaching | Top End Devs</a></li> </ul><div><br></div><h1>Links</h1><ul> <li><a href="https://techblog.thescore.com/2022/06/23/embedded-schema-queries-with-ecto/">PostgreSQL Queries on JSONB Fields with Ecto</a></li> <li><a href="https://www.linkedin.com/in/michaelfich/">LinkedIn: Michael Fich</a></li> <li><a href="https://twitter.com/michael_fich">Twitter: @michael_fich</a></li> </ul><div><br></div><h1>Picks</h1><ul> <li>Allen- <a href="https://www.youtube.com/watch?v=9-rqBLjr5Eo">ElixirConf 2022 - Chris McCord - Phoenix + LiveView Updates</a> </li> <li>Michael- <a href="https://theathletic.com/location/toronto/">Toronto Sports News - Scores, Schedules, Expert Analysis - Blue Jays, Argonauts, Toronto FC, Raptors, Maple Leafs, and more... - The Athletic</a> </li> <li>Sascha- <a href="https://www.kickstarter.com/projects/humanthings/genki-waveform">GENKI Waveform Earphones</a> </li> </ul> </div>