Scaling Postgres Episode 248 Pagination Solution, Return Modification, Insert Deletions, How To JSON

To get the show notes as well as get notified of new episodes, visit:

In this episode of Scaling Postgres, we discuss different pagination solutions, how to return modifications, soft deletion alternatives and how to use JSON with PostgreSQL.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:29 - Pagination and the problem of the total result count
05:25 - RETURNING Modified Rows
06:07 - Easy, alternative soft deletion: `deleted_record_insert`
07:52 - How to JSON in PostgreSQL®
08:14 - Beyond Joins and Indexes
08:47 - PostgreSQL largest commits
09:45 - Supabase Wrappers, a Postgres FDW framework written in Rust
10:45 - Horizontally Scaling PostgreSQL
11:36 - Upgrading PostgreSQL Extensions
11:51 - A PostgreSQL Developer's Perspective: Six Interesting Patches From November's Commitfest
12:45 - Using pgbench to load data faster, and the random_normal function in PG16
13:08 - Waiting for PostgreSQL 16 – Invent random_normal() to provide normally-distributed random numbers.
13:31 - Rethinking buffer mapping for modern hardware architectures
13:39 - OrioleDB Github
14:42 - How to Solve Advent of Code 2022 Using Postgres - Day 11
14:50 - How to Solve Advent of Code 2022 Using Postgres - Day 12
14:56 - Timezone Transformation Using Location Data & PostGIS
15:23 - Avoiding Constraint violations while migrating Oracle to PostgreSQL – DATE data type
15:37 - SUBSTR Functionality Differences Between Oracle and PostgreSQL: What You Need to Know
15:49 - Unleasing Boolean data type casting in PostgreSQL.
16:00 - Copying a database
16:15 - Francesco Tisiot
16:26 - Rubber Duck Dev Show Episode 69 | Adventures in Note Taking with Seb Wilgosz
16:54 - Outro

#postgres #postgresql

[Elvis-is-king-ls]

Thank you! Very well explained and valuable sources of information. I think I missed 247 episodes. I have a lot of catch up to do!