Les meilleurs podcasts Postgresql (2024)

1
Local API Mocking, Flux & Accessibility, PostgreSQL, Web Dev Battles 1:00:20

1d ago1:00:20

1:00:20

In this episode, we cover the launch of Caleb’s Flux UI component library, and dive into the benefits of mocking APIs locally for faster development. We also highlight Aaron Francis’ new Postgres course, and wrap things up with the web dev battle YouTube channel and how a foodie app we built, QuizKnows, played a role in landing our first jobs. Show…

1
Optimizing For Analytics | Scaling Postgres 334 21:55

4d ago21:55

21:55

In this episode of Scaling Postgres, we discuss how to optimize your database for analytics, how to speed up counts, improvements to TimescaleDB and why you should stop using serial. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/334-optimizing-for-analytics/ Want to learn more about P…

1
Episode 279: SQL Server Migrations Demystified 1:03:07

6d ago1:03:07

1:03:07

If you use SQL Server, you will eventually have to migrate that instance somewhere – to a new version, a new server, the cloud . . . somewhere. Or perhaps you'll find yourself migrating from another database into SQL Server. No matter which way you slice it, SQL Server migrations can be daunting, not to mention complex and time-consuming. While we …

1
Planning time 42:17

6d ago42:17

42:17

Nikolay and Michael discuss planning time in Postgres — what it is, how to spot issues, its relationship to things like partitioning, and some tips for avoiding issues. Here are some links to things they mentioned: Query Planning (docs) https://www.postgresql.org/docs/current/runtime-config-query.html Are there limits to partition counts? (Blog pos…

1
Becoming a Postgres committer with Melanie Plageman 1:22:38

6d ago1:22:38

1:22:38

If you could work on anything, would you quit your job to pursue it? Postgres committer and major contributor Melanie Plageman joined Claire Giordano on this episode of the Talking Postgres podcast (formerly Path To Citus Con) to share her story about becoming a Postgres committer. Melanie pivoted from IT consulting to open-source development, driv…

1
When Select Writes! | Scaling Postgres 333 13:38

11d ago13:38

13:38

In this episode of Scaling Postgres, we discuss when select can write, Postgres RC1 is released, Tetris in SQL and copy, swap, drop. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/333-when-select-writes/ Want to learn more about Postgres performance? Join my FREE training called Postgr…

1
Slow count 43:25

13d ago43:25

43:25

Nikolay and Michael discuss why counting can be slow in Postgres, and what the options are for counting things quickly at scale. Here are some links to things they mentioned: Aggregate functions (docs) https://www.postgresql.org/docs/current/functions-aggregate.html PostgREST https://github.com/PostgREST/postgrest Get rid of count by default in Pos…

1
57 Million Reasons to Love Laravel 1:02:02

15d ago1:02:02

1:02:02

In this episode, Andy and Dalton dive into a wide array[] of topics, from Laravel's exciting $57 million funding to the buzz around FluxUI’s pricing drama and the much-anticipated features coming in Inertia 2.0. Along the way, they explore the need for a modernized PHP documentation (shoutout to Tim McDonald for his work!), a fun chat about Dalton’…

1
Sometimes It Is Slow? | Scaling Postgres 332 15:10

18d ago15:10

15:10

In this episode of Scaling Postgres, we discuss what can happen when queries get slow, backup best practices, Postgres emergencies and the state of Postgres survey. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/332-sometimes-it-is-slow/ Want to learn more about Postgres performance? J…

1
Skip scan 57:49

20d ago57:49

57:49

Michael and Nikolay are joined by Peter Geoghegan, major contributor and committer to Postgres, to discuss adding skip scan support to PostgreSQL over versions 17 and 18. Here are some links to things they mentioned: Peter Geoghegan https://postgres.fm/people/peter-geoghegan Peter’s previous (excellent) interview on Postgres TV https://www.youtube.…

1
The real jackpot is the Laravel community 53:35

24d ago53:35

53:35

This week, we're diving into all things post-Laracon! Andy shares his wild adventure just getting to Dallas with a few unexpected twists and turns along the way. We break down the highlights from Laracon, including the exciting announcements about Laravel Cloud and the amazing talks that left us inspired and ready to code. But what truly makes Lara…

1
Is pg_dump A Backup Tool? | Scaling Postgres 331 17:31

25d ago17:31

17:31

In this episode of Scaling Postgres, we discuss whether pg_dump is a backup tool, the pgMonitor extension, Postgres malware, and application uses for the merge command. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/331-is-pg_dump-a-backup-tool/ Want to learn more about Postgres perfor…

