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.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
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/