ÜBER DIESE EPISODE
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 things they mentioned:
- Haki Benita https://hakibenita.com
- How to Get or Create in PostgreSQL (blog post by Haki) https://hakibenita.com/postgresql-get-or-create
- "Find-or-insert" using a single query (how-to guide by Nikolay) https://gitlab.com/postgres-ai/postgresql-consulting/postgres-howtos/-/blob/main/0036_find-or-insert_using_a_single_query.md?ref_type=heads
- Is SELECT or INSERT in a function prone to race conditions? (Answer by Erwin Brandstetter) https://stackoverflow.com/questions/15939902/is-select-or-insert-in-a-function-prone-to-race-conditions/15950324#15950324
- get_or_create() in Django https://docs.djangoproject.com/en/5.1/ref/models/querysets/#get-or-create
- Subtransactions Considered Harmful (blog post by Nikolay) https://postgres.ai/blog/20210831-postgresql-subtransactions-considered-harmful
- MERGE (Postgres documentation) https://www.postgresql.org/docs/current/sql-merge.html
- Hidden dangers of duplicate key violations in PostgreSQL and how to avoid them (blog post by Divya Sharma and Shawn McCoy from the RDS team) https://aws.amazon.com/blogs/database/hidden-dangers-of-duplicate-key-violations-in-postgresql-and-how-to-avoid-them/
- One, Two, Skip a Few... (blog post by Pete Hamilton from Incident) https://incident.io/blog/one-two-skip-a-few
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is produced by:
- Michael Christofides, founder of pgMustard
- Nikolay Samokhvalov, founder of Postgres.ai
With special thanks to:
- Jessie Draws for the elephant artwork
Englisch
Vereinigte Staaten
IN DIESER FOLGE
TRANSKRIPT 🔗
1
00:00:00,060 --> 00:00:02,720
Michael: Hello and welcome to Postgres.FM, a weekly show about
2
00:00:02,720 --> 00:00:03,660
all things PostgreSQL.
3
00:00:03,900 --> 00:00:05,660
I am Michael, founder of pgMustard.
4
00:00:05,660 --> 00:00:08,080
This is my co-host, Nikolay, founder of Postgres.AI.
5
00:00:08,200 --> 00:00:08,940
Hey Nikolay.
6
00:00:09,360 --> 00:00:10,100
Nikolay: Hi Michael.
7
00:00:10,180 --> 00:00:10,980
How are you?
8
00:00:11,260 --> 00:00:11,520
Michael: Good.
…
00:00:00,060 --> 00:00:02,720
Michael: Hello and welcome to Postgres.FM, a weekly show about
2
00:00:02,720 --> 00:00:03,660
all things PostgreSQL.
3
00:00:03,900 --> 00:00:05,660
I am Michael, founder of pgMustard.
4
00:00:05,660 --> 00:00:08,080
This is my co-host, Nikolay, founder of Postgres.AI.
5
00:00:08,200 --> 00:00:08,940
Hey Nikolay.
6
00:00:09,360 --> 00:00:10,100
Nikolay: Hi Michael.
7
00:00:10,180 --> 00:00:10,980
How are you?
8
00:00:11,260 --> 00:00:11,520
Michael: Good.
…
VERGANGENE FOLGEN SUCHEN
Vorhandene Folgen von Postgres FM durchsuchen.
Rechtliche Hinweise: Der auf dieser Seite eingebettete Podcast und das Bildmaterial stammen von Nikolay Samokhvalov and Michael Christofides, das Eigentum seines Eigentümers ist und nicht mit Listen Notes, Inc. verbunden ist oder von diesen unterstützt wird.
BEARBEITEN
Vielen Dank, dass Sie uns helfen, die Podcast-Datenbank auf dem neuesten Stand zu halten.