1
Postgres Emergency Room 45:27

27d ago45:27

45:27

Nikolay and Michael discuss PostgreSQL emergencies — both the psychological side of incident management, and some technical aspects too. Here are some links to things they mentioned: Site Reliability Engineering resources from Google https://sre.google GitLab Handbook SRE https://handbook.gitlab.com/job-families/engineering/infrastructure/site-reli…

1
Those aren't NBA players, just a bunch of nerdy developers 1:05:04

1M ago1:05:04

1:05:04

We dive into NullStar 2024, the ultimate basketball showdown between Team Laravel and the Terminal Boys. We share our admiration for Caleb Porzio (who’s definitely on Team Laravel!). Plus, we explore staying productive in development, Andy's ambitious idea to track all Laravel events, and Dalton's latest package release—Remote Models. If you're at …

1
Splicing Elephant & Duck DNA | Scaling Postgres 330 14:58

1M ago14:58

14:58

In this episode of Scaling Postgres, we discuss the merging of Postgres and DuckDB via the pg_duckdb extension, how this can help the analytics story for Postgres, some ways to improve PG analytics and building a search engine. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/330-splicin…

1
Get or Create 50:19

1M ago50:19

50:19

Michael and Nikolay are joined by Haki Benita, a technical lead and database enthusiast who writes an excellent blog and gives popular talks and training sessions too, to discuss the surprisingly complex topic of trying to implement “get or create” in PostgreSQL — handling issues around idempotency, concurrency, and bloat. Here are some links to th…

1
The gap between the last Standard Plan and Enterprise 1:06:49

1M ago1:06:49

1:06:49

This week, we dive into A/B testing and the challenges that come with the jump from the highest non-enterprise plan to full enterprise. We also discuss some Laravel shop talk, sharing the tools we've been using recently. Plus, Andy introduces his new podcast idea, where he plans to interview Laravel community members and explore their unique develo…

1
PGlite: Embeddable Postgres & postgres.new | Scaling Postgres 329 19:01

1M ago19:01

19:01

In this episode of Scaling Postgres, we discuss PGlite, an embeddable Postgres, postgres.new which adds AI features, new Postgres releases and the performance of synchronous replication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/329-pglite-embeddable-postgres/ Want to learn more a…

1
Getting started with benchmarking 56:32

1M ago56:32

56:32

Michael and Nikolay are joined by Melanie Plageman, database internals engineer at Microsoft and major contributor and committer to PostgreSQL, to discuss getting started with benchmarking — how it differs for users and developers of Postgres, how and when it comes up during development, some tools and lessons, as well as what she's working on at t…

1
About Us + What is Laravel building? 1:01:18

1M ago1:01:18

1:01:18

A little about us, why we love Laravel, and what the heck is Laravel building? Creators & Guests Andy Hinkle - Host Dalton McCleery - HostPar Andy Hinkle & Dalton McCleery

1
Implement Get Or Create | Scaling Postgres 328 16:10

2M ago16:10

16:10

In this episode of Scaling Postgres, we discuss different get or create implementations, a new pgBouncer version, alter default privileges, and six degrees of separation with Postgres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/328-implement-get-or-create/ Want to learn more about …

1
How I got started as a developer (& in Postgres) with David Rowley 1:29:08

2M ago1:29:08

1:29:08

Ever wonder how driving a forklift at a cheese factory could lead to a career in databases? Postgres committer David Rowley joined Claire Giordano on this episode of the Talking Postgres podcast (formerly Path To Citus Con) to share his story about how he got started as a developer and in Postgres. Could an unexpected job lead to your dream career?…

1
Index-Only Scans 39:15

2M ago39:15

39:15

Nikolay and Michael discuss Index-Only Scans in Postgres — what they are, how they help, some things to look out for, and some advice. Here are some links to things they mentioned: Index-Only Scans and Covering Indexes (docs) https://www.postgresql.org/docs/current/indexes-index-only-scans.html Discussion on Twitter about JIT and Parallel Query def…

1
Postgres Graph Queries | Scaling Postgres 327 16:30

2M ago16:30

16:30

In this episode of Scaling Postgres, we discuss using Postgres for graph queries, the fastest way to copy data from one table to another, dealing with linux memory overcommit and compression. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/327-postgres-graph-queries/ Want to learn more …

1
Why Postgres? 41:00

2M ago41:00

41:00

