Elixir Mix

PostgreSQL Queries with Michael Fich - EMx 190

Sep 28, 2022

01:06:11

Creator website

Highlights

AI Chapters

Episode notes

The Scale Is Not Just Hypothetical

06:00

Querying Query Repercussions of JSON B Columns

02:03

JSON, B to Records in PostgreSQL

04:39

Introduction

2min

What Kind of Color Are I There?

2min

Elixir

4min

What's the Difference Between JSON B and JSON C?

2min

Will We Go This Way Again?

4min

Querying Query Repercussions of JSON B Columns

2min

JSON, B to Records in PostgreSQL

5min

The Challenge of Writing a Blog Post About JSON B to Record Set

2min

Is There a Difference Between Simple and Complex?

6min

10.

Is There a Way to Use a Transaction?

5min

11.

The Scale Is Not Just Hypothetical

6min

12.

Is Postgres a Performance Issue?

6min

13.

The Electric Community Is a Piece of Technology, Right?

3min

14.

Using PubSub From Postgres for Messages

4min

15.

Is There a Lightweight Event Bus Implementation With Postgres?

2min

16.

Postgres 14

3min

17.

Is There a Way to Extend Post GIS?

2min

18.

What's Happening With Tailwind?

2min

19.

Tailwind

5min

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.

In this episode…

Moving from Ruby to Elixir
theScore bet app and queries
Utilizing the Ecto schema
Key performance indicators and indexes
Increasing the scale at the Score
Pub/sub and Postgres

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.