Search

Home > Scaling Postgres > Episode 248 Pagination Solutions, Return Modifications, Insert Deletions, How To JSON


	Podcast:		Scaling Postgres
	Episode:		Episode 248 Pagination Solutions, Return Modifications, Insert Deletions, How To JSON
	Category:		Technology
	Duration:		00:17:21
	Publish Date:		2023-01-15 23:08:00
	Description:		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/
	Total Play:		0