Nikolay and Michael discuss why they chose Postgres — as users, for their businesses, for their careers, as well as some doubts. Here are some links to things they mentioned: Our episode on why Postgres become popular https://postgres.fm/episodes/why-is-postgres-popular Database Systems: The Complete Book (by Hector Garcia-Molina, Jeff Ullman, and …

1
Episode 278: Running SQL Server on Azure VMs 1:04:29

2M ago1:04:29

1:04:29

Can you run SQL Server on Azure VM? Which VM is best? Is running SQL Server on a VM in Azure the right choice? Find out in this insightful episode with Anders Pedersen! With over 10 different SQL Server services now offered in Microsoft Azure, it can be difficult to know how you want to run your environment. Sometimes, the old ways are the best way…

1
Faster Index Creation | Scaling Postgres 326 20:28

2M ago20:28

20:28

In this episode of Scaling Postgres, we talk about speeding up index creation, extensions to track wait events, a row pattern recognition feature and savepoints. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/326-faster-index-creation/ Want to learn more about Postgres performance? Joi…

1
Tcp udp grpc quic 3:59

2M ago3:59

3:59

.

1
Compression 45:16

2M ago45:16

45:16

Nikolay and Michael discuss compression in Postgres — what's available natively, newer algorithms in recent versions, and several extensions with compression features. Here are some links to things they mentioned: wal_compression https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-WAL-COMPRESSION Our episode on WAL and checkpoint tu…

1
The What, Why, & How of Data Modeling with Dan Singerman 48:16

2M ago48:16

48:16

Today, we’re joined by Dan Singerman, founder and director of Reason Factory. He talks to us about why you should consider the user’s mental model when creating software, why it’s important to have consistent vernacular across your system, and more. Reason Factory Follow Dan on Twitter Chapters (00:36) - Dan’s background and what his consultancy do…

1
Faster Paging? | Scaling Postgres 325 20:07

2M ago20:07

20:07

In this episode of Scaling Postgres, we discuss more ways to keep the superior performance of keyset pagination, how to implement UUIDv7 in SQL functions, how expensive extended statistics are and the benefits of range columns. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/325-faster-…

1
Out of disk 43:26

2M ago43:26

43:26

Nikolay and Michael discuss Postgres running out of disk space — including what happens, what can cause it, how to recover, and most importantly, how to prevent it from happening in the first place. Here are some links to things they mentioned: Disk Full (docs) https://www.postgresql.org/docs/current/disk-full.html pgcompacttable https://github.com…

1
Episode 277: PostgreSQL for the SQL Server Crowd 1:02:29

2M ago1:02:29

1:02:29

Is testing out pgAdmin on your to-do list? In this episode of the podcast, we chat with Ryan Booz, a PostgreSQL advocate at Redgate, about how a SQL Server professional might begin a dive into PostgreSQL, one of the most popular open source databases in the world. Ryan came from a career background in SQL Server, but after experiencing his accident…

1
Four Million TPS | Scaling Postgres 324 16:29

2M ago16:29

16:29

In this episode of Scaling Postgres, we discuss experiments to achieve four million transaction per second, the importance of extended statistics, parallelism in Postgres and an introduction to window functions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/324-four-million-tps/ Want …

1
Podcasting about Postgres with Pino de Candia 1:24:09

3M ago1:24:09

1:24:09

Have you ever eavesdropped on other people’s conversations? Former co-host Pino de Candia joins Claire Giordano on this episode of Talking Postgres (formerly Path To Citus Con) to share their experience on podcasting about Postgres. Is listening to a podcast the next best thing to being in the hallway track at a conference? Does it bring the commun…

1
Postgres startup ecosystem 35:42

3M ago35:42

35:42

Nikolay and Michael discuss the Postgres startup ecosystem — some recent closures, some recent fundraising announcements, and their thoughts on where things are going and what they'd like to see. Here are some links to things they mentioned: Prediction from Dax Raad https://x.com/thdxr/status/1808972166752580039 OtterTune shut down https://x.com/an…

1
Simplifying Developers’ Lives with Ivar Østhus 44:14

3M ago44:14

44:14

Today, we’re joined by Ivar Østhus, CTO and co-founder of Unleash. He talks to us about the inspiration behind Unleash, why they have two different APIs in their platform, and more. Unleash Check out Unleash on GitHub Follow Ivar on Twitter Follow Unleash on Twitter Chapters (00:33) - What is Unleash? (01:05) - Tall tale about the inspiration behin…

1
PgBouncer Breaking Change | Scaling Postgres 323 23:47

