Episode 248 Pagination Solutions, Return Modifications, Insert Deletions, How To JSON

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://www.cybertec-postgresql.com/en/pagination-problem-total-result-count/"> https://www.cybertec-postgresql.com/en/pagination-problem-total-result-count/</a></li> <li><a href= "https://sqlfordevs.com/returning-modified-rows">https://sqlfordevs.com/returning-modified-rows</a></li> <li><a href= "https://brandur.org/fragments/deleted-record-insert">https://brandur.org/fragments/deleted-record-insert</a></li> <li><a href= "https://dev.to/ftisiot/how-to-json-in-postgresqlr-1lj7">https://dev.to/ftisiot/how-to-json-in-postgresqlr-1lj7</a></li> <li><a href= "https://momjian.us/main/writings/pgsql/beyond.pdf">https://momjian.us/main/writings/pgsql/beyond.pdf</a></li> <li><a href= "http://peter.eisentraut.org/blog/2023/01/11/postgresql-largest-commits"> http://peter.eisentraut.org/blog/2023/01/11/postgresql-largest-commits</a></li> <li><a href= "https://supabase.com/blog/postgres-foreign-data-wrappers-rust">https://supabase.com/blog/postgres-foreign-data-wrappers-rust</a></li> <li><a href= "https://medium.com/@walttonm/using-the-window-function-row-number-to-remove-duplicates-in-postgresql-5aef1edfb78c"> https://medium.com/@walttonm/using-the-window-function-row-number-to-remove-duplicates-in-postgresql-5aef1edfb78c</a></li> <li><a href= "https://pgdash.io/blog/horizontally-scaling-postgresql.html">https://pgdash.io/blog/horizontally-scaling-postgresql.html</a></li> <li><a href= "https://www.percona.com/blog/upgrading-postgresql-extensions/">https://www.percona.com/blog/upgrading-postgresql-extensions/</a></li> <li><a href= "https://www.timescale.com/blog/a-postgresql-developers-perspective-six-interesting-patches-from-novembers-commitfest/"> https://www.timescale.com/blog/a-postgresql-developers-perspective-s