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

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

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.

Links for this episode:
https://www.cybertec-postgresql.com/en/pagination-problem-total-result-count/
https://sqlfordevs.com/returning-modified-rows
https://brandur.org/fragments/deleted-record-insert
https://dev.to/ftisiot/how-to-json-in-postgresqlr-1lj7
https://momjian.us/main/writings/pgsql/beyond.pdf
http://peter.eisentraut.org/blog/2023/01/11/postgresql-largest-commits
https://supabase.com/blog/postgres-foreign-data-wrappers-rust
https://medium.com/@walttonm/using-the-window-function-row-number-to-remove-duplicates-in-postgresql-5aef1edfb78c
https://pgdash.io/blog/horizontally-scaling-postgresql.html
https://www.percona.com/blog/upgrading-postgresql-extensions/
https://www.timescale.com/blog/a-postgresql-developers-perspective-six-interesting-patches-from-novembers-commitfest/
https://pganalyze.com/blog/5mins-postgres-16-pgbench-random-normal
https://www.depesz.com/2023/01/11/waiting-for-postgresql-16-invent-random_normal-to-provide-normally-distributed-random-numbers/
https://www.orioledata.com/blog/buffer-management/
https://github.com/orioledb/orioledb
https://www.crunchydata.com/blog/solving-advent-of-code-2022-using-postgres-day-11
https://www.crunchydata.com/blog/solving-advent-of-code-2022-using-postgres-day-12
https://www.crunchydata.com/blog/timezone-transformation-using-location-data-and-postgis
https://www.migops.com/blog/avoiding-constraint-violations-while-migrating-oracle-to-postgresql-date-data-type/
https://databaserookies.wordpress.com/2023/01/09/substr-functionality-differences-between-oracle-and-postgresql-what-you-need-to-know/
https://databaserookies.wordpress.com/2023/01/08/unleasing-boolean-data-type-casting-in-postgresql/
https://postgres.fm/episodes/copying-a-database
https://postgresql.life/post/francesco_tisiot/
https://www.rubberduckdevshow.com/episodes/69-adventures-in-note-taking/