3M ago23:47

23:47

In this episode of Scaling Postgres, we discuss a breaking change in the new version of PgBouncer, PostgreSQL 17 Beta 2 is released, examination of the new built-in collation provider in PG 17 and Notion's data lake. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/323-pgbouncer-breaking…

1
Four million TPS 45:50

3M ago45:50

45:50

Nikolay talks Michael through a recent experiment to find the current maximum transactions per second single-node Postgres can achieve — why he was looking into it, what bottlenecks occurred along the way, and ideas for follow up experiments. Here are some links to things they mentioned: How many TPS can we get from a single Postgres node? (Article…

1
Postgres Sort Instability? | Scaling Postgres 322 19:48

3M ago19:48

19:48

In this episode of Scaling Postgres, we discuss an incremental sort instability issue with the Postgres planner, whether we should use foreign keys, how the visibility map works and how to vacuum the template0 database. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/322-postgres-sort-i…

1
Soft delete 37:40

3M ago37:40

37:40

Nikolay and Michael discuss soft deletion in Postgres — what it means, several use cases, some implementation options, and which implementations suit which use cases. Here are some links to things they mentioned: Soft deletion probably isn't worth it (blog post by Brandur) https://brandur.org/soft-deletion Easy alternative soft deletion (blog post …

1
Demystifying DNS with Anthony Eden 42:07

3M ago42:07

42:07

Today, we’re joined by Anthony Eden, co-founder of DNSimple. He talks to us about the difference between DNS and domain registration, what ephemeral data is, and more. DNSimple How DNS Works Follow Anthony on Twitter Connect with Anthony on LinkedIn Chapters (00:35) - What is DNSimple? (01:24) - DNS versus domain registration (02:44) - DNSimple’s t…

1
Ottertune Is Dead! | Scaling Postgres 321 11:02

3M ago11:02

11:02

In this episode of Scaling Postgres, we discuss the shutdown of Ottertune, how schema changes cause locks and how to avoid them, the benefits of on conflic do nothing, and pgvectorscale. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/321-ottertune-is-dead/ Want to learn more about Post…

1
Kibana KQL vs. Lucene 2:18

3M ago2:18

2:18

.

1
The Making of POSETTE: An Event for Postgres with Teresa Giacomini & Aaron Wislang 1:35:04

3M ago1:35:04

1:35:04

It’s not a conference unless you can confer, right? POSETTE organizers Teresa Giacomini and Aaron Wislang join Claire Giordano on the Path To Citus Con* podcast to share backstage perspectives on the making of POSETTE: An Event for Postgres. How do you feel about captions: love or hate? Should livestream talks be pre-recorded or presented live? Why…

1
Should we use foreign keys? 51:21

3M ago51:21

51:21

Nikolay and Michael discuss foreign keys in Postgres — what they are, their benefits, their overhead, some edge cases to be aware of, some improvements coming, and whether or not they generally recommend using them. Here are some links to things they mentioned: Foreign keys (docs) https://www.postgresql.org/docs/current/ddl-constraints.html#DDL-CON…

1
100 TB and Beyond! | Scaling Postgres 320 17:32

3M ago17:32

17:32

In this episode of Scaling Postgres, we discuss three organizations scaling their databases to 100 TB and beyond, collation speed, configuring memory and new AI extensions To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/320-100tb-and-beyond/ Want to learn more about Postgres performance…

1
pgvectorscale 55:27

3M ago55:27

55:27

Nikolay is joined by Mat Arye and John Pruitt, from Timescale, to discuss their new extension pgvectorscale and high-performance vector search in Postgres more generally. Main links: https://github.com/timescale/pgvectorscale https://www.timescale.com/blog/pgvector-vs-pinecone https://postgres.fm/people/matvey-arye https://postgres.fm/people/john-p…

1
Signals 3:19

3M ago3:19

3:19

.

1
Navigating Geodata with Mathias Hansen 46:10

4M ago46:10

46:10

Today, we’re joined by Mathias Hansen, co-founder of Geocodio. He talks to us about the challenges of dealing with geodata, how opening up data helps improve accuracy for everyone, and more. Geocodio Follow Mathias on Twitter Chapters (00:52) - What is Geocodio? (04:01) - Geocodio’s tech stack (06:46) - Data models and flexible pricing (10:13) - Ch…

Podcasts qui valent la peine d'être écoutés

Postgresql Podcasts

Podcasts qui valent la peine d'être écoutés

Guide de référence rapide