In this episode of Scaling Postgres, we discuss JSONB vs. window functions, a Postgres security checklist, implementing full-text search and using NFL timeseries data.

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

Links for this episode:

https://swarm64.com/post/postgresql-jsonb-vs-window-functions/

https://www.cybertec-postgresql.com/en/postgresql-security-things-to-avoid-in-real-life/

https://blog.crunchydata.com/blog/postgres-full-text-search-a-search-engine-in-a-database

https://blog.timescale.com/blog/hacking-nfl-data-with-postgresql-timescaledb-and-sql/

https://ardentperf.com/2021/07/26/postgresql-logical-replicas-and-snapshots-proceed-carefully/

https://www.pgmustard.com/blog/max-parallel-workers-per-gather

https://fluca1978.github.io/2021/07/27/pgbackrestAsync.html

https://b-peng.blogspot.com/2021/07/deploying-pgpool2-exporter-with-docker.html

https://www.percona.com/blog/improve-postgresql-query-performance-insights-with-pg_stat_monitor/

https://postgresql.life/post/roman_druzyagin/

https://www.rubberduckdevshow.com/episodes/6-handling-exceptions/