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

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Elixir Mix

PostgreSQL Queries with Michael Fich - EMx 190

The Scale Is Not Just Hypothetical

Querying Query Repercussions of JSON B Columns

JSON, B to Records in PostgreSQL

Get the Snipdpodcast app

AI-poweredpodcast player

Discoverhighlights

Save anymoment

Share& Export

AI-poweredpodcast player

Discoverhighlights

Get the Snipd
podcast app

AI-powered
podcast player

Discover
highlights

Save any
moment

Share
& Export

AI-powered
podcast player

Discover
highlights